D
David Carwile
So, I have this Access database that opens Visio and shoots all its
data out. Each record is a shape that connect based on the records
heirarchy. I added a custom menu to update and refresh everything.
My problem is figuring out how to make it so I can add a new shape
that will create a new record in the database OR that will at least
have the same custom properties and ODBC driver tag. I've got the
code to make this new shape, I just can't figure out where to put it.
This Visio drawing is dynamic and can be called anytime from Access so
the property can't be added to the Visio program through anything but
code. How can I create this new shape? (Give me a quick stepbystep)
Here are a few things I tried:
-Adding it to my custom menu. This did not work because the AddOn
property wouldn't call the code as a macro of Access or just as plain
code.
-CommandBars. OnAction method fails.
The option I'm currently investigating, but I would LOVE to avoid is
to reformat all of my code for creating the Visio to a seperate shell
program. I think that this should be possible from within Access
though so I'd appreciate any solutions that could be provided.
data out. Each record is a shape that connect based on the records
heirarchy. I added a custom menu to update and refresh everything.
My problem is figuring out how to make it so I can add a new shape
that will create a new record in the database OR that will at least
have the same custom properties and ODBC driver tag. I've got the
code to make this new shape, I just can't figure out where to put it.
This Visio drawing is dynamic and can be called anytime from Access so
the property can't be added to the Visio program through anything but
code. How can I create this new shape? (Give me a quick stepbystep)
Here are a few things I tried:
-Adding it to my custom menu. This did not work because the AddOn
property wouldn't call the code as a macro of Access or just as plain
code.
-CommandBars. OnAction method fails.
The option I'm currently investigating, but I would LOVE to avoid is
to reformat all of my code for creating the Visio to a seperate shell
program. I think that this should be possible from within Access
though so I'd appreciate any solutions that could be provided.