Animated GIF

%3CLINGO-SUB%20id%3D%22lingo-sub-1378078%22%20slang%3D%22en-US%22%3EAnimated%20GIF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1378078%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20I%20add%20an%20animated%20GIF%20to%20my%20Microsoft%20Access%20database%20and%20if%20so%20how%3F%3F%20Thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1378078%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1378128%22%20slang%3D%22en-US%22%3ERe%3A%20Animated%20GIF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1378128%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F662469%22%20target%3D%22_blank%22%3E%40Grumpy2305%3C%2FA%3E%26nbsp%3BSometimes%20the%20answer%20to%20a%20question%20is%20%22Sure%2C%20why%20not%3F%22%20But%20a%20better%20question%20might%20be%20%22WHY%3F%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhere%20would%20you%20put%20this%20GIF%3F%20In%20a%20form%3F%20That's%20the%20logical%20place%20I%20guess.%20See%20if%20the%20image%20control%20will%20support%20the%20animated%20GIF%20format.%20I%20know%20you%20can%20insert%20GIFs%20into%20the%20image%20control.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ImageControlonForm.png%22%20style%3D%22width%3A%20936px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F190451i93F9D0E01F78121E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22ImageControlonForm.png%22%20alt%3D%22ImageControlonForm.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20reason%20I%20question%20the%20reason%20is%20that%20Access%20tends%20to%20be%20oriented%20more%20towards%20business%2Fwork%20and%20less%20towards%20the%20kind%20of%20thing%20that%20I'd%20expect%20to%20see%20animated%20GIFs%20in.%20But%20I%20am%20curious%20how%20this%20would%20enhance%20the%20relational%20database%20application.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1378326%22%20slang%3D%22en-US%22%3ERe%3A%20Animated%20GIF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1378326%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F46682%22%20target%3D%22_blank%22%3E%40George%20Hepworth%3C%2FA%3EWhy%20not!%20I%20use%20my%20database%20for%20a%20business%20use%20and%20have%20been%20trying%20to%20enhance%20the%20look%20whilst%20in%20lockdown.%20Why%20not%20have%20an%20animated%20hourglass%20or%20scroll%20bar%20whilst%20waiting%20for%20something%20to%20happen%20like%20all%20apps%20and%20programs%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1378368%22%20slang%3D%22en-US%22%3ERe%3A%20Animated%20GIF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1378368%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F662469%22%20target%3D%22_blank%22%3E%40Grumpy2305%3C%2FA%3E%26nbsp%3BIn%20the%2025%20plus%20years%20I%20spent%20as%20a%20consultant%20designing%20and%20building%20relational%20database%20applications%20with%20MS%20Access%20and%20MS%20SQL%20Server%2C%20I%20can't%20recall%20a%20client%20ever%20asking%20to%20put%20animated%20GIFs%20on%20forms%20they%20use%20in%20their%20business.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20said%2C%20you've%20refined%20the%20requirement%20to%20be%20a%20GIF%20that%20mimics%20the%20functionality%20of%20a%20progress%20bar%20or%20the%20Hourglass%20or%20%22whirling%20circle%22%20that%20means%20%22Please%20wait%20while%20I%20finish%20this%22.%20In%20that%20context%2C%20I%20guess%20it%20would%20be%20useful.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESince%20you%20can%20load%20a%20GIF%20into%20an%20image%20control%2C%20though%2C%20I%20suspect%20you%20can%20do%20it%20with%20one%20that%20is%20animated.%20The%20problem%20then%20would%20be%20to%20show%20it%20only%20when%20appropriate.%20That%20could%20done%20in%20the%20event%20that%20launches%20your%20long-running%20procedure.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1378450%22%20slang%3D%22en-US%22%3ERe%3A%20Animated%20GIF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1378450%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F46682%22%20target%3D%22_blank%22%3E%40George%20Hepworth%3C%2FA%3E%26nbsp%3BSorry.%20I%20misspoke%2C%20to%20make%20the%20animated%20GIF%20move%2C%20you'll%20need%20to%20insert%20it%20into%20a%20Web%20Browser%20control%20on%20the%20form.%20In%20the%20standard%20image%20control%2C%20it%20would%20be%20static.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22WebBrowserGIFImageControlonForm.png%22%20style%3D%22width%3A%20988px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F190470i0524349BFD22FD8C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22WebBrowserGIFImageControlonForm.png%22%20alt%3D%22WebBrowserGIFImageControlonForm.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1379446%22%20slang%3D%22en-US%22%3ERe%3A%20Animated%20GIF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1379446%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F46682%22%20target%3D%22_blank%22%3E%40George%20Hepworth%3C%2FA%3EMany%20thanks%20for%20your%20responses%20and%20advice%2C%20very%20usefull.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1382855%22%20slang%3D%22en-US%22%3ERe%3A%20Animated%20GIF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1382855%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F662469%22%20target%3D%22_blank%22%3E%40Grumpy2305%3C%2FA%3E%26nbsp%3BI%20decided%2C%20once%20I'd%20had%20a%20chance%20to%20understand%20this%20better%2C%20that%20I%20needed%20to%20implement%20%3CA%20href%3D%22http%3A%2F%2Fwww.gpcdata.com%2FGPCDownloads%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ea%20demo%20accdb%3C%2FA%3E%20to%20illustrate%20one%20possible%20approach%20to%20doing%20this.%26nbsp%3B%20Scroll%20down%20to%20the%20link%20for%20the%20Animated%20GIF%20demo.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETHANK%20YOU.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1388748%22%20slang%3D%22en-US%22%3ERe%3A%20Animated%20GIF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1388748%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F46682%22%20target%3D%22_blank%22%3E%40George%20Hepworth%3C%2FA%3EThats%20cool%2C%20many%20thanks.%20Love%20the%20bars%20changing%20colour%20on%20the%20splash%20screen%20and%20the%20wait%20GIF.%20Many%20thanks%20for%20your%20help...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1389221%22%20slang%3D%22en-US%22%3ERe%3A%20Animated%20GIF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1389221%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F662469%22%20target%3D%22_blank%22%3E%40Grumpy2305%3C%2FA%3E%26nbsp%3B%20You're%20welcome%20and%20again%2C%20thank%20you.%20You%20challenged%20me%20to%20think%20instead%20of%20just%20reacting.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EContinued%20success%20with%20the%20project.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1392592%22%20slang%3D%22en-US%22%3ERe%3A%20Animated%20GIF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1392592%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F662469%22%20target%3D%22_blank%22%3E%40Grumpy2305%3C%2FA%3E%26nbsp%3BLebans%20has%20created%20a%20GIF%20player%20some%20years%20ago%20%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.lebans.com%2Fanimatedgifplayer.htm%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.lebans.com%2Fanimatedgifplayer.htm%3C%2FA%3E%3C%2FP%3E%3CP%3EBesides%20that%20you%20can%20take%20a%20look%20at%20my%20article%20%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.experts-exchange.com%2Farticles%2F33716%2FDefeating-the-device-independent-bitmap-dib-format.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.experts-exchange.com%2Farticles%2F33716%2FDefeating-the-device-independent-bitmap-dib-format.html%3C%2FA%3E%3C%2FP%3E%3CP%3EIf%20you%20examine%20the%20code%20you%20will%20see%20that%20at%20some%20time%20i%20use%20a%20collection%20to%20store%20the%20images..so%20you%20could%20extend%20the%20code%20to%20handle%20the%20images%20per%20frame%20and%20play%20them%20via%20a%20timer%20event%3C%2FP%3E%3CP%3EIt%20won't%20be%20.gif%20(haven't%20test%20it)%20but%20you%20could%20gather%20e.g%20a%20couple%20of%20hundred%20frames%20and%20playback%20them..depending%20of%20the%20quality%20you%20want%20you%20could%20go%20as%20up%20%2For%20as%20low...%3C%2FP%3E%3CP%3E1%20second%20animation%20should%20be%20smooth%20at%20around%2015fps%20so%20with%20150%20images%20you%20could%20have%20a%2010%20second%20animation%3C%2FP%3E%3CP%3EFor%20now%20the%20code%20is%2032bit%20only%20but%20i%20have%20made%20some%20tests%20and%20possible%20i%20will%20offer%20a%2064bit%20version%20in%20the%20near%20future%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Can I add an animated GIF to my Microsoft Access database and if so how?? Thanks

9 Replies
Highlighted

@Grumpy2305 Sometimes the answer to a question is "Sure, why not?" But a better question might be "WHY?"

 

Where would you put this GIF? In a form? That's the logical place I guess. See if the image control will support the animated GIF format. I know you can insert GIFs into the image control.

 

ImageControlonForm.png

 

The reason I question the reason is that Access tends to be oriented more towards business/work and less towards the kind of thing that I'd expect to see animated GIFs in. But I am curious how this would enhance the relational database application.

Highlighted

@George HepworthWhy not! I use my database for a business use and have been trying to enhance the look whilst in lockdown. Why not have an animated hourglass or scroll bar whilst waiting for something to happen like all apps and programs?

Highlighted

@Grumpy2305 In the 25 plus years I spent as a consultant designing and building relational database applications with MS Access and MS SQL Server, I can't recall a client ever asking to put animated GIFs on forms they use in their business. 

 

That said, you've refined the requirement to be a GIF that mimics the functionality of a progress bar or the Hourglass or "whirling circle" that means "Please wait while I finish this". In that context, I guess it would be useful.

 

Since you can load a GIF into an image control, though, I suspect you can do it with one that is animated. The problem then would be to show it only when appropriate. That could done in the event that launches your long-running procedure. 


Highlighted

@George Hepworth Sorry. I misspoke, to make the animated GIF move, you'll need to insert it into a Web Browser control on the form. In the standard image control, it would be static.

 

WebBrowserGIFImageControlonForm.png

Highlighted

@George HepworthMany thanks for your responses and advice, very usefull.

Highlighted

@Grumpy2305 I decided, once I'd had a chance to understand this better, that I needed to implement a demo accdb to illustrate one possible approach to doing this.  Scroll down to the link for the Animated GIF demo.

 

THANK YOU.

 

 

Highlighted

@George HepworthThats cool, many thanks. Love the bars changing colour on the splash screen and the wait GIF. Many thanks for your help...

Highlighted

@Grumpy2305  You're welcome and again, thank you. You challenged me to think instead of just reacting. 

 

Continued success with the project.

 

Highlighted

@Grumpy2305 Lebans has created a GIF player some years ago : https://www.lebans.com/animatedgifplayer.htm

Besides that you can take a look at my article : https://www.experts-exchange.com/articles/33716/Defeating-the-device-independent-bitmap-dib-format.h...

If you examine the code you will see that at some time i use a collection to store the images..so you could extend the code to handle the images per frame and play them via a timer event

It won't be .gif (haven't test it) but you could gather e.g a couple of hundred frames and playback them..depending of the quality you want you could go as up /or as low...

1 second animation should be smooth at around 15fps so with 150 images you could have a 10 second animation

For now the code is 32bit only but i have made some tests and possible i will offer a 64bit version in the near future