[AccessD] Gantt chart in Access

A.D. is a machine.. Nice Indeed!!

WBR
Robert


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of A.D. Tejpal
Sent: Wednesday, February 10, 2010 12:45 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Gantt chart in Access

William,

    You are most welcome! This was a fresh sample, put together in response
to the current thread.

    On the subject of graphical depiction, some of my other samples are
mentioned below, for ready reference (All available at Roger's site):

    1 - Form_TimeLineDisplay:
    It handles micro-planning for 24 hours of the day, depicting the
occupied time strips (15 minutes per slot) on a form, with color highlights
on controls mimicking a row of LED lights. Report generation for these
graphs is also provided.

    2 - Report_PseudoGraphs:
    Various styles of simulated graphs on a report (e.g. Salary scales, Room
Bookings, Score sheets for star war games), using multiple instances of a
single text box are demonstrated.

    3 - Charts_AccessAndExcel:
    It covers a combination chart showing the readings for patient's blood
pressure - systolic & diastolic as twin line series, along with pulse
readings in column style. For ready appreciation, the same set of readings
is displayed in two alternative modes, one as access native graph (on form
as well as report) and the other as an Excel graph, dynamically created in
Excel (based upon Access data) and then displayed on access form via OLE
control.

    4 - Charts_PieTypeOnReports:

Best wishes,
A.D. Tejpal
------------


----- Original Message ----- 
From: William Hindman 
To: Access Developers discussion and problem solving 
Sent: Wednesday, February 10, 2010 07:15
Subject: Re: [AccessD] Gantt chart in Access


  ...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
  >> ------------
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com