Check for open objects

[Perceptus]

Sometimes access wont close correctly on some databases. I have made a "Quit Application" button using the wizard to exit the application. but instead this leaves me with an empty access window that must have its process killed to exit in a timely manner.



Is there an expressing I can enter into the Immediate window to evaluate what is keeping the application from closing out?

[rpeare]

is your command button code just simply docmd.quit or something? or is it more extensive?

[Perceptus]

the command button is using the Embedded Macro that is created by the wizard.

[rpeare]

I don't use macros sorry, there's code to cycle through forms or reports etc and a way to check if they are open but it requires VBA.

[Perceptus]

Alrighty, Thanks anyways.