Insert OLEobject Into a field in a table programatically

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
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. ]
 
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!
 
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?
 
Back
Top