Milestone Date

Started by afcwben, January 19, 2012, 01:37:22 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

afcwben

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

aledlund

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

afcwben

regarding custom code is there a link that can get me started on this?

aledlund

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