Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hide VBA window when code is called

Status
Not open for further replies.

SPYatwork

Technical User
Jun 21, 2005
10
GB
I use a form's onclose event to call a function that in turn runs some code to send an email from Access. The problem is that when the code is run the VBA window becomes visible to the user and I would like to hide it.
Any help appreciated!
 
The only reasons the VBA window should show is because there is a error or a break point. Please post the code.
 
Ah found the problem - thanks

Sub NIF_UI()
DoCmd.RunCommand acCmdDebugWindow
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top