I've just created an extremely useful and relatively simple form that displays like a 35-box (7-days Sun-Sat across by 5 weeks down) wall calendar. You could easily customize it to be a 42-box calendar if desired.
In the 35-box calendar, for 30 and 31-day months where the first day of the month begins on a Fri. or Sat. and causes the last day or 2 of the month to overflow to a 6th row, I have those days appear back in the first row of the calendar.
The form is set up with 35 text boxes to capture the numeric day of the month, and superimposed in front of the text boxes are 35 corresponding list boxes that display the detailed data you wish to display for that day.
A user selects the month from a dropdown box and the year from a text box both located in the form header. After selecting the month and year, the calendar form refreshes to properly display the correct dates in the correct place on the calendar. The listbox data is filtered according to the date of the particular calendar box so that it only displays the data for that day...assuming there is data on that date. If not, it is just left blank...displaying the numerical day of the month.
The list box displaying the data is obviously compact (approx 1 3/4" wide by 2" tall) due to screen size restraints, but utilizes the horizontal and vertical scroll bars so that when you click on a particular day, you can view more data than what is actually initially displayed initially on the calendar. It at least provides the user an initial view that there is data on that date to be viewed.
I am using this form to display a monthly calendar view of activities that salespeople have done on any day in the month. I'm only displaying the salesperson's last name and the account they visited/contacted on that date. When a user clicks on that particular activity (which is a row in the appropriate list box filtered by the date it applies to), it will open up the detail form of that activity. Since I'm using horizontal and vertical scroll bars in each of the 35 day listboxes, you can probably add more information, but I kept it to 2 data fields cause that was all I really needed to display.
Really the only requirement you would need to use this form for your own purposes is that the query (or table) used as the row source of the listbox must include a date field. You would tailor your query to fit within the constructs of the form I created (simpler than it sounds), and then with a couple of minor customizations you should be good to go.
I was really psyched about the solution I came up because for years I've been asked by clients for something similar. In addition, it looks completely professional despite its simplicity. I'm willing to share it with anyone who needs it. I'm not looking for anything in return except some positive karma. I post this just as a thank you to all of the people who in this forum who anonymously helped me with their tips and code in the past.
Regards,
Rick
PS - Note that the same concept would work to make a calendar display report; however, a report doesn't have the luxury of horizontal and vertical scroll bars, so space is really an issue with reports.
In the 35-box calendar, for 30 and 31-day months where the first day of the month begins on a Fri. or Sat. and causes the last day or 2 of the month to overflow to a 6th row, I have those days appear back in the first row of the calendar.
The form is set up with 35 text boxes to capture the numeric day of the month, and superimposed in front of the text boxes are 35 corresponding list boxes that display the detailed data you wish to display for that day.
A user selects the month from a dropdown box and the year from a text box both located in the form header. After selecting the month and year, the calendar form refreshes to properly display the correct dates in the correct place on the calendar. The listbox data is filtered according to the date of the particular calendar box so that it only displays the data for that day...assuming there is data on that date. If not, it is just left blank...displaying the numerical day of the month.
The list box displaying the data is obviously compact (approx 1 3/4" wide by 2" tall) due to screen size restraints, but utilizes the horizontal and vertical scroll bars so that when you click on a particular day, you can view more data than what is actually initially displayed initially on the calendar. It at least provides the user an initial view that there is data on that date to be viewed.
I am using this form to display a monthly calendar view of activities that salespeople have done on any day in the month. I'm only displaying the salesperson's last name and the account they visited/contacted on that date. When a user clicks on that particular activity (which is a row in the appropriate list box filtered by the date it applies to), it will open up the detail form of that activity. Since I'm using horizontal and vertical scroll bars in each of the 35 day listboxes, you can probably add more information, but I kept it to 2 data fields cause that was all I really needed to display.
Really the only requirement you would need to use this form for your own purposes is that the query (or table) used as the row source of the listbox must include a date field. You would tailor your query to fit within the constructs of the form I created (simpler than it sounds), and then with a couple of minor customizations you should be good to go.
I was really psyched about the solution I came up because for years I've been asked by clients for something similar. In addition, it looks completely professional despite its simplicity. I'm willing to share it with anyone who needs it. I'm not looking for anything in return except some positive karma. I post this just as a thank you to all of the people who in this forum who anonymously helped me with their tips and code in the past.
Regards,
Rick
PS - Note that the same concept would work to make a calendar display report; however, a report doesn't have the luxury of horizontal and vertical scroll bars, so space is really an issue with reports.
