Booking System

[MickB]

Hi, Im fairly new to Access but ok with ASP. I need to build an Access
database to provide a booking system for 5 apartments such that for any given
apartment there can not be any clashes or overlaps on dates between clients.
Also to sort by dates to find availabiliiy.
At the moment I have a table for recording bookings with clients date
requirements (no apartment allocations except by doing it manually scanning
previous bookings) and names etc, and would like to use the date fields in
this table as the date requirement
Thank you in advance.

 

[Peter Hibbs]

Perhaps this demo will give you some ideas (although you will need to
be fairly proficient at writing VBA code) :-

http://www.rogersaccesslibrary.com/...?TID=513&SID=77765db84f7926zab8feccfa54b916ac

HTH

Peter Hibbs.

 

[JoyKong.]

then good luck~

Hi, Im fairly new to Access but ok with ASP. I need to build an Access
database to provide a booking system for 5 apartments such that for any
given
apartment there can not be any clashes or overlaps on dates between
clients.
Also to sort by dates to find availabiliiy.
At the moment I have a table for recording bookings with clients date
requirements (no apartment allocations except by doing it manually
scanning
previous bookings) and names etc, and would like to use the date fields in
this table as the date requirement
Thank you in advance.

__________ Information from ESET Smart Security, version of virus
signature database 4559 (20091030) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4559 (20091030) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Mark Andrews]

Since my scheduling software is not finished yet, here's a good one:
http://www.abs-usa.com/solutions/appointment_scheduling_software/clam/default.aspx

The third party calender control in this software is going to be better than
any Access system you find (without any third party control). Also they
probably have some of the searching features you want.

Otherwise you are headed down a road to get into Access and VBA a good deal.

There are lots of desktop and web based systems as well (varing degrees of
user friendlyness and functionality).

Just think of your apartments as resources (just like you might be
scheduling doctors appointments for 5 doctors).

HTH,
Mark Andrews
RPT Software
http://www.rptsoftware.com