graphical presentation

  • Thread starter Thread starter Larry
  • Start date Start date
L

Larry

Hello.

I am making an application for hour-reservations.
I want to make a form presenting graphically one week at
the time to show vacant/occupied hours.

Please give me help on this.
 
Hi,


For each reservation, activate (turn visible) one rectangle previously
invisible.

With one triangle, position it top property at the height corresponding
to the room, its left property corresponding at the starting time, its width
property that correspond to the duration. Remember that, in VBA, those
properties are to be specified in twips.

You would have to create those rectangles in design mode. Their name
should be easy for your code to be able to pick them:

"Rect" & i


as example, for Rect1 to Rect200, if you pre-create 200 rectangles.



More versatile, but maybe a little bit more complex if you never did it
before, would be to use the GDI to draw on a picture box, such as the one
almost pre-canned for you at http://www.lebans.com/ The advantage of that
solution is that once draw, you can forget the "rectangle", while with the
first solution, you have to manage those used and those still available
(invisible)... but again, it may be easier to click on them (already they
have their mouse down event), than having to work with a general mouse click
event. All depend of what you expect you would have to do, and the time you
have to deliver...



Hoping it may help,
Vanderghast, Access MVP
 
Larry said:
Hello.

I am making an application for hour-reservations.
I want to make a form presenting graphically one
week at the time to show vacant/occupied hours.

Please give me help on this.

Probably easiest, cleanest solution is to use an unbound
Listbox or Grid control on your form

Unfortunately I'm not deeply familiar with which
Grid components come out-of-the box with Access
( we use our own TList control for such needs )
but you should be able to label the row and column
headings with Time and Days of the week

Then trap clicks on cells to allow user to
reserve some time. Change the cell's color
or simply enter text "Reserved" to show a time as
taken

If grid supplied with Access does not meet your needs
our TList control can be used and would be easy to set up
I'd be happy to discuss this further if you are interested.

-----

* * Please include a copy of this note with your reply

Jeff Bennett President
(e-mail address removed)

Bennet-Tec Information Systems, Inc
50 Jericho Tpk, Jericho, NY 11753
Phone 516 997 5596, Fax - 5597
WWW.Bennet-Tec.Com

RELIABLE Component Software
and Software Development Services
* TList/Pro * ALLText HT/Pro * MetaDraw *

====================== ======================
 
Back
Top