Calendar Tool Form

[treva26]

Does anyone know how I could go about making something like this:
http://www.aislebyaisle.com/access/calendartool.htm

I dont need all the options at the top, just a month & year selector.

Lets say my data is in a table DATA1 with the following fields:
DATE1
ORDERNUM
PRODUCT

So I pick a month and it shows me what orders are scheduled on each day of the month.

 

[treva26]

I think I have cracked it.

Here is the starting point in case anyone else is interested..

(it only shows the first 3 days of each month so far)

 

[treva26]

Maybe Im just talking to myself, but someone might find this in a search and find it useful...

I have now finished my schedule / calendar

Its weekly now, I couldnt fit 31 days on the form, and weekly is actually better for my uses anyway.