Need HELP With Filtering Calendar (1 Viewer)

Hi all,

I'm working on a booking system for my employer for some Chambers (Heat & Cold).
I found this database on www.utteraccess.com from Peter Hibbs which is very useful to me, and I need to filter it by Chamber.
I've added a dropdown but I find it a bit difficult now to filter the calendar by Chamber name(or ID).

Can You please help me with that?

Thank You,
Margarit

Hi Margarit

The monthly display is based on tblMonthData which is unfiltered.
In the combo after update event, you need to filter the source data in tblAppointments to create a filtered version of tblMonthData/tblWeekData/tblDailyData

This should be fairly simple and quick in operation

BTW Peter Hibbs is still active at UA and always very helpful/fast in responding to questions about his apps

I love this calendar - have used it in numerous applications. Peter does some great work. Sounds like Colin has you squared away, but didn't want to pass up an opportunity to commend Peter on his work.

Cheers,

jleach said:

I love this calendar - have used it in numerous applications. Peter does some great work. Sounds like Colin has you squared away, but didn't want to pass up an opportunity to commend Peter on his work.

Cheers,

Click to expand...

Yes I agree totally. Another point is that Peter's documentation / help guides are always superb.
His Flexgrid examples are brilliant - unfortunately only for 32-bit as MS haven't created a 64-bit version of the flexgrid control

Some years ago I created my own monthly / weekly / daily calendars (as I hadn't seen Peter's versions):



Although I was very pleased with the result, it took a lot of work. Peter's example would have been just as good & saved me hours!

Mind you I have a habit of reinventing the wheel.
A couple of years ago I spent ages creating a deep search & replace tool for Access. Again it works really well.



However, it was only after I completed it that someone mentioned the free VTools addin to me!

can you please try this.

arnelgp said:

can you please try this.

Click to expand...

Hi Arnel,

Thank You for your help,

I did find another solution though for that with a big help from Peter Hibbs on Uttesaccess.

I've created a Yearly view as well and Peter is helping to make it as look good as possible and do my job.

This is the file just in case someone could find it useful.