Visio control Access, but very thin in Visio
Posted on 2005-05-13
I'm looking for a general approach to getting an event in Visio VBA to pass parameters to and initiate a subroutine in Access VBA.
I want to have the minimum amout of code possible in Visio. I'm familiar with using events in shape cells in Visio, to trigger subroutine calls in Visio's VBA, and I'm familiar with implementing the Automation links between Visio and Excel (Visio controls Excel data), and between Access and Visio (Access controls shape cell values)
What i am looking for is a general approach in which the Visio shape cell events would initiate a Visio subroutine, but the Visio subroutine would be very small, and it would (FILL IN HERE WITH HOW TO AUTOMAGICALLY PERFORM) initiate and pass parameters to an Access subroutine, which would then update the database from with the Access VBA code.
The reason is that the Visio doc is going to be a data file that will be go in a lot of different directions, and I wanted to minimize the amount of code in the Visio doc.
So, I don't know if these is even possible, because Access would have to be running and be able to receive, I don't know, an interrupt from Visio?..( BZZZTT!!! ZAP!!! NO-OP!!!)...anyway, I'm just starting to research this.
Clearly, I could do what I need to by just running the Access database update code from within Visio, which I'll do to get started, but I want to see if it can be done this other way, too.
Any guidance will be appreciated!