GUI database

[Remnant]

I am attempting to setup a sort of GUI database using Visio for computer
equiptment here at my job. I tried getting the Access database to work with
Visio, but it was only a one way deal. Is it possible for me to setup a floor
plan with equiptment and have the properties change if I move equpitment in
Vision from one room to another? In other words, can I get the properties of
each individual unit to change by dragging them to another room?

[Al Edlund]

you'd have to do it with custom code. check my posting on rack diagram in
the vba forum.
Al

Post by Remnant
I am attempting to setup a sort of GUI database using Visio for computer
equiptment here at my job. I tried getting the Access database to work with
Visio, but it was only a one way deal. Is it possible for me to setup a floor
plan with equiptment and have the properties change if I move equpitment in
Vision from one room to another? In other words, can I get the properties of
each individual unit to change by dragging them to another room?

[Remnant]

I looked for the rack diagram post but couldnt find it. Is there anywhere
else I can find information on custom code? Setting this up in Visio is not
a neccessity for us, it just seemed that it would be helpful to use and fun
to figure out. Do you think that using custom code will be more trouble than
it is worth?

Post by Al Edlund
you'd have to do it with custom code. check my posting on rack diagram in
the vba forum.
Al

Post by Remnant
I am attempting to setup a sort of GUI database using Visio for computer
equiptment here at my job. I tried getting the Access database to work with
Visio, but it was only a one way deal. Is it possible for me to setup a floor
plan with equiptment and have the properties change if I move equpitment in
Vision from one room to another? In other words, can I get the properties of
each individual unit to change by dragging them to another room?

[Al Edlund]

the base part is that you will probably have to write something that is
'event' aware so that when a shape is moved you can test if it is now "in a
new room". This infers that you have shapes which can be identified as rooms
(either by name or property). It also infers that you have some logic
involved on what/how you want to change the properties of the shape. At
least some of these are already written in the visio sdk over on msdn (event
handling, property updating). attaching data between the drawing and a
database is a whole different story that you might want to take on as a
second project.
Al

Post by Remnant
I looked for the rack diagram post but couldnt find it. Is there anywhere
else I can find information on custom code? Setting this up in Visio is not
a neccessity for us, it just seemed that it would be helpful to use and fun
to figure out. Do you think that using custom code will be more trouble than
it is worth?

Post by Al Edlund
you'd have to do it with custom code. check my posting on rack diagram in
the vba forum.
Al

Post by Remnant
I am attempting to setup a sort of GUI database using Visio for computer
equiptment here at my job. I tried getting the Access database to work with
Visio, but it was only a one way deal. Is it possible for me to setup a floor
plan with equiptment and have the properties change if I move
equpitment
in
Vision from one room to another? In other words, can I get the
properties
of
each individual unit to change by dragging them to another room?