Open file and link Drawing to OLE field 1

[millrat]

Hi,
I would like to be able to click command button and browse for a Visio drawing and save in OLE object field in my table, preferably as a link not embedded. How can I do this?
All help appreciated.
Thanks,
millrat

 

[KenReay]

Hi

Why not save it in the table as a hyperlink?

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[millrat]

Hi Ken
I am using the drawing as a preview on a form and in a report with other info
regards,
millrat

 

[ajdesalvo]

First set the focus to the feild in your form that is for the OLE Object in your table. Then use Runcommand to browse and insert the object:

Forms![YourForm]![VisioField].Setfocus
DoCmd.RunCommand acCmdInsertObject

Good luck!

Anthony J. DeSalvo
President - ScottTech Software
"Integrating Technology with Business"