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!

to close Access from within a VBA procedure, use

Application.Quit acQuitSaveNone

hth


"AllyOop" <(E-Mail Removed)> wrote in message
news:C98F1412-DC7F-4505-9336-(E-Mail Removed)...
> 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!

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

"tina" wrote:

> to close Access from within a VBA procedure, use
>
> Application.Quit acQuitSaveNone
>
> hth
>
>
> "AllyOop" <(E-Mail Removed)> wrote in message
> news:C98F1412-DC7F-4505-9336-(E-Mail Removed)...
> > 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!
>
>
>

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


"AllyOop" <(E-Mail Removed)> wrote in message
news:4C7D64B2-2FD3-4C3F-B200-(E-Mail Removed)...
> Forgive my limited VBA knowledge, but where in the procedure do I add this
> line?
> Thanks!
>
> "tina" wrote:
>
> > to close Access from within a VBA procedure, use
> >
> > Application.Quit acQuitSaveNone
> >
> > hth
> >
> >
> > "AllyOop" <(E-Mail Removed)> wrote in message
> > news:C98F1412-DC7F-4505-9336-(E-Mail Removed)...
> > > 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!
> >
> >
> >