BoobooBear
Technical User
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.
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.