Pat Hartman's latest activity
-
PPat Hartman replied to the thread VBA command to create new records in tables and copy value of one field.I made a lot of changes but lots more are needed. Tables: 1. I made JobID required and removed the 0 default 2. Removed the lookup from...
-
PPat Hartman replied to the thread Solved Hi, Can anyone guide me how to make an accounting database?.@Khurramshaikh47 As long as "small" is understood to be single entry and limited features, you can create something that can replace...
-
PPat Hartman replied to the thread Any idea why this error handling is being applied to all error codes?.It's an easy mistake to make. People do it all the time.
-
PPat Hartman replied to the thread Command Button Fails.You're welcome.
-
PPat Hartman replied to the thread VBA command to create new records in tables and copy value of one field.I take it you are not using a subform but you are opening a dependent form. Both forms must be open. You cannot reference a form...
-
PPat Hartman replied to the thread Command Button Fails.@Privateer I'm going to take a stab at why that code is only working in development. The .ActiveCodePane part may only be valid when...
-
PPat Hartman replied to the thread How to give the parameter value Yes or No?.Also, Don't be sloppy with your control names. ALWAYS give a control a rational, meaningful name. NEVER just accept the default like...
-
PPat Hartman replied to the thread Sub records?.Don't be sloppy about your naming convention. 1. ALWAYS give controls proper names when you build them. That way you don't end up with...
-
PPat Hartman replied to the thread Integrate Word mail merge in MS Access.Mail merge won't handle things like invoices where you have header/detail data. That's why I don't use it.
-
PPat Hartman replied to the thread Lookup.You should probably keep the time as hundredths of a second in an integer and scale it yourself. Then you can divide by 60 to get...
-
PPat Hartman replied to the thread Solved Hi, Can anyone guide me how to make an accounting database?.And they never got fired for recommending IBM either even when IBM PC's were going for three times the price of Gateway's. I was...
-
PPat Hartman replied to the thread Integrate Word mail merge in MS Access.I don't use mail merge. I automate word to populate the documents. I've attached a very simple sample so you can see how it is done...
-
-
PPat Hartman replied to the thread Buffalo Shooter.It also appears that the perpetrator had a history of this type of threat and he was not in the "system" due to some silly law. Similar...
-
PPat Hartman replied to the thread Solved Hi, Can anyone guide me how to make an accounting database?.I think SAP stands for sucky application program. It tried to do everything but ended up doing nothing well. I can't complain. I made...
