[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. . . .