Recent content by KSP

I thought of that as well, so I removed all code instead of the DoCmd.Quit command. Like I said above. If I run the Abatement function itself the quit command execute but if the macro calls the function I get Quit isn't available. I know this works I just cannot understand why this is a problem...

Tried Application.Quit. I got the same error.

The Abatement function queries my SQL database and send abatement letters to landlords. Abatement Macro--->TestFuntion()--->Abatement Function I changed the name of my macro. I still get the same error. I forgot to mention that the version of Access is 2007.

I have a macro Abatement which calls function TestFunction which calls the abatement function: Private Function TestFunction() Abatement <--function End function I get the error 'Quit' isn't available. Even if "DoCmd.Quit" is the only line of code in the function. If I add the available...

I received the below error message when I built a macro to kick off a function and quit to close MS Access. I have a few questions that I hope the Access Gods can answer for me: 1. I created the database in the 2007 version. It is not read-only. When ask for elements to put in the macro, the...