INSTERT SLIDESHOW INTO ACCESS FORM

  • Thread starter Thread starter skelly
  • Start date Start date
S

skelly

i have my form page created for my database, i have a picture in it to remind
me of an offer i have. however i have more than 1 offer so i would like this
to change every so many seconds. like a slideshow.
 
I did this years ago placing the images in a table, but can't find the app.
Below is a different method that should work for you.

I just did this and tested it for you.

I created 4 images, named Image1.jpg, Image2.jpg, Image3.jpg, Image4.jpg.
(If you aren't using A2007, then I think you will need to use .bmp images).
I placed them in the Access Default directory, which in my case is D:\.

I create a new form and loaded a Picture Rrame with Image1.jpg loaded onto
it. In earlier versions, it may be an Unbound Object Frame. I named the
Picture Frame, "imgFrame"

In the timer event of the form I typed this code:

Select Case [imgFrame].Picture
Case "Image1.jpg"
[imgFrame].Picture = "Image2.jpg"
Case "Image2.jpg"
[imgFrame].Picture = "Image3.jpg"
Case "Image3.jpg"
[imgFrame].Picture = "Image4.jpg"
Case "Image4.jpg"
[imgFrame].Picture = "Image1.jpg"
End Select

This worked for a picture frame. For an unbound frame you will need to
modify the code. In retrospect I probably should have used an Unbound Object
Frame, but this is the idea.

God Bless,

Mark A. Sam
 
I forgot to tell you to set the form's Timer Interval property as whole
number. The number represents miliseconds, so 6000 would be 1 second. I
would try that and adjust it from there.
 
Back
Top