[AccessD] Gantt chart in Access

AD

...lol ...read your post and couldn't believe I'd missed something on 
Roger's library ...then I saw the date :)

William

--------------------------------------------------
From: "A.D. Tejpal" <adtp at airtelmail.in>
Sent: Tuesday, February 09, 2010 2:42 PM
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Gantt chart in Access

> William,
>
>    My sample db named Form_GanttChart might be of interest to you. It is 
> in access 2000 file format and is available at Rogers Access Library. 
> Link -
> http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=45
>
>    Two styles are covered:
>    (a) Style A: Using bound controls - character strings as chart.
>    (b) Style B: Using unbound controls - using label strips as chart.
>
>    Style A is editable. As the user enters start and end dates for various 
> tasks, the chart string gets updated automatically. Simultaneously, the 
> month / year markers at top get updated, duly taking into account the 
> overall time span from start of earliest task to finish of last task. 
> (Reference:  DAO 3.6).
>
>    Note: In both styles, there is no limit to the number of activities 
> that can be covered by the chart (as long as the number of pertinent 
> records are within the capacity of an access table).
>
> Best wishes,
> A.D. Tejpal
> ------------
>
>  ----- Original Message ----- 
>  From: William Hindman
>  To: accessd at databaseadvisors.com
>  Sent: Sunday, February 07, 2010 23:44
>  Subject: Re: [AccessD] Gantt chart in Access
>
>
>  gustav
>
>  ...thanks ...one of the first items I found binging around ...it works as 
> a
>  report but apparently not as a form unless you know some magic trick I 
> don't
>  :)
>
>  William
>
>  --------------------------------------------------
>  From: "Gustav Brock" <gustav at cactus.dk>
>  Sent: Sunday, February 07, 2010 3:38 AM
>  To: <accessd at databaseadvisors.com>
>  Subject: Re: [AccessD] Gantt chart in Access
>
>  > Hi William
>  >
>  > Couldn't you use a stack of rectangles you resize according to the 
> data?
>  > Here's an example by Duane Hookom for a report - could be adopted for a
>  > form, I guess:
>  >
>  > http://www.access.hookom.net/Samples.htm
>  >
>  > It's the Calendar Reports sample at the top.
>  > Some discussion of this can be found here:
>  >
>  > 
> http://g.www.ms.akadns.net/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.access.reports&tid=1f382f4b-60e9-429c-b96c-67b3b78f9bcc&cat=en_US_440664bc-4ba9-45ac-a263-75b2adc68568&lang=en&cr=US&sloc=&p=1
>  >
>  > /gustav
>  >
>  >
>  >>>> wdhindman at dejpolsystems.com 07-02-2010 01:33 >>>
>  > ...I need to produce a relatively simple tasking Gantt chart on a form,
>  > preferably with native Access (2003).
>  >
>  > ...I've binged all about and come up with nothing but a very 
> complicated
>  > report format, a linked Excel chart, or a variety of 3rd party ocx
>  > controls
>  > which require per user licensing, none of which I want to use ...this
>  > needs
>  > to run reliably in a runtime environment and work in an Access form.
>  >
>  > ...I've also looked at the Microsoft Chart control and the PivotView
>  > without
>  > success.
>  >
>  > ...anyone have tried and tested code, sample, or a link?
>  >
>  > William
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>