Filling a text box from a database

M

mike

I'd like to have a textbox with a few descriptor words in it that can be
double-clicked to load the complete text from a database. I'm new to working
with Visio (2003), though I have VB.Net experience, so any help getting
started would be appreciated.
 
S

Shahzad Godil

Are you already using Visio ActiveX control in VB.Net. If not, you can
easily developed your database based solution using Visio ActiveX. Let me
know in detail all your requirement.

Thanks
Shahzad Godil
Karachi-Pakistan.
 
M

mike

Since I've just started, I've been exploring using vba, but I'd rather use
vb.net. What I need to do is have a text box, or some other shape, that will
contain a few keywords. When it is double clicked it will load the complete
text from a database, and when double clicked again will return to normal.
This doesn't have to be the final solution. I've always toyed with simplying
popping up a message box, or using custom properties.
Thanks for your help.
 
A

asoofi

I'm fairly new to visio programming (4/5 months?) but I'm not certain
that its capable of behavior that dynamic
 
A

Al Edlund

of course a simpler method would be to just hyperlink to a word doc/ book
mark.
al
 
S

Scott

Al Edlund said:
of course a simpler method would be to just hyperlink to a word doc/ book
mark.
al

This is a good suggestion if all of the supporting text for your shapes can
be stored in Word (or another doc type). In fact, it will work if the text is
in Access as well, as you can hyperlink to an access database.

But back to documents -- one of the nice things about hyperlinking to Word
or Excel is that you can create a named location (Insert/Bookmark in Word;
Insert/Name/Define in Excel) in the target document and can create your
hyperlink directly to that named location. For example if you have the text
for 50 shapes stored in the document, the hyperlink on each shape can take
the user directly to the specific text for that shape and not just open the
document at the top. No VBA or VB.net programming required.

OTOH, you can also place the detailed text in the Miscellaneous/Comment cell
and it will pop up when the user does a mouseover of the shape. This is
probably only useful if you don't need to edit or update the detailed text
very often. BTW, if you do decide to use popup text and expect to save
drawings as web pages, refer to this post to ensure that your popup text also
appears in the web-published versions of your drawings:
http://blogs.msdn.com/visio/archive/2006/07/04/655569.aspx
 
A

Acolin

the text entered in the Misc/comment cell on the ShapeSheet is the same text
you enter in the Insert/Edit Shape Screen Tip option off the menu
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top