How to make a Slide Show in Access

[goconnect]

Hi all

Do you know how to make a Slide Show for each form in Access??

Thanks

P.S. any function is like VB can set the timer?

Please E-mail to me...THKS

 

[charityg]

Have you looked into any of the activex components. Seems that there must be one you can use. Anyone have any ideas?

 

[KevinM]

Have you tried doing screen prints of your forms and then inserting them into MS Powerpoint?

 

[goconnect]

Hello

What is "screen prints "...

Thanks

 

[ElsVanMiert]

Apparently it is not so difficult to realize a slide show on Access forms. The MDT-2999 installer that replaces the PDW in the runtime version contains this as a standard option. Since you can modify the display time I suppose that the timer event is used with a special code that displays the graphic files in a picture control.

It should be also very easy to use the display functions of the Graphic Wizard in a loop to create the slideshow.

 

[KevinM]

You need graphics software that will allow you to capture a selected area of a windows screen (I use Paint Shop Pro). Once the form is captured you can save it as a picture file and will then be able to insert it into another slideshow program like Powerpoint.

HTH

 

[goconnect]

Thank you for the reply!!!(charityg, KevinM and ElsVanMiert)

Hello

I am still confusing....

The problem is I have to show each record for a seconds, then next slide = next record... After it show the last record, it will go back to the first record again....
<--Is a loop!!

Please help ME....

 

[ElsVanMiert]

You could ask Jack.Richardson@UnSoftwareag.com (one of the developers of the MDT-2000).

 

[Abby N]

Hi. I think I understand what you're trying to do. Place this code in the forms 'On Timer' event:

If Me.RecordsetClone.RecordCount = Me.CurrentRecord Then
DoCmd.GoToRecord , , acFirst
Else
DoCmd.GoToRecord , , acNext
End If

Then set the 'Timer Interval' to 1000. Now the form will cycle through each record, displaying it for one second. Hope this is what you're looking for.

~Abby

 

[goconnect]

Hello

Oh...I found that Right click "Form", then go to "Event", I can set the Timer and timer interval!!

But the problem is how to coding for them...

Example:
Each form is refer to the record(from the table) need to change every few seconds.

It must be the timer Event!! (I think)

Is that I have to put this
DoCmd.GoToRecord , , acNext
inside the code??

But how it knows if it EOF then go back to the first record
DoCmd.GoToRecord , , acFirst
and make a loop??

Please help EVEY ONE!!

 

[Abby N]

Goconnect, take a look at my post just before your last one. It gives this code:

If Me.RecordsetClone.RecordCount = Me.CurrentRecord Then
DoCmd.GoToRecord , , acFirst
Else
DoCmd.GoToRecord , , acNext
End If

That should do what you want. Basically the code says “If the current record is the last record go to the first record. Otherwise go to the next record.” You don't need a loop because the Timer event will execute the code every interval. Good luck.

~Abby

 

[goconnect]

Thanks for all replyers!!

Now, I can do it!!

Thanks Very much!!

P.S. but I am using recordset....