[AccessD] Drawing on Ms Access Forms

Edz,

    My sample db named  Form_TimeLineDisplay, now available at Rogers Access Library, demonstrates display of time schedules as time line graphs.

Link - http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=45
 
    Various spells of time schedules (StartTime & EndTime) for a given task on given date get transformed into horizontal strips (each representing 15 minutes segment) via crosstab query. For example, a record having start & end times of 08:00 and 10:00 hrs respectively gets projected as 8 horizontal strips between 08 and 10 on the time line.

    Booked time strips falling between 06 to 22 hrs get highlighted in light blue, while those outside this span are colored pink. As the user carries out data entry, the time strip display gets updated simultaneously. Conditional formatting is used for implementing the color highlights. The effect is akin to a series of LED lights getting on or off as needed.

    For providing an overall view at a glance, two reports, showing the time lines for various dates and tasks have also been included. One report is sorted as per date / task while the other is sorted as per task / date.

    For ready reference, gist of time scheduling for given task on given date is also shown above the time line graph.

    The sample is in Access 2000 file format. Reference reqd: DAO 3.6

    You could adapt the underlying approach suitably, for your specific needs.

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

  ----- Original Message ----- 
  From: A.D.Tejpal 
  To: Access Developers discussion and problem solving 
  Sent: Friday, August 22, 2008 19:34
  Subject: Re: [AccessD] Drawing on Ms Access Forms


  Edz,

      For a given item on a given date, you wish to display a series of strips representing scheduled time slots.

      It should be feasible to meet the desired objective via conditional formatting of bound controls. Coding requirement would be minimal.

      I shall try to put together a sample db in next few days.

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

    ----- Original Message ----- 
    From: John Bartow 
    To: 'Access Developers discussion and problem solving' 
    Sent: Thursday, August 21, 2008 22:22
    Subject: Re: [AccessD] Drawing on Ms Access Forms


    Hi Ed,

    You can change some of the properties without going into design mode,
    background color would be one of these.
    You could use the after update event to iterate through the 120 rectangles
    and change the background color of each as required. Giving each a numerical
    name may aid in this.

    HTH
    John B.


    -----Original Message-----
    From: accessd-bounces at databaseadvisors.com
    [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Edward S Zuris
    Sent: Thursday, August 21, 2008 12:05 PM
    To: 'Access Developers discussion and problem solving'
    Subject: Re: [AccessD] Drawing on Ms Access Forms

     I'll give it a try.  It might work.  Only 120 rectangles.

    -----Original Message-----
    From: accessd-bounces at databaseadvisors.com
    [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte Foust
    Sent: Thursday, August 21, 2008 8:49 AM
    To: Access Developers discussion and problem solving
    Subject: Re: [AccessD] Drawing on Ms Access Forms

    Have you thought about putting line controls on the form, as many as you
    might need, setting their lengths to zero and then resetting the lengths in
    code to draw the line.  Have to admit that I can't remember trying this, but
    since you aren't creating the controls at runtime, I don't see why it should
    not work.

    Charlotte Foust 

    -----Original Message-----
    From: accessd-bounces at databaseadvisors.com
    [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Edward S Zuris
    Sent: Thursday, August 21, 2008 9:34 AM
    To: accessd at databaseadvisors.com
    Subject: [AccessD] Drawing on Ms Access Forms

     Hello Everyone

     I would like to create a timeline gage where a line shows  up on a form to
    shown that the hours of 10:00 thru 12:00  and 17:00 thru 19:00 are
    scheduled.

     I tried a text box, with a string where I could mid$ in  various characters
    an display them in real time, but  I am hopeing for a more elegant  solution
    that doesn't  look so hoky.

     Back in the Radio Shack Color computer days you could
     draw lines on the screen.   Using the createcontrol method
     requires that the forms switch back and forth of design mode.

     Any ideas on how to get around that ?

     Any examples I can look at at ?

     Thanks.

     Sincerely,
     Edz. . . .