Export Access form to gif or jpeg

[RTHarrison]

I have an access database linked through ODBC to a datacollection system that polls and updates with new information every five minutes. The data is then compiled to create a graphical representation of the data. I would like to export these graphical forms as Gifs or JPEGs that could be used on a plant floor computer as a screensaver.

Do you have any ideas?

thank you,

 

[FancyPrairie]

When the screen is displayed, hit the Print Screen key on your keyboard. Open Paint Brush (or whatever) and enter Ctrl+V (paste). The Print Screen key copies the image to the paste buffer, Ctrl+V pastes it into whatever application you have open (i.e. Paint Brush)

 

[RTHarrison]

Thank you, I've considered that option, but I need to to be an automated process that updates the picture every 5 minutes. Also "print screen" captures the headers as well. I want only the form as a gif or jpeg.

Thank you for your help.

Matt Sheffield

 

[RTHarrison]

I have tried using the code suggested in the Wizofbaud posting of
thread 705-760455

I put this code behind a button on the form.

Private Sub Command21_Click()
On Error GoTo Err_Command21_Click

Me.Form.Export "c:\form.gif", "GIF", False

Exit_Command21_Click:
Exit Sub
Err_Command21_Click:
MsgBox Err.Description
Resume Exit_Command21_Click
End Sub


When I try to run the code I get a MSAccess popup that says:


"Application-defined or object=defined error"

Thank you for your help

 

[RTHarrison]

replacing that code with the following:

DoCmd.OutputTo acForm, "1415 25 Master form", "gif_(*.gif)", "c:\masterform.gif", False, ""

gives a different MSAccess error: "The formats that enable you to output data as a microsoft excel, rich-text format, MS-DOS text,or HTML file are missing from the Windows Registry."

Can I add the appropriate code to the registry? - help?