A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Powerpoint, Publisher and Visio » Visio
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Data does not refresh to drawing.



 
 
Thread Tools Display Modes
  #11  
Old June 26th, 2009, 03:08 AM posted to microsoft.public.visio.general
AlEdlund
external usenet poster
 
Posts: 468
Default Data does not refresh to drawing.

As a question
"Running XP Pro on a Network with Visio 2007", are Visio, the drawing, and
Access all on the same client workstation?
........

"AlEdlund" wrote in message
news
If you're going to use the database wizard, I'd start over here
http://office.microsoft.com/en-us/vi...191751033.aspx
If you're going to use datalinking, I'd start over here
http://office.microsoft.com/training...RC101977211033


al


"Ken N" wrote in message
...
Running XP Pro on a Network with Visio 2007:
Under tools I did use the “Database Wizard”
Following the wizard through-
Link shapes to database records
Shapes in drawing
Select shapes
Choose source
Table
Choose Prim-Key Field
Choose default key or click none
If I choose none it does nothing!! If I choose default it changes all to
the
default. But neither give me a workable link. No linked table and a error
message when I try to refresh –

--
Ken N


"Ken N" wrote:

I have reworded the question in a new thread dated today 6/25/09. The
problem
is linking to the existing shape without creating a new datagraphic.
--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?

  #12  
Old June 26th, 2009, 04:51 PM posted to microsoft.public.visio.general
Ken N
external usenet poster
 
Posts: 11
Default Data does not refresh to drawing.

No, Access is on a server, I can link to the database. My problem is linking
the original shape. The original shape is just a rectangle that was imported
from CAD. It had two properties (a room number and name) that I want linked
to the database. Because the room number and the door numbers look similar we
do not show the room number on the drawing and I am using it as the key. I
exported the data from the drawing originally so it would make sense that I
should be able to link back to it. The only part of the shape that is visible
is the room name so it acts like a label for the room. I cannot seem to tie
the two together without creating a new datagraphic. The drawings take up
enough space without adding redundancy, which I do not want. Monday I will
try to make a linked master. I do not have the path to the “Master Database”
so I will have to wait for my IT dept to show up. (See if I keep resetting
their servers!)
--
Ken N


"AlEdlund" wrote:

As a question
"Running XP Pro on a Network with Visio 2007", are Visio, the drawing, and
Access all on the same client workstation?
........

"AlEdlund" wrote in message
news
If you're going to use the database wizard, I'd start over here
http://office.microsoft.com/en-us/vi...191751033.aspx
If you're going to use datalinking, I'd start over here
http://office.microsoft.com/training...RC101977211033


al


"Ken N" wrote in message
...
Running XP Pro on a Network with Visio 2007:
Under tools I did use the “Database Wizard”
Following the wizard through-
Link shapes to database records
Shapes in drawing
Select shapes
Choose source
Table
Choose Prim-Key Field
Choose default key or click none
If I choose none it does nothing!! If I choose default it changes all to
the
default. But neither give me a workable link. No linked table and a error
message when I try to refresh –

--
Ken N


"Ken N" wrote:

I have reworded the question in a new thread dated today 6/25/09. The
problem
is linking to the existing shape without creating a new datagraphic.
--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?


  #13  
Old June 26th, 2009, 07:51 PM posted to microsoft.public.visio.general
AlEdlund
external usenet poster
 
Posts: 468
Default Data does not refresh to drawing.

can you share the drawing you are trying to export/import?
al

"Ken N" wrote in message
...
No, Access is on a server, I can link to the database. My problem is
linking
the original shape. The original shape is just a rectangle that was
imported
from CAD. It had two properties (a room number and name) that I want
linked
to the database. Because the room number and the door numbers look similar
we
do not show the room number on the drawing and I am using it as the key. I
exported the data from the drawing originally so it would make sense that
I
should be able to link back to it. The only part of the shape that is
visible
is the room name so it acts like a label for the room. I cannot seem to
tie
the two together without creating a new datagraphic. The drawings take up
enough space without adding redundancy, which I do not want. Monday I will
try to make a linked master. I do not have the path to the “Master
Database”
so I will have to wait for my IT dept to show up. (See if I keep resetting
their servers!)
--
Ken N


"AlEdlund" wrote:

As a question
"Running XP Pro on a Network with Visio 2007", are Visio, the drawing,
and
Access all on the same client workstation?
........

"AlEdlund" wrote in message
news
If you're going to use the database wizard, I'd start over here
http://office.microsoft.com/en-us/vi...191751033.aspx
If you're going to use datalinking, I'd start over here
http://office.microsoft.com/training...RC101977211033


al


"Ken N" wrote in message
...
Running XP Pro on a Network with Visio 2007:
Under tools I did use the “Database Wizard”
Following the wizard through-
Link shapes to database records
Shapes in drawing
Select shapes
Choose source
Table
Choose Prim-Key Field
Choose default key or click none
If I choose none it does nothing!! If I choose default it changes all
to
the
default. But neither give me a workable link. No linked table and a
error
message when I try to refresh –

--
Ken N


"Ken N" wrote:

I have reworded the question in a new thread dated today 6/25/09. The
problem
is linking to the existing shape without creating a new datagraphic.
--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?


  #14  
Old June 30th, 2009, 04:25 PM posted to microsoft.public.visio.general
Ken N
external usenet poster
 
Posts: 11
Default Data does not refresh to drawing.

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?

  #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?


  #16  
Old June 30th, 2009, 09:08 PM posted to microsoft.public.visio.general
Ken N
external usenet poster
 
Posts: 11
Default Data does not refresh to drawing.

I could send a portion of the drawing. Can you see my e-mail address at
odrc.state.oh
--
Ken N


"AlEdlund" wrote:

can you share the drawing you are trying to export/import?
al

"Ken N" wrote in message
...
No, Access is on a server, I can link to the database. My problem is
linking
the original shape. The original shape is just a rectangle that was
imported
from CAD. It had two properties (a room number and name) that I want
linked
to the database. Because the room number and the door numbers look similar
we
do not show the room number on the drawing and I am using it as the key. I
exported the data from the drawing originally so it would make sense that
I
should be able to link back to it. The only part of the shape that is
visible
is the room name so it acts like a label for the room. I cannot seem to
tie
the two together without creating a new datagraphic. The drawings take up
enough space without adding redundancy, which I do not want. Monday I will
try to make a linked master. I do not have the path to the “Master
Database”
so I will have to wait for my IT dept to show up. (See if I keep resetting
their servers!)
--
Ken N


"AlEdlund" wrote:

As a question
"Running XP Pro on a Network with Visio 2007", are Visio, the drawing,
and
Access all on the same client workstation?
........

"AlEdlund" wrote in message
news If you're going to use the database wizard, I'd start over here
http://office.microsoft.com/en-us/vi...191751033.aspx
If you're going to use datalinking, I'd start over here
http://office.microsoft.com/training...RC101977211033


al


"Ken N" wrote in message
...
Running XP Pro on a Network with Visio 2007:
Under tools I did use the “Database Wizard”
Following the wizard through-
Link shapes to database records
Shapes in drawing
Select shapes
Choose source
Table
Choose Prim-Key Field
Choose default key or click none
If I choose none it does nothing!! If I choose default it changes all
to
the
default. But neither give me a workable link. No linked table and a
error
message when I try to refresh –

--
Ken N


"Ken N" wrote:

I have reworded the question in a new thread dated today 6/25/09. The
problem
is linking to the existing shape without creating a new datagraphic.
--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?


  #17  
Old June 30th, 2009, 09:16 PM posted to microsoft.public.visio.general
AlEdlund
external usenet poster
 
Posts: 468
Default Data does not refresh to drawing.

all I see is the kenN..
You can use edlund60014 over on yahoo..
al

"Ken N" wrote in message
...
I could send a portion of the drawing. Can you see my e-mail address at
odrc.state.oh
--
Ken N


"AlEdlund" wrote:

can you share the drawing you are trying to export/import?
al

"Ken N" wrote in message
...
No, Access is on a server, I can link to the database. My problem is
linking
the original shape. The original shape is just a rectangle that was
imported
from CAD. It had two properties (a room number and name) that I want
linked
to the database. Because the room number and the door numbers look
similar
we
do not show the room number on the drawing and I am using it as the
key. I
exported the data from the drawing originally so it would make sense
that
I
should be able to link back to it. The only part of the shape that is
visible
is the room name so it acts like a label for the room. I cannot seem to
tie
the two together without creating a new datagraphic. The drawings take
up
enough space without adding redundancy, which I do not want. Monday I
will
try to make a linked master. I do not have the path to the “Master
Database”
so I will have to wait for my IT dept to show up. (See if I keep
resetting
their servers!)
--
Ken N


"AlEdlund" wrote:

As a question
"Running XP Pro on a Network with Visio 2007", are Visio, the drawing,
and
Access all on the same client workstation?
........

"AlEdlund" wrote in message
news If you're going to use the database wizard, I'd start over here
http://office.microsoft.com/en-us/vi...191751033.aspx
If you're going to use datalinking, I'd start over here
http://office.microsoft.com/training...RC101977211033


al


"Ken N" wrote in message
...
Running XP Pro on a Network with Visio 2007:
Under tools I did use the “Database Wizard”
Following the wizard through-
Link shapes to database records
Shapes in drawing
Select shapes
Choose source
Table
Choose Prim-Key Field
Choose default key or click none
If I choose none it does nothing!! If I choose default it changes
all
to
the
default. But neither give me a workable link. No linked table and a
error
message when I try to refresh –

--
Ken N


"Ken N" wrote:

I have reworded the question in a new thread dated today 6/25/09.
The
problem
is linking to the existing shape without creating a new
datagraphic.
--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?


  #18  
Old July 1st, 2009, 04:23 PM posted to microsoft.public.visio.general
AlEdlund
external usenet poster
 
Posts: 468
Default Data does not refresh to drawing.

I suggested adding a macro to refresh the drawing
al


Public Sub DoRefresh()
Dim myPage As Visio.Page
Dim myDoc As Visio.Document

Set myDoc = Visio.Application.ActiveDocument

