Sep 20 2005, 12:54 PM
I was wondering if there was a practical way to accomplish what I'm trying to.
I have a drawing in Visio. I would like to link the drawing to an Access database so that, when you click on an object in the drawing, it would be possible to bring up a bunch of information (records from a table) corresponding to that object in the Visio drawing.
Sounds kinda difficult to me. There is, in Visio, (Visio 2003 anyway), a way to link object to a database, but it does not have the functionality I am looking for. Does anyone know?
Sep 20 2005, 02:07 PM
not sure about Visio. You are talking about linking visio to access? Is that what you want or do you just want to have a drawing within access (which was originally from visio) and to work with it within access?
If so you could just insert the image somewhere (on a form) and then create a couple of buttons. Set the transperancy of these buttons (in their property) to YES. Now you can add actions to the on click event of these buttons.
Put the buttons above the image over the areas you want your users to be able to click. And voila they have an interactive drawing which can be clicked without knowing that they are actually buttons which are being clicked! Is that what you want?
Sep 20 2005, 02:40 PM
Thanks for the response.
My drawing is in Visio, and it will be changed. I actually figured out a decent way to access my information - I now highlight a name, click on Custom Properties, and it will bring up a window with all the fields from the database and their corresponding data (which I did via Tools -> Add-Ons -> Visio Extras -> Link to Database).
However, I do like your suggestion, as it could give me more flexability. I am going to try it and post back, for anyone trying to do something similar.
Sep 20 2005, 02:42 PM
Ahh...so you are trying to implement this within Visio!
I'm not too familiar with that program so I'm not sure if my suggestion will work.
Good luck though
Oct 3 2005, 12:07 PM
I've not done what you describe, but have worked through most other combinations of MSOffice tools interoperability. I'm sure that if you set a reference in your Visio VBA project to DAO or ADO you can access the Access tables and queries, and you should be able to use UserForms to present the data from Visio.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here