Insert OLEobject Into a field in a table programatically

G

Guest

I have a form with an Image control containing a FirmLogo. How can I insert
this picture into a table, that has a field with type OLE Object? Thank's for
helping
 
S

Stephen Lebans

Open the Form in Design view
Open the Table with the OLE field inDatasheet view
Right Click on the Image control and select Copy
Paste it directly into the OLE field

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
G

Guest

Stephen Lebans said:
Open the Form in Design view
Open the Table with the OLE field inDatasheet view
Right Click on the Image control and select Copy
Paste it directly into the OLE field
Click to expand...

I would like to do this programmatically, but can't find the right syntax.
[ The reason to have pictures stored in the database is that they will be
very small icons that are stored in a reference table holding categories of
the real data.
The reference table should be easily maintainable though. ]
 
C

CulminIT

I'm also stuck trying to insert a file into an ole object field
programatically. I know how to do it manually in the table, but I need the
code to perform this function in a form in the background (no user
interaction). Please help!
 
C

CulminIT

Thanks Stephen

I realised it should be an old problem, but I could not find any help on the
internet that was useful. Your article was incredibly useful, so thanks!

I have another problem now, that I cannot seem to find in any help file. Do
you know what the class name is for Snapshot Viewer? The equivalent of
Excel.Sheet and Paint.Picture for example. Is there somewhere where these
are listed?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to insert a bmp file into Access 2003 table using code 2
code to load picture in OLEobject field? 2
Open OLE Object 2
Programatically insert pictures into a table field 2
Inserting Embed Viso Drawing From access Table into Power Point 2
How do I insert into a OLE Odject Type field at runtime 2
Importing text files into a table 3
Try again - Retrieving embedded word documents from an access tabl 10

Top