Access Access, OLE Object Automatic entry problem

Joined
Jul 26, 2007
Messages
1
Reaction score
0
Access Challenge, Automatic entry of OLE Objects

Hello there, I am trying to automatize the entry of OLE objects in a database. I have a form with three unbound picture holders as well as three tick boxes that relate to three OLE objects and three yes/no fields in a table. When I click a tick box the form runs a macro. What I want this macro to do is to add a picture located in a gif file to one of the OLE fields. I have the files in a folder called c:\pictures\ The pictures names are listed as picturea1.gif, picturea2.gif, pictureb1.gif, pictureb2.gif, pictureb3.gif, where "a","b","c",etc are the record numbers and 1,2,3 are the pictures for each record. Is it possible to do this with SetValue? If not, is there another way to do it? Thanks.
 
Last edited:
Back
Top