Help Required

[DeanH]

I was wondering if any of you could help me,

I have created a database an need a validation method. Here is the scenario, I have 3 fields

Room Number // Date of Departure // Room in Use

Here is what i want to happen, when the database is opened i need to check the current date and compare it with the date entered in the date of departure field. If the current date is equal to or greater than the date in the date of departure field i need to untick the room in use box (obviously the guests have left) and clear the date of departure field so that data can be entered again. This will need to happen for all room numbers.

Any Help would be great as i am at a total loss

Dean

 

[Rich]

Since you can compare the departure date with todays, you can already determine the status of the room without the need for a check box as well

 

[DeanH]

Ok, Thank you. The hard part is now comparing the current date with the date in the date of departure field and then clearing the date of departure field if it is equal to or more than the current date. This i assume would be done by using a macro but i cant find the correct code.

 

[directormac]

Create an update query (check Access help and this thread) to perform the updating of the table. Then decide WHEN this update will be run (at program start, on a timer, at form open, whatever) and call the query at the appropriate time.

Shout out if you need more details.

--Terse Mac

 

[Rich]

Do you have a One to Many table set up between Room and bookings?