help needed in the worst way

[Scott T Mc Bride]

I want to be able to open a new form from a button when this new form opens
I would like it to look at the hypetext link in my (field k) and open that
to a cad drawing. or just have the button open the drawing ( i have over
900 drawings listed in field k) does anyone know how I can do this????

 

[Bryan Martin]

I guess you could try opening the cad program by calling "Shell(ProgramName,
WindowStyle)" from the onclick event of the button in a module while passing
the link to the ProgramName as a argument.

Not promising this will work but this would be my first route.

Bryan

 

[Norman Yuan]

If the CAD application supports ActiveX Automaion, like AutoCAD, you can do
almost every thing to the drawing from withing Access.

Simply set reference in Access VBE to AutoCAD type library, and you can
access AutoCAD objects and manipulate them.

 

[Albert D. Kallal]

Well, I don't recommend that you use hyper link fieds.

However, you can certanly launch/open any document from ms-access useing:


Application.FollowHyperLink "c:\my documents\test.doc"

The above would opend a word file.

So, if you have a simple plain text field with the cad document name, then:

Application.FollowHyperLink "you doc path name"