Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. steve1961

    Append and Refresh Subforms

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

    Append and Refresh Subforms

    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...
  3. steve1961

    Dim varDummy As Variant

    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////
  4. steve1961

    Dim varDummy As Variant

    "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...
  5. steve1961

    Dim varDummy As Variant

    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...
  6. steve1961

    Dim varDummy As Variant

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

    Dim varDummy As Variant

    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...
  8. steve1961

    Dim varDummy As Variant

    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...
  9. steve1961

    Dim varDummy As Variant

    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.
  10. steve1961

    Dim varDummy As Variant

    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 =...
  11. steve1961

    Access 2003 Runtime Security Warning!

    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...
  12. steve1961

    Connection Failed

    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.

Part and Inventory Search

Back
Top