Creating a calendar then entering data

[ColinEssex]

Hi All,

Is it possible to create a 'calendar' on a form with 'squares' for each day. One month at a time. Then populate the days with names or whatever.

Example; Show all names of staff who's training is booked on x day by viewing the whole month at a glance.

I can't seem to get my head round this. Has anyone any clues? - 31 subforms perhaps?

Thanks in advance
Colin

 

[Hayley Baxter]

Is the calendar control not any good for you?

Hayley

 

[Rich]

Look up Crosstab queries forms etc, if you download the qrySamp from MS there are a few useful examples of crosstabs.
HTH

 

[ColinEssex]

Hi Hayley,

I've used the calendar control to select a day or range then have the answer in a form, but was wondering if you can create something then select say 'April' from a combo then 30 named (with the day) squares would appear with the persons name in the appropriate day.

Colin

 

[ogg13]

Did you ever get an answer to this Colin? I, too, am looking for a calendar that can display some bloody information, the build in access ocx just doesnt cut it.

 

[Bob Miller]

I built a meeting room scheduler that would draw the time blocks that a room was scheduled. It would fill in the purpose and the scheduler in the block from info in a table. There is a way in VBA to do this but I can't remember the exact coding. I left the db at work and stupidly, it wasn't one that I copied to take with me when I retired. To get you started, distances are measured in twips where 1 inch on the form = 1440 twips so to set the height of an object use the following
Me!objectname.Height = 1440
Other properties that can be used are Width, Top, and Left. You could build your form with 42 squares to accomodate all possibilities of days in any month, determine which will have dates in them and which won't and set those that don't have dates in the make not visible. If you have each square 1" by 1" the third square would be at left=4320 and top=0.
Hope this gets you started.

 

[ColinEssex]

Did you ever get an answer to this Colin? I, too, am looking for a calendar that can display some bloody information, the build in access ocx just doesnt cut it.

Gosh, long time ago. I think I did do it. I'll try and see how I did it.

Col