how to get access to close after autoexec

[hbersani]

I have an access application that I want to execute via a scheduler. I can get the application to open and run but cannot seem to get access (application) to close so control returns to the batch file. I'm using the "quit" action with the "exit" option in the macro screen. Any suggestions?

 

[PHV]

And what about the Application.Quit method (in VBA)?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[hbersani]

PH, unfortunately, I have absolutely no experience with VBA... so I don't know if it will work...

 

[AudreyCole]

I have an application which downloads info every night and then quits. The VBA code that the other commentor suggests works fine. You just need to make sure there's some event that the Quit code can use to respond to.

Have fun!

 

[hbersani]

For anyone else who might be experiencing this problem, I located the cause. the macro action just prior to the "Quit" action was a "Close". Because I didn't specify what to close, the close acted on the macro and closed it... therefore, it never got to the "QUIT" action.

 

[isthisthingon]

In an application I recently developed, I made a form that would pop up after a period of time which was higher than the amount of time I reasonably expected someone to be using the program. I chose 25 minutes. On that form there was a message warning the user that the application would close and a cancel button if the user wishes to remain logged in. If the cancel button wasnt hit in 2 minutes, the application closes using the application.quit command. Hope this helps.