- 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.
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: