"Application.Quit " not working

[DougAtAvalon]

On the on close event of a form I have:

"Application.quit" it closes the database but not Access
More oddly, I have a "Stop" line befor it and sometimes it doesn't stop

i have done this before and it has worked fine

Any clues?

-Doug

 

[ghubbell]

Hi Doug,
Try this, and you should wrap your code with some error handling to find the bugs so:

'Your Subs event title

On Error GoTo Err1

Application.Quit acQuitSaveAll
CloseCurrentDatabase

Exit1:
Exit Sub

Err1:
MsgBox Err.Number & " " & Err.Description
Resume Exit1

'End Sub here
Gord
ghubbell@total.net

 

[Cagliostro]

Try docmd.quit John Fill

ivfmd@mail.md

 

[rbowes]

I think that ghubbell is on the right path, it sounds like you have another function that's running, doing a "Quit" on you before it gets to your Application.Quit. I believe the docmd.Quit just closes the .mdb not Access itself.

 

[Cagliostro]

You shouldn't believe. You must try. John Fill

ivfmd@mail.md