Solved

Success Message at end of VBA

Posted on 2011-09-08
3
261 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
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

930 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now