Messing around with embedding pictures.

[Rodi]

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

 

[vseale]

Look at the Northwind sample database for ideas.

 

[Tim Ferguson]

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.

http://support.microsoft.com/default.aspx?scid=kb;en-us;103257


Hope that helps


Tim F