How to Create Custom Calendar

[Moore71]

Hi, I want to create a custom calendar in Microsoft Access and schedule appointment by categories, such that when an appointment has been scheduled in any category at any given time, no other appointment can be schedule on it until that appointment is cancelled or expires.

Can anyone give me a head start or sample solution to this effect?

Thanks in advance for a quick reply
Moore

 

[GinaWhipp]

Hopefully, this will get you started on the collision part...
http://access-diva.com/blog/?p=397

 

[Moore71]

okay, thanks for the quick guide.
I will try it and get back to you soon sir

Once again, thanks

 

[Moore71]

Ok chief,
you can make video on how to create renting of space to clients on time or days bases, like rent a space for 3-5 days and during that time that space is rented, no other client can rent that space until the time elapse or rent-age cancel / closed for another.
Maybe we can take this for a start

 

[jdraw]

Here is a link to some code that may be helpful re reservations.