Results 1 to 8 of 8
  1. #1
    toddbuckles is offline Novice
    Windows XP Access 2003
    Join Date
    Dec 2010
    Location
    Florida, USA
    Posts
    8

    Auto Loading a Form

    Hi All,



    I am wondering about a from in my current database that autoloads when the DB is opened. I know you guys are thinking "didn't we just go over this ad-naseum in a recent post?" Yes, you did however I can neither find an AutoExec Macro, nor is it stated in the Tools-->Startup menu. I am sure the answer is there, just can't see it. I have attached the db for info as a zip.

    Any thoughts?

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    There most certainly is an AutoExec macro. Do you see the mcrQuit Macro? How about the two modules?

  3. #3
    toddbuckles is offline Novice
    Windows XP Access 2003
    Join Date
    Dec 2010
    Location
    Florida, USA
    Posts
    8
    I see a standard Module named mdlMain with a Sub (LogErrors) and a Function (fviewInfo). I see a Class Module with 4 Public Property's.

    I do not see mcrQuit. Or AutoExec. I am most certainly looking in the wrong place however. I am searching through the VBE.

    What am I doing wrong?

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Open the db while holding down a <SHIFT> key and see what happens.

  5. #5
    toddbuckles is offline Novice
    Windows XP Access 2003
    Join Date
    Dec 2010
    Location
    Florida, USA
    Posts
    8
    Beautiful. Thank You.

    Do you know how the mcrQuit Macro is called? I know that AutoExec is run at startup.

    TB

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    It is invoked when you press the last button on the SwitchBoard. Are you ready to use the Thread tools and mark this thread as Solved?

  7. #7
    toddbuckles is offline Novice
    Windows XP Access 2003
    Join Date
    Dec 2010
    Location
    Florida, USA
    Posts
    8
    I always do, when they are. I also post follow up's to help folks searching later.

    Thank you for all of your help.

    TB

  8. #8
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    That's great and you're welcome. Happy New Year

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 12-27-2010, 06:59 PM
  2. Loading data for our business
    By fsmikwen in forum Programming
    Replies: 2
    Last Post: 04-16-2010, 09:13 AM
  3. Picture loading and viewing issue
    By Kencao in forum Access
    Replies: 2
    Last Post: 02-23-2010, 12:43 PM
  4. Loading pictures from URL in a report
    By drborracho in forum Programming
    Replies: 5
    Last Post: 12-13-2005, 09:22 AM
  5. Loading the form with selected record
    By emilylu3 in forum Access
    Replies: 1
    Last Post: 12-09-2005, 07:49 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums