Establishing a data connection from within Access to Visio
Wed, 23 Jul 2008 19:11:11 -0700
I have a VBA program in Visio which loads data from an Access database, works
perfectly.
Now rather then working from Visio, I would like to start from Access and
then open Visio and generate a drawing based on the Access data. Starting the
same VBA script in Access throws an error â?? database locked â?? whi ...
|
Getting data from excel
Wed, 23 Jul 2008 01:23:00 -0700
I have looked a bit at the documentation here:
http://msdn.microsoft.com/da-dk/library/aa342321(en-us).aspx about connection
to an excel-sheet and pulling the data out, but I just get a: "Run-time
error":
"Could not make connection to data."
I'm not sure what is wrong, and the error message really doesn't gi ...
|
How do we get the Visio org charts into PowerPoint?
Tue, 22 Jul 2008 04:18:02 -0700
We currently produce org chart every month and output to html. What can we do
to allow users to cut and paste into Powerpoint? ...
|
Getting layer identifier
Tue, 22 Jul 2008 01:40:00 -0700
I am currently building a macro that, when I double-click on a shape, the
shape and the other things in it's layer turns invisible, and so far it works.
Now I'd like to make the macro dynamic so that I can use the same macro for
all the shapes (which are in different layers) without c/p'ing the code.
This mean ...
|
Shapes window closed on my dev box but appears on production box.
Mon, 21 Jul 2008 10:40:00 -0700
In the drawing tool in .Net C# I'm doing this to close the shapes window:
//get rid of shapes search window
Visio.Window winShapeSearch =
axDrawingControl1.Window.Windows.get_ItemFromID((int)Visio.VisWinTypes.visWinIDShapeSearch);
winShapeSearch.Visible = false;
winShapeSe ...
|
How do I get a report on all tables and properties in visio
Mon, 21 Jul 2008 09:25:03 -0700
I have built a Database diagram with about 40 tables and associated links. I
have input all of the filed information but cant figure out how to get a
report out on all of the tables. ...
|
Shape Properties drop-down selection list
Mon, 21 Jul 2008 08:04:10 -0700
We are using Visio with an Access link to document a small data center. We
will be assigning a large properties list to each shape, e.g.
servers/switches/etc. Because of the need for uniformity in the database, we
would like to use a drop-down selection list in the Visio properties just
like we will use in ...
|
|
|
ActiveX can't create object
Mon, 21 Jul 2008 06:36:01 -0700
I need an overview of all .vsd files in a certain directory, and for each
.vsd file the name of the seperate pages. I want to create this overview in
Excel using the following VBA code:
Dim vsoDoc As Visio.Document
Dim vsoPag As Visio.Page
Dim vsoPags As Visio.Pages
With Application.F ...
|
Is it possible to select a shape in a hyperlink?
Sat, 19 Jul 2008 21:48:00 -0700
Hi,
I'm creating a workflow in Visio and creating lots of hyperlinks connecting
pages and shapes. One of the options Visio gives me is zoom. So I can
hyperlink a shape to another one and when the user clicks the hyperlink
he/she's taken to that page/shape and it zooms in.
I was wondering if it's possible ...
|
Visio Drawing from database
Sat, 19 Jul 2008 15:57:49 +0100
Has anyone experimented with generating drawings from a database? I know how
to link objects in an existing drawing, but now want to be able to automate
the entire process. Obviously, writing the code to optimize the arrangement
of the objects on the page would be quite complex, but just populating a new
pag ...
|