[AccessD] Gantt chart in Access

Gustav Brock Gustav at cactus.dk
Mon Feb 8 09:05:36 CST 2010


Hi William

A Font Gantt? Interesting. Sounds "advanced" contrary to "basic".
You could write a class for this. AddBar(), InsertBar(index) and so on ...

/gustav


>>> wdhindman at dejpolsystems.com 08-02-2010 13:58 >>>
...and I may just do that gustav ...there is a font designed specifically 
for that purpose that I've found while binging around ...but I'm still 
hoping that someone here has already done this ...its just Monday morning 
:))))

William

--------------------------------------------------
From: "Gustav Brock" <Gustav at cactus.dk>
Sent: Monday, February 08, 2010 2:01 AM
To: <accessd at databaseadvisors.com>
Subject: Re: [AccessD] Gantt chart in Access

> Hi William
>
> I may be missing something - have never worked with Gantt charts this 
> way - but if your requirements are really basic, what holds you from 
> adjusting the begin points and heights and widths of a series of coloured 
> rectangles, labels, or textboxes? I know that Gantt charts generally are 
> more than this but then you need to explain what "basic" implies here.
>
> /gustav
>
>
>>>> wdhindman at dejpolsystems.com 07-02-2010 19:14 >>>
> 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






More information about the AccessD mailing list