Room booking system

[davea300]

Is there still a hotel/room booking system sample database available on the forum?

I remember seeing one a while back in the samples forum but can't find the thread now.

If it's not here anymore does anyone know of any samples I can look at?

 

[Uncle Gizmo]

I have this very old sample database:

'=================================
' ROOM RESERVATION DEMO
'
' (c) 1998 by Robert Hairgrove
' (TRS/Sysop, MSAccess Forum)
'
' Freeware. Please give credit
' where credit's due.
'=================================

Which I kept a copy of because it's very interesting, and I don't really understand how it works, not because I can't, because I haven't got the time to study it at the moment.

Please see attached.

 

[Jason2nl]

I unzipped the roomres2000.zip
And I try to run the roomres2000.mdb in Access 2007.
But I got an error: connection to utility.mda is broken, or something like that.

This could be a very usefull piece of software for me.
Does anyone has a solution or knows code for MS Access who does the same ?

 

[Uncle Gizmo]

I have posted a video showing how to remove a broken reference HERE:

 

[yanie]

Hi Uncle Gizmo

Using the given database, I have done some booking (dummy) and have identified a number of problems that occur in the database.
1. example room 102 have been booked by administrator on July 15 until July 22, i try to book into the same room (102) on July 16 until July 18. (date between) previous booking. Booking are allowed .. no error message.
2.Duplicate message only occurs when a new booking date exactly same with start & end date on previous booking
So..can u give me the best solution if i dont want to make a double boooking on the same room.

Tq

 

[Uncle Gizmo]

Your options are to track down the original developer Robert Hairgrove his details appear in my first post in this thread.

Failing that you need to investigate the code yourself and see if you can work out what needs to be done. If you run into problems then I suggest you start a new thread within the MS Access world forums and ask for some assistance.