Visio Guy

Visio Discussions => ShapeSheet & Smart Shapes => Topic started by: afcwben on January 19, 2012, 01:37:22 PM

Title: Milestone Date
Post by: afcwben on January 19, 2012, 01:37:22 PM
I have some milestones on a visio timeline but I want the milestones to move based on a date that may change. i have linked them to a database but cannot seem to find the right way to make it look aup a date for a milestone. any guidance much appreciated.

Thanks
Title: Re: Milestone Date
Post by: aledlund on January 19, 2012, 02:18:39 PM
You've got a couple of things that are going to get in way.
a.) datalinking to a shape requires that the field  name and a custom property name be identical, so part of it  is planning the shape construction and the database schema to match.
b.) the timeline is an add-in with internal code that has to map to it's known shapes, so you don't get to change the custom property names that it uses
c.) the "prop.visMilestoneDate" property (in the milestone shape) is linked to a "User" field that datalinking cannot get to

options : create custom code to load the necessary datarecordsets with your database information and then have it update the user.visMilestoneDate field in the shape (which then should get reflected into the necessary custom property)

al
Title: Re: Milestone Date
Post by: afcwben on January 19, 2012, 03:05:10 PM
regarding custom code is there a link that can get me started on this?
Title: Re: Milestone Date
Post by: aledlund on January 19, 2012, 03:17:39 PM
Here's some sample code (vba going to access)

http://visguy.com/vgforum/index.php?topic=2298.msg10100#msg10100

here's some of the basics on understanding how visio works

http://msdn.microsoft.com/en-us/library/aa245244(v=office.10).aspx

and of course Chris has several references listed as well
al