Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jul 2001
    Posts
    280
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Can i stop autoexec from running (Access 2000)

    I have placed a similar question yesterday but i think i was not clear enough what i wanted and therefore
    i would like to perephrase my problem with another thread.My question is,How can i stop autoexec command from running?I have an autoexec macro based on the RunCommand function called "auto" in my case, which is:
    Public Function auto()
    If Dir("C:bebe.mdb ", vbNormal) = "" Then
    DoCmd.Quit
    End If
    End Function

    So if the database is present,then the autoexec works.But i want that the autoexec does not work and quit the datbase in case the other database in my case be.mdb is not present or is not available.I have some strong reasons to want that but this is beside the point.
    My question is how can i stop the autoexec macro from running.
    In my case, when he databse is opened, and the database "C:bebe.mdb ", vbNormal is missing,then i receive the message
    " you cant exit Mictrosoft Access now" And the next message is also on : if you are runing Visual Basic module that is using OLE or DDE you need to interrupt the module"

    Is there any way to stop the execution of the autoexec macro,claose the database or make it impossible to open?

    I will be very grateful for the help i may receive

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Can i stop autoexec from running (Access 2000)

    Is <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=acc&Number=105176&page= 0&view=collapsed&sb=5&o=186&fpart=>this</A> the thread you're referring to? It's better not to scatter bits of threads on the same subject all over the Lounge.

    As in the other thread, you need to clarify your question. I assume your autoexec macro is calling the Auto() routine, right? You can't stop the autoexec from running, you can only change what happens in the Auto() function. Change the line DoCmd.Quit, which closes the database, to Application.Quit, which closes Access.
    Charlotte

Posting Permissions

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