Solved

Success Message at end of VBA

Posted on 2011-09-08
3
267 Views
Last Modified: 2012-05-12
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
Comment
Question by:jtr209
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 4

Accepted Solution

by:
AgeOfEmpires earned 500 total points
ID: 36505032
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
 
LVL 75
ID: 36505044


You mean with a Message box ?

' you import code .....

Msgbox " Files Imported Successfully"


what code do you have now
mx
0
 
LVL 4

Expert Comment

by:grogman
ID: 36506387
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question