Search results

Say a booking is made from 21/06/2005 - 22/06/2005 and you search for available dates 22/06/2005 then the room booked for the previous night shows as booked for the following night. Does anyone know how to go about fixing this problem? I hope my question makes sense?!! :eek:

Yeah, I was a little ahead of myself! Fixed it. :D

I have done that for all but the connection between tblpeople and tblproperties as aparently the data in tblProperties violates referential integrity rules! Not too sure why?!

Ok this may take some time... Thanks again for your help! I will post when I have managed to do it.

Thanks for explaining... I have spent far too much time working in excel, my mind had become clouded or is it shrounded!!? The example helped. I am never too sure when it is best to do it like that or put items as fields in a table. I have made the changes to mine... What next Monseigneur???

Thanks for the quick reply! Total cost: can you explain why it does not need to be in the table? I understand that it will be calculated in runtime, but does it not need to be stored for reports etc? Property feature: where do I draw the line as to what is a property feature? Should the...

I have attached a copy of the database I am trying to build for a small villa rental company. All I have done so far is the tables and relationships... Now though I am stuck. I want to be able to search availability and add other helpful features. I am able to do straighforwrd forms but am...

I have looked for a password crack but it seems you have to pay for them, when I am not even sure if that is the soloution. :mad:

It still asks for the password! Is there anything else I can try?! Thanks for your help guys.

Errr it appears that I did disable the shift button as it does not appear to make a difference!!! By your reaction that is a bad thing!!? Please don't tell me I have to start again. thx

I am a newbie to access and have recently been trying to develop a database for a small villa rental company. The problem being that I have spent ages trying to learn what the hell I am supposed to be doing and now have somehow password protected the whole thing. Everytime I log in I get a...