Hyperlinking from Access

[Vivian Carroll]

In Access 2000, is it possible to have a text field contain a hyperlink to
an AutoCad drawing? If so, how?

The database is a sort of index of all of the engineering drawings - after
the user finds the record for the drawing he wants, he currently has to go
go into AutoCad or Explorer and find/open the drawing itself. It would be
great if he could click a hyperlink in the Access record to open the drawing
in AutoCad.

TIA,
Vivian Carroll

 

[John Parkinson]

Vivian,

When you are building your table, create a field for DWG
files and in the data type use 'hyperlink'. This will
allow you to trace the path to the drawing file when you
are entering data. I am not sure if clicking on the
hyperlink on a form will open the drawing, knowing how
tricky AutoCAD can be sometimes, but give it a shot.

John Parkinon

 

[Vivian Carroll]

Thanks for the speedy response John, I'll try it.

Vivian

 

[Van T. Dinh]

You can store the path to the drawing file as a Hyperlink Field.

Alternatively, you can store it simply as a Text Field and then use the
FollowHyperlink Method in code to open the drawing in AutoCad.