For Each myPage In myDoc.Pages
RUNADDON ("DBRS")
' MsgBox CStr(myPage.Name)
Next myPage

End Sub

"AlEdlund" wrote in message
...
all I see is the kenN..
You can use edlund60014 over on yahoo..
al

"Ken N" wrote in message
...
I could send a portion of the drawing. Can you see my e-mail address at
odrc.state.oh
--
Ken N


"AlEdlund" wrote:

can you share the drawing you are trying to export/import?
al

"Ken N" wrote in message
...
No, Access is on a server, I can link to the database. My problem is
linking
the original shape. The original shape is just a rectangle that was
imported
from CAD. It had two properties (a room number and name) that I want
linked
to the database. Because the room number and the door numbers look
similar
we
do not show the room number on the drawing and I am using it as the
key. I
exported the data from the drawing originally so it would make sense
that
I
should be able to link back to it. The only part of the shape that is
visible
is the room name so it acts like a label for the room. I cannot seem
to
tie
the two together without creating a new datagraphic. The drawings take
up
enough space without adding redundancy, which I do not want. Monday I
will
try to make a linked master. I do not have the path to the “Master
Database”
so I will have to wait for my IT dept to show up. (See if I keep
resetting
their servers!)
--
Ken N


"AlEdlund" wrote:

As a question
"Running XP Pro on a Network with Visio 2007", are Visio, the
drawing,
and
Access all on the same client workstation?
........

"AlEdlund" wrote in message
news If you're going to use the database wizard, I'd start over here
http://office.microsoft.com/en-us/vi...191751033.aspx
If you're going to use datalinking, I'd start over here
http://office.microsoft.com/training...RC101977211033


al


"Ken N" wrote in message
...
Running XP Pro on a Network with Visio 2007:
Under tools I did use the “Database Wizard”
Following the wizard through-
Link shapes to database records
Shapes in drawing
Select shapes
Choose source
Table
Choose Prim-Key Field
Choose default key or click none
If I choose none it does nothing!! If I choose default it changes
all
to
the
default. But neither give me a workable link. No linked table and
a
error
message when I try to refresh –

--
Ken N


"Ken N" wrote:

I have reworded the question in a new thread dated today 6/25/09.
The
problem
is linking to the existing shape without creating a new
datagraphic.
--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?


  #19  
Old July 1st, 2009, 07:00 PM posted to microsoft.public.visio.general
AlEdlund
external usenet poster
 
Posts: 468
Default Data does not refresh to drawing.

a v2007 version for refresh


Public Sub DoRefresh()
Dim myPage As Visio.Page
Dim myDoc As Visio.Document

Set myDoc = Visio.Application.ActiveDocument

Dim visAddons As Visio.Addons
Dim addonDBRS As Visio.Addon

Set visAddons = Application.Addons
Set addonDBRS = visAddons("DBRS")


For Each myPage In myDoc.Pages
addonDBRS.Run ""
' MsgBox CStr(myPage.Name)
Next myPage

End Sub



"AlEdlund" wrote in message
...
all I see is the kenN..
You can use edlund60014 over on yahoo..
al

"Ken N" wrote in message
...
I could send a portion of the drawing. Can you see my e-mail address at
odrc.state.oh
--
Ken N


"AlEdlund" wrote:

can you share the drawing you are trying to export/import?
al

"Ken N" wrote in message
...
No, Access is on a server, I can link to the database. My problem is
linking
the original shape. The original shape is just a rectangle that was
imported
from CAD. It had two properties (a room number and name) that I want
linked
to the database. Because the room number and the door numbers look
similar
we
do not show the room number on the drawing and I am using it as the
key. I
exported the data from the drawing originally so it would make sense
that
I
should be able to link back to it. The only part of the shape that is
visible
is the room name so it acts like a label for the room. I cannot seem
to
tie
the two together without creating a new datagraphic. The drawings take
up
enough space without adding redundancy, which I do not want. Monday I
will
try to make a linked master. I do not have the path to the “Master
Database”
so I will have to wait for my IT dept to show up. (See if I keep
resetting
their servers!)
--
Ken N


"AlEdlund" wrote:

As a question
"Running XP Pro on a Network with Visio 2007", are Visio, the
drawing,
and
Access all on the same client workstation?
........

"AlEdlund" wrote in message
news If you're going to use the database wizard, I'd start over here
http://office.microsoft.com/en-us/vi...191751033.aspx
If you're going to use datalinking, I'd start over here
http://office.microsoft.com/training...RC101977211033


al


"Ken N" wrote in message
...
Running XP Pro on a Network with Visio 2007:
Under tools I did use the “Database Wizard”
Following the wizard through-
Link shapes to database records
Shapes in drawing
Select shapes
Choose source
Table
Choose Prim-Key Field
Choose default key or click none
If I choose none it does nothing!! If I choose default it changes
all
to
the
default. But neither give me a workable link. No linked table and
a
error
message when I try to refresh –

--
Ken N


"Ken N" wrote:

I have reworded the question in a new thread dated today 6/25/09.
The
problem
is linking to the existing shape without creating a new
datagraphic.
--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?


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:30 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.