Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Run Access queries from a visio drawing

Status
Not open for further replies.

JudyL

Instructor
Feb 21, 2001
148
US
Is there a way to automate running an access query by clicking on an onbject in a visio drawing?
 
Sure - write your required code in a macro (example macro1) then either:

1. Open the shapesheet for the Visio object and add this to the Events section, EventDblClick cell:
=RUNADDON("ThisDocument.macro1")

OR:
2. Right-click on the shape, select Format|Behaviour, go to the DoubleClick tab, select Run Macro and select your macro from the combobox

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Essex Steam UK for steam enthusiasts
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top