Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 270
  • Last Modified:

Success Message at end of VBA

I currently have a button in a form in Access that allows me to import a series fo excell sheets into the database.

I would simply like to add a message at the end of the VBA code stating " Files Imported Successfully"

Is there a simple way to do this?

Thank you

0
jtr209
Asked:
jtr209
1 Solution
 
AgeOfEmpiresCommented:
MsgBox "Files Imported Successfully"

Of course, this simple statement ignores any error checking of the actual import process, but this statement will display your message
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:


You mean with a Message box ?

' you import code .....

Msgbox " Files Imported Successfully"


what code do you have now
mx
0
 
grogmanCommented:
If you would like a message that can dismiss itself after a specified period of time without requiring the users to click anything, you could try this:

http://blogs.technet.com/b/heyscriptingguy/archive/2005/03/14/how-can-i-automatically-dismiss-a-message-box-after-a-specified-length-of-time.aspx
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now