Closing application before MsgBox appears.
Good Morning.
Currently I have a macro that opens access and imports my table from some excel spreadsheets. After it is done I have a MsgBox pop up stating that update is complete. However, Access stays open and you cant see the Msg Box until you click back to excel. What can I do to have Access Close before the MsgBox appears.
Please Login or Register to view this content.
Last edited by CJPHX; 05-26-2010 at 01:13 PM.
You could quit the access application before the message box appears like so:
Please Login or Register to view this content.
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks