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

x
?
Solved

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

Posted on 2009-04-01
2
Medium Priority
?
621 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 450 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 300 total points
ID: 24046984
Check this out - no DLL's to register:

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

mx
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Question has a verified solution.

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

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

916 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