View Single Post
  #15  
Old June 30th, 2009, 04:38 PM posted to microsoft.public.visio.general
John Goldsmith_Visio_MVP
external usenet poster
 
Posts: 85
Default Data does not refresh to drawing.

Hello Ken,

If you download the Visio 2007 SDK, you'll find you get a "Print ShapeSheet"
function under Tools / Add-Ons / SDK

http://www.microsoft.com/downloads/d...displaylang=en

Best regards

John


John Goldsmith (Visio MVP)
www.visualSignals.typepad.co.uk
www.visualSignals.co.uk
"Ken N" wrote in message
...
I am not sure I can legally do, I have tried working with the wizard then
copying field from the new corresponding master over to the existing shape
sheet. It seems promising but the data still will not refresh.

This is the-

User-Defined Cells
ODBCConnection="ODBCDataSource=MS Access
Database|ODBCQualifier=Z:\OSPKeyBE|ODBCTable=tblRo omName|2|Prop_XXXXX=Prop.XXXXX|Prop_Row_1=Prop.Row _1|1|ShapeKey=Prop.ShapeKey=32|"

"This cell contains the link information for the Database Wizard."

User.ODBCChecksum="d91ae3e1"

"This cell contains a checksum of the database record."

This lets me select records but does not refresh.
If you have some influence, you could convince MS to allow us to print or
copy shape sheets.
This in itself would make working with shapes easier.

--
Ken N


"AlEdlund" wrote:

In the left hand column of the table in the external data window, is
there a
little chain link displayed? This shows that the record and the shape are
linked. If I remember correctly, if you edit a shape manually the link
will
be broken and you will have to relink the shape to the record.
al

"Ken N" wrote in message
...
I used the wizard, the access table was built from the drawing so all
data
and column names were the same at the start. There is only the one
table
in
the external data window. When I refresh that table, it will update,
but
not
the shape. I have done this before and had no problems on shapes that I
built.

"AlEdlund" wrote:

How are you linking the data to Access (the data linking is a read
only
process, the database wizard round trips but the fields have to have
been
in
the shapes when you started)?
If you select from the menu bar view = external data window, how many
tables show up?

al


"Ken N" wrote in message
news I am working with a Visio drawing created with 2007 Pro, the columns
in
Access are the same as what they are labeled in Visio. (The Data
came
from
the drawing.) The table in Visio will update to the Access Databse
but
the
shape will not! I selected automaticaly link to do the whole page. I
have
also linked a single record and it will not update.

"AlEdlund" wrote:

which drawing are you referring to (the cad or the visio)? Are you
using
v2007 pro? Does the shape have a shapedata/property with the same
name
as
the access datafield? If you 'drag' the external datarecord field
from
the
external data table to the shape, does it apply?
al


"Ken" wrote in message
...
I extracted data from a Visio Drawing that was from a converted
CAD
DWG
file.
I then linked it back to Visio from Access.
It will refresh the linked table but not the data on the shape in
my
drawing!?!
Any sugestions?