HOW I CAN SAVE AND LOAD A GIF PHOTOS IN MY DATABASE!

[MicroAbdel]

Hi there;
I running for a big problem I'm trying to play GIF animation into windows media player all works fine, the problem when I moved my database directory to other place , and reopened the database GIF won't work if I deleted the GIF from my PC
I want a GIF file to be in database so if I removed local source of it , the database should load my GIF AND PLAY IT!
Pls any tips and tricks so if I moved my database only, GIF should be played in other computers

 

[Isaac]

Possibly use an attachment column type?

 

[MicroAbdel]

Possibly use an attachment column type?

Hi Issa, tnx for replying;
I don't really know how to link an attachment of a table with windows media player in a form, any tips or links to help me out rly appreciate it

 

[Isaac]

first step maybe save gif with database by using attachment column type and storing file with table.

next step later to load gif. step by step.

 

[MicroAbdel]

first step maybe save gif with database by using attachment column type and storing file with table.

next step later to load gif. step by step.

first step done , second step is the problem how to link an attachment with windows media player

 

[arnelgp]

use Webbrowser Control to play your annimated gif.

 

[MicroAbdel]

use Webbrowser Control to play your annimated gif.

Hi arnelgp;
i used but the problem when i want to copy my database and paste it to other pc GIF won't work cuz GIF file doesn't load or in database as a source

 

[arnelgp]

see this demo (a2019).

 

[Isaac]

Good job on the first step! So in my original idea The next step would be to write code to grab the attachment from where it's stored in the table and play it. You can use arnell's method or you can just queue up Windows Media player and play it using code

 

[MicroAbdel]

see this demo (a2019).

I will try to understand how u did that , thank you so much for ur help

 

[MicroAbdel]

Good job on the first step! So in my original idea The next step would be to write code to grab the attachment from where it's stored in the table and play it. You can use arnell's method or you can just queue up Windows Media player and play it using code

Thanks you isaac, i don't know nothing about coding in vba , but i will try to get an idea how it's work, if u have any vba tutorial about attachment share it with me really appreciate it <3