Manufacturing Information Solutions

[Stampman]

I have database setup to keep track of my tools, per job, I would like to add an AutoCad drawing to my report, I tried the hyperlink, but it just print the path of the file. Any help would be greatly appreciated.
_________________
Ed Davis

[mistux]

You can make the the field an OLE filed and then when you click on the filed it should open a dialog box then you can select your file. It will either display a thumbnail or the actual drawing.

I have done a similar thing for other customers so they can see a preview of their drawings.

Be aware, that doing it this way makes the database very large very quickly.

[Stampman]

I have got the drawing to open in a form, using Autodesk DWG TrueView, and using a macro:

AcCtrl8.PutSourcePath "C:\Documents and Settings\My Documents\Production\Tool2.dwg"

now is it possible to use cell data from a Access table to set the path, (in red), so as I move thru the records the drawing will change as well.

Thanks in advance.
_________________
Ed Davis

[mistux]