Code won't quit

[Guest]

I am running a macro that contains a RunCode command.
After the code runs, there is a quit to close the database.
This worked fine in Access 97, but when I converted the db to Access 2003,
the code will run great, but the quit doesn't happen. I believe this is
because Access thinks the code is still running. Is there anyway to hard code
an end code into the module to make sure the code stops running and the db
can close?
Thanks!

 

[tina]

to close Access from within a VBA procedure, use

Application.Quit acQuitSaveNone

hth

 

[Guest]

Forgive my limited VBA knowledge, but where in the procedure do I add this
line?
Thanks!

 

[tina]

add it below the code that's doing whatever it is the procedure is supposed
to do, and above the End line. also, note that if you use the Quit command
in VBA, you'll want to remove the Quit command in the macro.

hth