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


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