How do i create a form that looks like a monthly calendar

[Guest]

I need to make a form that IS a calendar but each day contains fields that
can be filled like an appointment book. For instance the form would display
all 30 days of the month and I would be able to input items in each day box,
such as "Job Name", & "Number of Units" that I want to schedule for that
particular day.

Thanks

 

[John Vinson]

I need to make a form that IS a calendar but each day contains fields that
can be filled like an appointment book. For instance the form would display
all 30 days of the month and I would be able to input items in each day box,
such as "Job Name", & "Number of Units" that I want to schedule for that
particular day.

Thanks

I've done this using a Form with 42 subforms (some months have parts
of six weeks), with VBA code to set the Recordsource properties of
each subform to a day's records. It's a bit repetitive and
timeconsuming to set up but works well.

John W. Vinson[MVP]

 

[Guest]

Check out Michael Blake's site at

http://www.weascend.com/Downloads.htm


There two calendars: CalendarDB.zip and CalendarLV.zip

See the descriptions for differences