Enter Path for picture to be load in OLE Object in Access.

[1x2z3]

How can I Link my OLE Object to a Textbox where I entered the path of my graphic to be loaded into the OLE Object.
Want to do it without Right Clicking on the OLE Object - Insert Object - Create New/Create from file and so forth.

What coding can I use...

 

[randysmid]

Hi,
Assuming that you have a list of images (complete with path, e.g., lstImageNames), you can use this code:
OLEUnboundProductImage.Picture = lstImageNames.Value

I have a free database that demonstrates this (frmProductMaintenance), as well as a home-made security login screen, and a homemade menu system. Just send me an email, and I can send the Coredatabase.zip (about 2mb) directly to you.


HTH,
Randy Smith, MCP
rsmith@cta.org
California Teachers Association

 

[1x2z3]

Thanks Randysmith my E-Mail Address is: jsnel@absamail.co.za