Inserting OLE Objects into a table (1 Viewer)

Learn2010

Registered User.
Local time
Today, 17:22
Joined
Sep 15, 2010
Messages
415
I have searched but cannot find an answer to my dilemma. I am trying to use an OLE Object as you would any other data but have had no success. Can the following be done?

I need signatures on some of my reports. I have stored them in tables as jpeg, bitmap, and png files using 2002 and 2007. What I need to do is to update the tables behind my reports with the OLE Objects, which are the signatures. If employee A is the person on the report, I need their signature. If employee B, then employee B's signature. I can even have more than one signature on the report so I can't just embed it into the report.

I have used append and update queries and the best I can do is to get what looks like a tilde in the field.

Is this even possible to update a table with an OLE Object using a query.?

Thank you.
 

June7

AWF VIP
Local time
Today, 13:22
Joined
Mar 9, 2014
Messages
5,470
I am confused. If you already have the signature images stored in a table why do you need to 'update the tables behind reports'. Can't you just include the signature table in the report RecordSource by join? Do the data records have empID?

I have never used the OLEObject type, always had issues with it. I use Attachment type field for storing images. Review http://stackoverflow.com/questions/4787149/how-to-auto-attach-images-in-access-2010-using-vba-macros and https://support.microsoft.com/en-us/help/158941/acc-how-to-load-ole-objects-from-a-folder-into-a-table
 

Learn2010

Registered User.
Local time
Today, 17:22
Joined
Sep 15, 2010
Messages
415
That was a bit confusing. I did find a way to use the image control to do what I need to do.

Thanks.
 

Users who are viewing this thread

Top Bottom