Opening a VISIO Diagram

[Guest]

Hello,

I have a database with customer information. I would like to add a button
that will dynamically open a visio diagram of their network based on the
customer name.

For example if ABCCo has a visio diagram when you open the form with the
product details you will be able to click on a button that will open thier
Visio diagram.

I have tried to do this with the CreateObject (visio.application), but I
would rather have the visio document embedded in a form so that all viewing
is done in Access. The Diagram does not have to be editable, just viewable.

I have also tried dragging and dropping the visio diagram (this does not
allow the dynamic population I would like) and the size is enormous...Is
there a way to make the visio diagram strech and shrink to whatever size the
form is?

What I would do is name the visio diagram [Customer].vsd so the same form
would be opening, but Access would dynamically populate the form with the
correct Visio diagram.

Also, not all customers provide a visio diagram . Is it possible to make the
button visible only when a matching diagram is present.

 

[Guest]

One way to go about this is create an ole object field in customer table.
Then while data entering the information you can easily point to location
where vision diagram is and attach it with the record. Though, I would not
recommend this option given it takes up lot of space.