Messing around with embedding pictures.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

MS Access 2000

I know this isn't the recommended way to go, but I was trying to use an
INSERT statement in VBA to pass an embedded picture to a table. Doing so
with a text box is simple, as the .Value property is avalable to pass the
data entered to the table.

So, if I wanted to do this in a simple "insert into..." and my OLE control
from the form is called "Pic", I know I can;t use Pic.Value to get the
picture to embed it. Does anyone know how I'd go about doing this??

I've already been here:
http://support.microsoft.com/default.aspx?scid=kb;en-us;209990

and here:
http://accdevel.tripod.com/imaging.htm

The first just deals with a form with no connection to a table; the second,
frankly, I don't completely understand, and i know one of the Ten
Commandments is not to use code you don't understand :) But, it does seem to
change the OLE properties on the obect in the form, then uses the standard
DoCmd.RunCommand acCmdSaveRecord to save the record to the database. I'm not
using the standard Save or Add command buttons, so I have to fashion my own
insertion string, hence the question.

Hope that was clear and thanks,
Rodi
 
AFAIK you cannot directly accomplish what you are trying to do.

With that being said, I know you can programmatically copy the Value
prop of an OLE Frame control from one control to another. I have
absolutely no idea whether this would work wihtin the context of the
Insert statement.

--

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