Not an animated gif BUT!! (there's always a but isn't there?) Say you had a 3 frame animated gif, take each frame and place it as a separate picture on the form and make sure they are the same size and on the same coordinates. Let's say the controls are named ole1, ole2, ole3; you could set the Timer Interval to say 500 and make a little code that fires in the Timer event that looks like so:
[tt]
If ole1.Visible = True Then
ole2.Visible = True
ole1.Visible = False
Else
If ole2.Visible = True Then
ole3.Visible = True
ole2.Visible = False
Else
ole1.Visible = True
ole3.Visible = False
End If
End If
[/tt]
Voila! Disney couldn't have done it any better! ;-)
But the reason i wanted to do this is, I have a series if append queries running back to back. I wanted a form to pop-up with some type of animation while the user waits..The time interval code will not work when a query is running at the same time my pop-up form is loaded...
The timer on the popup form needs to be used and not the main form calling the query. Don't see any issues with using that, unless the computer is running such a complex query that it's eating all the CPU resources. Joe Miller
joe.miller@flotech.net
You can also get the complete information and also the needed Giz89.dll file at Candace Tripp's site below.
Choose MS Access Downloads to locate the file.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.