William Hindman
wdhindman at dejpolsystems.com
Tue Feb 9 19:45:24 CST 2010
...thank you AD ...this is most of what I was hoping for ...the rest I can do myself ...AccessD always comes through :) William -------------------------------------------------- From: "William Hindman" <wdhindman at dejpolsystems.com> Sent: Tuesday, February 09, 2010 5:21 PM To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Subject: Re: [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 >> > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >