I have an access 2000 database that holds all office information by room 
number.  Then I have a Visio 2000 diagram that maps out the building by 
room number.  I am needing to combine the two seperate programs by the 
corresponding room number.  Does anybody know how I could click the office 
number in visio to pull up access 2000 to display just the records that 
belong to that office number?

Thanks in advance.
Keith

Visio does include an object model that you could address from within your
Access VBA code.  Conversely, I believe (though I have not used it) that
Visio includes VBA and you could open Access from there the same way, using
the object model.



-----Original Message-----
From: aidb50e9@m...
[mailto:aidb50e9@m...]
Sent: Thursday, December 12, 2002 10:16 AM
To: Access
Subject: [access] Linking by Office Number


I have an access 2000 database that holds all office information by room 
number.  Then I have a Visio 2000 diagram that maps out the building by 
room number.  I am needing to combine the two seperate programs by the 
corresponding room number.  Does anybody know how I could click the office 
number in visio to pull up access 2000 to display just the records that 
belong to that office number?

Thanks in advance.
Keith