Schedule in Calender

[alka5seltzer]

Hi all,
I'm new to access and to here so be gentle with me

I'm creating a Database where I can track quotes, orders, customers, support/faults and products.

Is there any way to have a Form that looks like a calendar.. ie this will link to my orders table and show what orders are due shipping on each day.
This will be a quick reference for shipping dept.

Is this doable?

 

[Mile-O]

You could, in effect, create one but it would require 42 command buttons for the calendar dates alone, then code to calculate and caption which ones would be available based on the year and month. Plus what you want each command button to do (though a class module could be employed to deal with 42 separate OnClick() events.)

Now, simpler, could be a textbox that gives a calendar option, and a query based off that textbox.

 

[alka5seltzer]

I'm hoping to get something like this?

i.stack.imgur.com/IOtqx.png

 

[burrina]

This is NOT a project for an inexperienced user. Much easier to use simple forms/subforms and or tabbed forms.

 

[Mile-O]

I'm hoping to get something like this?

i.stack.imgur.com/IOtqx.png

I suppose that rather than command boxes in my attachment, you could use 42 listboxes. In the attached - which will throw up an error if month or year is blank - there is some data in for August 2014.

It's not your answer, but may give a suggestion of the complexity involved. May even be a guideline.

But, if starting out, I'd want to make sure you were designing your tables properly before you even think about designing forms.

 

[alka5seltzer]

Thanks so much for your help & example @Mile-O
Its much appreciated

 

[Mile-O]

Any questions on how it actually works, let us know.