L
Larry Kennedy
I have looked on the web and in several MS Access books,
but I can not find an answer to this question. I have a
table with 2 OLE Object, Visio Drawings, in the table. I
know that the best way is to link to the file, but right
now that is not an option. The user types in the part
number and I have some code that brings up all the info
for that part, with the exception of the drawing, the only
way that I have been able to show the drawing is to create
a query that only outputs the 2 OLE objects and tie the
query to the record source. But this method adds new
records with only those 2 fields populated. I tried
setting the record source to the table but I still get
nothing. I have tried using bound and unbound object
frames with no success. With text boxes I can "assign" the
values (e.g. Forms!Form Name!Control = Recordset!Field) is
there a way to do this with OLE Objects? Thanks in
advance for any and all help...
but I can not find an answer to this question. I have a
table with 2 OLE Object, Visio Drawings, in the table. I
know that the best way is to link to the file, but right
now that is not an option. The user types in the part
number and I have some code that brings up all the info
for that part, with the exception of the drawing, the only
way that I have been able to show the drawing is to create
a query that only outputs the 2 OLE objects and tie the
query to the record source. But this method adds new
records with only those 2 fields populated. I tried
setting the record source to the table but I still get
nothing. I have tried using bound and unbound object
frames with no success. With text boxes I can "assign" the
values (e.g. Forms!Form Name!Control = Recordset!Field) is
there a way to do this with OLE Objects? Thanks in
advance for any and all help...