Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jan 2003
    Location
    Colorado Springs, Colorado, USA
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Prevent autorunning (2000/2003 SP2)

    Is there a way to prevent the auto running of forms/macros in Access yet still be able to view the VBA code?

    Someone left the company and it's fallen onto me to unravel the pile of scheduled jobs, access databases that populate excel workbooks and send e-mail that this former employee has running on his old PC.

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Prevent autorunning (2000/2003 SP2)

    Hi Mike

    Where are the macros/schedules running from:

    1) Modules
    2) On start up of an oblect
    3) Autoexec
    4) Have you pressed the [shift] key on start up of the database to bypass startup.
    5) Is the database an mde or and mdb, are there hidden objects?
    Jerry

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Prevent autorunning (2000/2003 SP2)

    Try opening the database with the Shift key held down until the database window appears. Holding down the Shift key will make Access bypass the startup options, unless the designer has disabled this.

    If Shift doesn't work, create a blank new database and import all database objects from the "problem" database into the new one.

  4. #4
    New Lounger
    Join Date
    Jan 2003
    Location
    Colorado Springs, Colorado, USA
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Prevent autorunning (2000/2003 SP2)

    Actually I'm not too sure. I double click on the mdb file and it starts running something.

    I just tried holding down shift and that worked! Thanks. I thought there was something simple. Thanks for the quick reply!

    <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •