hyperlinking to access
Printed From: CAD Forum
Category: EN
Forum Name: CAD - general
Forum Description: General discussion about CAD, formats, standards, management, licensing, networking, harware, other CAD applications
URL: https://www.cadforum.cz/forum_en/forum_posts.asp?TID=5539
Printed Date: 30.Sep.2026 at 13:32
Topic: hyperlinking to access
Posted By: knezevic
Subject: hyperlinking to access
Date Posted: 22.Mar.2011 at 17:42
| I'm attempting to open an access file, form and go to a specific record from an autocad drawing. using excell and creating a macro I've gotten as far as to get the form open but can't get to the specific record. can any 1 tell me how? |
Replies:
Posted By: John Connor
Date Posted: 22.Mar.2011 at 18:00
|
You say you are attempting to open an "access" file yet you mention Excel in the very next sentence. Are you trying to do this in MS Access or MS Excel? Either way, I think it is going to be difficult to open to a specific record without somehow including it in the path statement assuming AutoCAD will recognize it in the hyperlink. ------------- "Humans have a strength that cannot be measured. This is John Connor. If you are reading this, you are the resistance." <<AutoCAD 2015>> |
Posted By: knezevic
Date Posted: 22.Mar.2011 at 18:10
|
I have a autocad drawing with points these points are linked to a excell file in that excell file is a button when you click the button it starts a macro that then opens an access file and the form i want, but don't know how to get it to open the specific record. the record aka "point id" would be the same as the the point name in my autocad drawing. I may have to apply this macro to each individual point in my drawing. I just need that macro to perform a search on a specific column in the access table and for it to recognise the Point name in the autocad drawing and search the access table for that "point Id" |
Posted By: John Connor
Date Posted: 23.Mar.2011 at 00:19
|
That sounds rather involved. AutoCAD to Excel to Access.
------------- "Humans have a strength that cannot be measured. This is John Connor. If you are reading this, you are the resistance." <<AutoCAD 2015>> |