Autoexec and close the database

[DevAccess]

Hello

I am running some function from autoexec macro using run code command and specify function name of vba, now this runs on scheduled activity I would like to close the database when program finishes with the activity.

I tried in vba, application.quit but it does not work and gives me error saying it is not available now.

Please assist.

 

[Ranman256]

application.quit does work...but you dont need it in the function,
put it in the autoexec AFTER your function.

i use it all the time.

 

[DevAccess]

application.quit does work...but you dont need it in the function,
put it in the autoexec AFTER your function.

i use it all the time.

You mean to say that I need to create function B and have there application.quite and shall I call function B after function A in autoexec ?

 

[isladogs]

No. Just use the macro command Quit Access