Visio Timeline in MS Access 2003 Data Access Page

G

GQxPAT

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.
 
J

JuneTheSecond

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
 
J

JuneTheSecond

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.
 

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