Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Save Form as a Bitmap?

Status
Not open for further replies.

BoobooBear

Technical User
Nov 26, 2002
2
GB
I have a table which contains a field defined as an OLE object. The table has a record for each form in an Access 2000 database, and the OLE field contains a link to a bitmap image of the appropriate form. This is easy enough to do manually using Print Screen for each form, pasting into Paint and saving as a bitmap, then using Insert / Object to add the BMP to the table. (I need to go through the extra step of saving as a bitmap in Paint because if I paste into the table directly from the Clipboard, then double click on the OLE field I get an error message: The Picture doesn’t support the attempted operation: The OLE object was changed to a picture, or the link to the object was broken….”).

What I want is to do the above programmatically from VBA. What would be great was if there was a way to save an image of an Access form as a bitmap. Is this possible? If not can anyone give me some guidelines as to how to manipulate the Clipboard and Paint from Access VBA?

Any assistance would be greatly appreciated.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top