Solved

Change MS Access VB Code from Hourglass to animation, GIF or AVI

Posted on 2009-04-01
2
583 Views
Last Modified: 2013-11-28
I have an Access 2003 database that executes code on a button click.
I would like to know if I can embed an AVI or other moving picture to indicate a file export during my VB Code execution rather than my current (very nifty) Hourglass option.  Please no mocking, I dont code for a living.
DoCmd.Hourglass True
    TheFac = DLookup("[Facility]", "Fac")
    TheDate = DLookup("[TheDate]", "Fac")
    TheFile = "G:\Billing\Billing-" & TheFac & TheDate & ".xls"
    DoCmd.OutputTo acQuery, "MonthlyBillingExport", "MicrosoftExcelBiff8(*.xls)", "G:\Billing\Billing-" & TheFac & "_" & TheDate & ".xls", False, "", 0
    DoCmd.Hourglass False
    TheMessage = "Report has been exported to  " & TheFile
    Beep
    MsgBox TheMessage, vbInformation, "Report Complete"

Open in new window

0
Comment
Question by:kgadams
2 Comments
 
LVL 46

Accepted Solution

by:
tbsgadi earned 150 total points
ID: 24046960
Hi kgadams,

You can use the gif89 activex
File here:
http://www.vbforums.com/showthread.php?t=79007
Explanation here:
http://www.tek-tips.com/faqs.cfm?fid=108


Good Luck!

Gary
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 100 total points
ID: 24046984
Check this out - no DLL's to register:

http://www.lebans.com/animatedgifplayer.htm

mx
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
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…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

679 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