Search results for query: *

Thanks Jimmy, works a charm... Note: like your Invoice System Program Steve

Hi, I have a main form with a combo box (cboTempSelect)and command button(cmdSelectTemplate) . When the user selects a text in the combo box (cboTempSelect), the user then clicks the command button (cmdSelectTemplate)which fills in data in 4 subforms of this main form. Private Sub...

Yes, this works for me as well. You are much quicker then a newbie like me. MajP, Many many thanks again for your valuable input////

"Do you really want to create a copy record everytime you create a record?" Currently for 90% of new records on each job details line it's always the same except for 1 field. But yes I did play with the default values of the control in the past. I'll take your suggestion and try to do this...

MajP, Your genius in solving this error will go unnoticed. The error was solved as you indicated: "In VBE check Tools > Options > Genreal > Error Trapping." Make sure not set to "all errors" I just can't figure out why this is happening all of sudden when the code ran fine for the past few...

Here are links again http://www.mediafire.com/?mdi3eyjzx2q http://www.mediafire.com/?zqnttmxozij

MajP, I appreciate your reply and have tried the following suggestions 1) Ensure "Option Explicit" set for all modules 2) Debug and compile the project from the vba window 3) Correct any compile errors 4) Compact and repair the database 5) Test If no joy 6) Build a blank database 7) import...

I have created a new databases using the current code (TEST 1.MDB) and a previous version of this code (TEST 2.MDB)and posted the links to the DB below it. Run-Time error '1245' You entered an expression that has an invalid reference to the property ControlSource...

Sorry about that: Run-Time error '1245' You entered an expression that has an invalid reference to the property ControlSource Funny thing is this code has been running for last 5 years with no problem and then this error starts showing up.

I have a function called "HasProperty" which is part of another function called "Public Function CarryOver" taken from (http://allenbrowne.com/ser-24.html)a few years back. This code was working for years but for some strange reason is now showing the following error in Line 6 below: varDummy =...

Can someone please point me toward resources to find out how to stop the macro Security warnings when using the Access 2003 runtime? I was able to disable it in the full-version by setting the macro security to low. But when the database is open in runtime. The macro security warnings shows...

Denny, Thanks for the tip, I'll try out your suggestion at work tomorrow. I have a gut feeling you are right on this one.