Visio Timeline in MS Access 2003 Data Access Page

Visio Timeline in MS Access 2003 Data Access Page

Post by GQxPA » Sun, 03 Jul 2005 02:22:12


I have inserted a Visio ActiveX Control in a MS Access 2003's Data
Access Page. The Data Access Page is currently displaying a Visio
Timeline drawing document that I have saved on my C:\ drive. The Visio
Timeline drawing document is dynamically getting data from a Access
table to form its timeline. The reason why I am using MS Access 2003
is because MS Access 2003's Data Access Page support a good dynamic
Excel charts feature. The Excel data can be stored in a Access Table
and the Excel charts are then created in the Data Access Page web
environment. The problem is as follow: When a user launches the HTML
file, the Visio Timeline drawing is not updating itself from the data
in the Access table. How and what do I need to do in order to make
this happen? Please advise. Thank you.
 
 
 

Visio Timeline in MS Access 2003 Data Access Page

Post by GQxPA » Sun, 03 Jul 2005 02:22:18

I have inserted a Visio ActiveX Control in a MS Access 2003's Data
Access Page. The Data Access Page is currently displaying a Visio
Timeline drawing document that I have saved on my C:\ drive. The Visio
Timeline drawing document is dynamically getting data from a Access
table to form its timeline. The reason why I am using MS Access 2003
is because MS Access 2003's Data Access Page support a good dynamic
Excel charts feature. The Excel data can be stored in a Access Table
and the Excel charts are then created in the Data Access Page web
environment. The problem is as follow: When a user launches the HTML
file, the Visio Timeline drawing is not updating itself from the data
in the Access table. How and what do I need to do in order to make
this happen? Please advise. Thank you.

 
 
 

Visio Timeline in MS Access 2003 Data Access Page

Post by SnVuZVRoZV » Mon, 04 Jul 2005 14:09:01

I am not sure how to write the code in ms access vba, but how would you think
for saving visio drawing before closing access application, and next time,
for opening the saved drawing.
In case of vb6 project, the visio drawing can be saved by SaveAsEx method,
foe example,
FileName = Me.Dir1.Path & "\" & Me.Text1.Text
MDIForm1.DrawingControl1.Src = ""
MDIForm1.DrawingControl1.Document.SaveAsEx FileName, &H2
 
 
 

Visio Timeline in MS Access 2003 Data Access Page

Post by SnVuZVRoZV » Mon, 11 Jul 2005 09:32:09

According to the notes in msdn site about Drawing Control in the web, Visio
darwing model can not be accessed by script language on the page. But by
user's operation on the drawing control in the web user can copy and paste
resultant drawing to the regular Visio, or open new stencil and copy the
resultant model on it, and save the stencil. But, I hope someone else find
better way.