Applies To Application object.
Description
The Quit method quits Microsoft Access. You can select one of several options for saving a database object before quitting.
Syntax Application.Quit [option] The Quit method has the following argument.Argument | Description | |
option | An intrinsic constant that specifies what happens to unsaved objects when you quit Microsoft Access. This argument can be any of the following constants. | |
Constant | Description | |
acSaveYes | (Default) Saves all objects without displaying a dialog box. | |
acPrompt | Displays a dialog box that asks whether you want to save any database objects that have been changed but not saved. | |
acExit | Quits Microsoft Access without saving any objects. |
Remarks The Quit method has the same effect as clicking Exit on the File menu. You can create a custom menu command or a command button on a form with a procedure that includes the Quit method. For example, you can place a Quit button on a form and include a procedure in the button's Click event that uses the Quit method with the option argument set to acSaveYes.
See Also Quit action, Quit method (DoCmd object).
Example The following example shows the Click event procedure for a command button named AppExit. After clicking the AppExit button, a dialog box prompts the user to save changes, and the procedure quits Microsoft Access.Private Sub AppExit_Click()
Application.Quit acPrompt
End Sub