Search
Hall of Fame
About Us
All Questions
New Question
Login
C#
VB
ASP.NET
XAML
WCF
LINQ
SQL
IIS
Excel
Word
Access
SharePoint
SQL
Windows 7
All 76 Topics
Biography - Pat Hartman
My company specializes in developing professional grade Access applications for businesses of all sizes. I am also a former MS Access MVP.
0
Replies
re: ACCESS Data Normalization
( 0 views ) Submitted By
Pat Hartman
on 30-Dec-12 06:49 PM in
Microsoft Access
.
0
Replies
re: Calculated fields?
( 0 views ) Submitted By
Pat Hartman
on 30-Dec-12 06:46 PM in
Microsoft Access
.
0
Replies
re: How to create multiple table records from form based on dates
( 0 views ) Submitted By
Pat Hartman
on 30-Dec-12 06:36 PM in
Microsoft Access
.
0
Replies
re: I get Error "No unique index found for the referenced field of the primary value"
( 0 views ) Submitted By
Pat Hartman
on 30-Dec-12 06:31 PM in
Microsoft Access
.
0
Replies
re: I have csv files to import into a single table.i want to get rid of the 1st 3 rows in csv.
( 0 views ) Submitted By
Pat Hartman
on 30-Dec-12 06:19 PM in
Microsoft Access
.
0
Replies
re: Access 2007 how to set read only permissions to a linked table
( 0 views ) Submitted By
Pat Hartman
on 30-Dec-12 06:15 PM in
Microsoft Access
.
0
Replies
re: access program
( 0 views ) Submitted By
Pat Hartman
on 30-Dec-12 04:37 PM in
Microsoft Access
.
0
Replies
re: How do you search a table from a form with a checkbox on a multiple value field
( 0 views ) Submitted By
Pat Hartman
on 30-Dec-12 04:35 PM in
Microsoft Access
.
0
Replies
re: Crosstab typed incorrectly or is too complex
( 0 views ) Submitted By
Pat Hartman
on 30-Dec-12 04:33 PM in
Microsoft Access
.
0
Replies
re: page of tabcontrol visible if subform has records
( 0 views ) Submitted By
Pat Hartman
on 30-Dec-12 12:39 PM in
Microsoft Access
.
0
Replies
re: Access 2010, "Forms", "Design Button Tool", the "Command Button Wizard" does not appear.
( 0 views ) Submitted By
Pat Hartman
on 09-Sep-12 11:11 PM in
Microsoft Access
.
0
Replies
re: Can I make a form's combobox query a lookup based of a another combobox's value?
( 0 views ) Submitted By
Pat Hartman
on 09-Sep-12 11:09 PM in
Microsoft Access
.
0
Replies
re: Hide objects on specific pages
( 0 views ) Submitted By
Pat Hartman
on 09-Sep-12 10:58 PM in
Microsoft Access
.
0
Replies
re: How to write a SP for one to many relationship data
( 0 views ) Submitted By
Pat Hartman
on 27-Aug-12 05:26 PM in
SQL Server
.
0
Replies
re: Showing all record numbers, then increment by 1 for new row
( 0 views ) Submitted By
Pat Hartman
on 22-Aug-12 10:26 PM in
Microsoft Access
.
0
Replies
re: calculating percentage from two subqueries
( 0 views ) Submitted By
Pat Hartman
on 12-Aug-12 06:33 PM in
Microsoft Access
.
0
Replies
re: Syntax error on SQL Subquery
( 0 views ) Submitted By
Pat Hartman
on 29-Jul-12 06:07 PM in
Microsoft Access
.
0
Replies
re: Is there any other way on how to display values to textboxes using internal syntax?
( 0 views ) Submitted By
Pat Hartman
on 29-Jul-12 05:57 PM in
Microsoft Access
.
0
Replies
re: Create an Inner Join Maketable DoCmd.RunSQL
( 0 views ) Submitted By
Pat Hartman
on 25-Jul-12 04:12 PM in
Microsoft Access
.
0
Replies
re: Unable to return all records in query when combobox is blank
( 0 views ) Submitted By
Pat Hartman
on 25-Jul-12 04:05 PM in
Microsoft Access
.
0
Replies
re: Unable to return all records in query when combobox is blank
( 0 views ) Submitted By
Pat Hartman
on 25-Jul-12 04:01 PM in
Microsoft Access
.
0
Replies
re: Can a parameter query be opened through vba?
( 0 views ) Submitted By
Pat Hartman
on 25-Jul-12 03:58 PM in
Microsoft Access
.
0
Replies
re: Print separate pdf reports by groups using a command button.
( 0 views ) Submitted By
Pat Hartman
on 25-Jul-12 03:50 PM in
Microsoft Access
.
0
Replies
re: Access Query
( 0 views ) Submitted By
Pat Hartman
on 18-Jul-12 08:20 PM in
Microsoft Access
.
1
Reply
re: How do I write a query which calculates the number of minutes between two hour:min fields?
( 1 views ) Submitted By
Pat Hartman
on 18-Jul-12 08:12 PM in
Microsoft Access
.
2
Replies
re: Unable to return all records in query when combobox is blank
( 2 views ) Submitted By
Pat Hartman
on 18-Jul-12 08:08 PM in
Microsoft Access
.
1
Reply
re: Unable to return all records in query when combobox is blank
( 1 views ) Submitted By
Pat Hartman
on 18-Jul-12 08:05 PM in
Microsoft Access
.
1
Reply
re: Calculated fields in sub report do not show in main report
( 1 views ) Submitted By
Pat Hartman
on 04-Jul-12 10:39 PM in
Microsoft Access
.
0
Replies
re: Convert Dlookup Query to VBA coding
( 0 views ) Submitted By
Pat Hartman
on 04-Jul-12 10:30 PM in
Microsoft Access
.
0
Replies
re: Changing the recordsource or dynamically hiding columns of a query
( 0 views ) Submitted By
Pat Hartman
on 28-Jun-12 08:29 PM in
Microsoft Access
.
0
Replies
re: Help on storing a calculated field from form in table
( 0 views ) Submitted By
Pat Hartman
on 28-Jun-12 08:24 PM in
Microsoft Access
.
0
Replies
re: sql joining query performance is slow
( 0 views ) Submitted By
Pat Hartman
on 08-Jun-12 02:31 PM in
SQL Server
.
0
Replies
re: convert sql database to ms access
( 0 views ) Submitted By
Pat Hartman
on 08-Jun-12 02:26 PM in
SQL Server
.
0
Replies
re: The Infamous WRITE CONFLICT Error.
( 0 views ) Submitted By
Pat Hartman
on 08-Jun-12 02:17 PM in
Microsoft Access
.
3
Replies
re: The Infamous WRITE CONFLICT Error.
( 3 views ) Submitted By
Pat Hartman
on 08-Jun-12 02:14 PM in
Microsoft Access
.
1
Reply
re: back to the abc's -- storing useful code
( 1 views ) Submitted By
Pat Hartman
on 08-Jun-12 02:03 PM in
Microsoft Access
.
1
Reply
re: Convert Dlookup Query to VBA coding
( 1 views ) Submitted By
Pat Hartman
on 08-Jun-12 01:51 PM in
Microsoft Access
.
0
Replies
re: Salvare report in pdf suddivisi
( 0 views ) Submitted By
Pat Hartman
on 02-Jun-12 10:52 AM in
Microsoft Access
.
0
Replies
re: Salvare report in pdf suddivisi
( 0 views ) Submitted By
Pat Hartman
on 02-Jun-12 10:48 AM in
Microsoft Access
.
1
Reply
re: If statement with Tabs
( 1 views ) Submitted By
Pat Hartman
on 01-Jun-12 12:45 AM in
Microsoft Access
.
0
Replies
re: Archiving old data
( 0 views ) Submitted By
Pat Hartman
on 27-May-12 03:23 PM in
Microsoft Access
.
0
Replies
re: Access logbook
( 0 views ) Submitted By
Pat Hartman
on 27-May-12 12:06 AM in
Microsoft Access
.
1
Reply
re: distinct count
( 1 views ) Submitted By
Pat Hartman
on 26-May-12 11:57 PM in
Microsoft Access
.
0
Replies
re: MS Access version 2002 in WIN7 with Office 2010
( 0 views ) Submitted By
Pat Hartman
on 26-May-12 11:41 PM in
Microsoft Access
.
0
Replies
re: type conversion failure error importing from csv file into access
( 0 views ) Submitted By
Pat Hartman
on 20-May-12 04:53 PM in
Microsoft Access
.
1
Reply
re: Archiving old data
( 1 views ) Submitted By
Pat Hartman
on 20-May-12 04:47 PM in
Microsoft Access
.
0
Replies
re: Records in Table Disappearing...HELP!
( 0 views ) Submitted By
Pat Hartman
on 20-May-12 04:37 PM in
Microsoft Access
.
1
Reply
re: Recalling data on a form for editing
( 1 views ) Submitted By
Pat Hartman
on 20-May-12 04:29 PM in
Microsoft Access
.
0
Replies
re: get all data of particular id from excel sheet
( 0 views ) Submitted By
Pat Hartman
on 10-May-12 03:28 PM in
C# .NET
.
1
Reply
re: how to share data between users
( 1 views ) Submitted By
Pat Hartman
on 10-May-12 03:25 PM in
ASP.NET
.
2
Replies
re: Append Query & Dmax()
( 2 views ) Submitted By
Pat Hartman
on 10-May-12 03:18 PM in
Microsoft Access
.
0
Replies
re: Append Query & Dmax()
( 0 views ) Submitted By
Pat Hartman
on 10-May-12 03:11 PM in
Microsoft Access
.
0
Replies
re: write conflict error
( 0 views ) Submitted By
Pat Hartman
on 10-May-12 03:01 PM in
Microsoft Access
.
1
Reply
re: Insert./Update record into the database
( 1 views ) Submitted By
Pat Hartman
on 07-May-12 02:58 PM in
Entity Framework
.
1
Reply
re: OpenReport
( 1 views ) Submitted By
Pat Hartman
on 07-May-12 02:55 PM in
Microsoft Access
.
0
Replies
re: sql discus
( 0 views ) Submitted By
Pat Hartman
on 06-May-12 06:49 PM in
SQL Server
.
1
Reply
re: Insert./Update record into the database
( 1 views ) Submitted By
Pat Hartman
on 06-May-12 06:44 PM in
Entity Framework
.
0
Replies
re: Date Validation
( 0 views ) Submitted By
Pat Hartman
on 06-May-12 06:39 PM in
Microsoft Access
.
0
Replies
re: A Query to Show Which Records are Absent from a Table
( 0 views ) Submitted By
Pat Hartman
on 06-May-12 06:37 PM in
Microsoft Access
.
0
Replies
re: increase query timeouts
( 0 views ) Submitted By
Pat Hartman
on 06-May-12 06:34 PM in
Microsoft Access
.
1
Reply
re: OpenReport
( 1 views ) Submitted By
Pat Hartman
on 06-May-12 06:28 PM in
Microsoft Access
.
1
Reply
re: Comparing two tables having four similar fields
( 1 views ) Submitted By
Pat Hartman
on 06-May-12 06:22 PM in
Microsoft Access
.
3
Replies
re: Need codes for vbscript
( 3 views ) Submitted By
Pat Hartman
on 06-May-12 06:16 PM in
Other Issues
.
2
Replies
re: increase query timeouts
( 2 views ) Submitted By
Pat Hartman
on 04-May-12 12:18 AM in
Microsoft Access
.
1
Reply
re: A Query to Show Which Records are Absent from a Table
( 1 views ) Submitted By
Pat Hartman
on 01-May-12 10:20 PM in
Microsoft Access
.
0
Replies
re: Need SQL Code to merge multiple rows into one with one common factor
( 0 views ) Submitted By
Pat Hartman
on 30-Apr-12 10:09 PM in
MySQL
.
0
Replies
re: Copying data of a CSV file to a table
( 0 views ) Submitted By
Pat Hartman
on 30-Apr-12 05:31 PM in
SQL Server
.
0
Replies
re: compare dates with out null
( 0 views ) Submitted By
Pat Hartman
on 30-Apr-12 05:17 PM in
SQL Server
.
0
Replies
re: Update multiple tables
( 0 views ) Submitted By
Pat Hartman
on 30-Apr-12 05:10 PM in
SQL Server
.
0
Replies
re: Multi user issue (with split database), since adding new tables/forms
( 0 views ) Submitted By
Pat Hartman
on 30-Apr-12 04:57 PM in
Microsoft Access
.
1
Reply
re: TIMETABLE - PIVOT -Getting NULL Values
( 1 views ) Submitted By
Pat Hartman
on 24-Apr-12 04:47 PM in
SQL Server
.
0
Replies
re: summing records from several tables into one report
( 0 views ) Submitted By
Pat Hartman
on 24-Apr-12 04:40 PM in
Microsoft Access
.
2
Replies
re: Multi user issue (with split database), since adding new tables/forms
( 2 views ) Submitted By
Pat Hartman
on 24-Apr-12 04:39 PM in
Microsoft Access
.
0
Replies
re: Mail Merge of Muliple Excel lines into word doc if needed
( 0 views ) Submitted By
Pat Hartman
on 23-Apr-12 04:30 PM in
Microsoft Excel
.
0
Replies
re: front end for dummies
( 0 views ) Submitted By
Pat Hartman
on 23-Apr-12 04:08 PM in
Oracle Database
.
1
Reply
re: summing records from several tables into one report
( 1 views ) Submitted By
Pat Hartman
on 23-Apr-12 04:00 PM in
Microsoft Access
.
1
Reply
re: front end for dummies
( 1 views ) Submitted By
Pat Hartman
on 20-Apr-12 11:42 PM in
Oracle Database
.
0
Replies
re: DiscPrice:Unit Price*(1-Disc Pct) What is wrong with formula?
( 0 views ) Submitted By
Pat Hartman
on 20-Apr-12 11:36 PM in
Microsoft Access
.
1
Reply
re: summing records from several tables into one report
( 1 views ) Submitted By
Pat Hartman
on 20-Apr-12 11:33 PM in
Microsoft Access
.
0
Replies
re: Query joins
( 0 views ) Submitted By
Pat Hartman
on 17-Apr-12 05:04 PM in
Microsoft Access
.
2
Replies
re: Query joins
( 2 views ) Submitted By
Pat Hartman
on 17-Apr-12 12:22 AM in
Microsoft Access
.
1
Reply
re: "Write Conflict" error MS Access 2007 / MS SQL 2005
( 1 views ) Submitted By
Pat Hartman
on 16-Apr-12 03:41 PM in
Microsoft Access
.
3
Replies
re: odbc connections, again
( 3 views ) Submitted By
Pat Hartman
on 13-Apr-12 02:09 PM in
Microsoft Access
.
0
Replies
re: BOM - repeating values
( 0 views ) Submitted By
Pat Hartman
on 12-Apr-12 02:01 PM in
SQL Server
.
1
Reply
re: odbc connections, again
( 1 views ) Submitted By
Pat Hartman
on 12-Apr-12 01:47 PM in
Microsoft Access
.
0
Replies
re: update query sum of month then update other column last date
( 0 views ) Submitted By
Pat Hartman
on 11-Apr-12 09:10 PM in
SQL Server
.
1
Reply
re: odbc connections, again
( 1 views ) Submitted By
Pat Hartman
on 11-Apr-12 09:03 PM in
Microsoft Access
.
1
Reply
re: update query sum of month then update other column last date
( 1 views ) Submitted By
Pat Hartman
on 10-Apr-12 10:20 PM in
SQL Server
.
0
Replies
re: Distributing an Access db using SharePoint
( 0 views ) Submitted By
Pat Hartman
on 10-Apr-12 10:14 PM in
Microsoft Access
.
0
Replies
re: Passing a value from a subform to its mainform...
( 0 views ) Submitted By
Pat Hartman
on 10-Apr-12 10:01 PM in
Microsoft Access
.
0
Replies
re: swap certain column to row
( 0 views ) Submitted By
Pat Hartman
on 09-Apr-12 01:24 PM in
Oracle Database
.
0
Replies
re: Primary Key / Foreign Key--delayed updating to sharepoint
( 0 views ) Submitted By
Pat Hartman
on 09-Apr-12 01:21 PM in
Microsoft Access
.
0
Replies
re: Define Memo Data Types as Primary Keys
( 0 views ) Submitted By
Pat Hartman
on 05-Apr-12 11:36 PM in
Microsoft Access
.
1
Reply
re: Primary Key / Foreign Key--delayed updating to sharepoint
( 1 views ) Submitted By
Pat Hartman
on 05-Apr-12 11:32 PM in
Microsoft Access
.
0
Replies
re: Cannot add record
( 0 views ) Submitted By
Pat Hartman
on 05-Apr-12 11:24 PM in
Microsoft Access
.
2
Replies
re: ODBC - Call Failed [Microsoft][ODBC Driver Manager] Function sequence
( 2 views ) Submitted By
Pat Hartman
on 05-Apr-12 11:17 PM in
Microsoft Access
.
0
Replies
re: IF in Access 2007 VBA
( 0 views ) Submitted By
Pat Hartman
on 05-Apr-12 11:08 PM in
Microsoft Access
.
1
Reply
re: check delta and make report
( 1 views ) Submitted By
Pat Hartman
on 04-Apr-12 07:35 PM in
Microsoft Excel
.
1
Reply
re: Define Memo Data Types as Primary Keys
( 1 views ) Submitted By
Pat Hartman
on 04-Apr-12 07:23 PM in
Microsoft Access
.
0
Replies
re: Excel Cell
( 0 views ) Submitted By
Pat Hartman
on 03-Apr-12 11:14 AM in
Microsoft Excel
.
1
2
3
4
5
6
7
8
9
10
Next
Last
Access over 40 UI widgets with everything from interactive menus to rich charts.