Access Table Form with a Calendar Filter. Please Help :( (1 Viewer)

[ChrisH81]

Hey.

So I'm not brilliant with Access but I'm trying to build a diary type system for my work its pretty simple but I need help with a couple of things. If you see the below picture its a template of what I am toying about with at the moment.

So I've got a overview form in a table layout, I want to add an interactive calendar across the top similar to the one in the pic except I'd like it so you could click left or right and it would go to the previous months or the following months. The other thing I am trying to do is have it so when you click a date in the calendar it will apply a filter to the booking date info below so you can see whats in on that day.

I'd appreciate any help or guidance.

 

[MajP]

Date Pickers, Calendar Controls, and Calendar resources

There has been some recent interest in a replacement for the MS calendar control that existed prior to 2010. I have been collecting date pickers, calendar controls, and calendars for a long time and thought it would be a good idea to have one thread with lots of good examples. Some of these...

www.access-programmers.co.uk

Look at the year view demo that does exactly what you show

 

[ChrisH81]

You are a STAR thanks so much I'll have a read through tonight!