Microsoft KB Archive/103405

= ACC: How to Use a Function to Quit Windows =

Article ID: 103405

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Access 1.0 Standard Edition
 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition
 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q103405



Moderate: Requires basic macro, coding, and interoperability skills.



SUMMARY
While it is possible to quit Microsoft Windows from within a Microsoft Access program by making use of the Windows application programming interface (API) function ExitWindows, Microsoft Windows will not shut down cleanly. Open files in Windows-based applications may not be saved, and temporary (.tmp) files may be left on your hard disk.

This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access applications using the programming tools provided with Microsoft Access. For more information about Visual Basic for Applications, please refer to your version of the "Building Applications with Microsoft Access" manual.

NOTE: Visual Basic for Applications is called Access Basic in Microsoft Access versions 1.x and 2.0. For more information about Access Basic, please refer to the "Introduction to Programming" manual in Microsoft Access version 1.x or the "Building Applications" manual in Microsoft Access version 2.0



MORE INFORMATION
The sample function listed below demonstrates another method of shutting down Windows from within Microsoft Access. This method will save open files before shutting down, and will not leave .tmp files on your hard disk. Function QuitWindows SendKeys "%{F4}S~", False AppActivate ("Program Manager") End Function In the sample function above, the QuitWindows function activates the Microsoft Windows Program Manager, and then sends the keystrokes necessary to instruct Program Manager to close Windows. This function works in Windows 3.x, Windows NT, and Windows 95 (even though there is no Program Manager in Windows 95).

