Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access thread: Before_Update()


Message #1 by "Stephen Carpenter" <stvc69@n...> on Wed, 24 Apr 2002 20:41:41
I've written a query that checks to see if a double booking has been made 
in my room bookings database.  Please help me to actually put this into 
my form before_update module (or macro).  I have the fundamentals of what 
I need, but cant use it. I have no idea how to do this.  Any help is 
gratefully received. Here is my calculated query field....

NoClash: Nz(([tblBooking_1].[Time Start]>=[tblBooking].[Time Finish]) Or 
([tblBooking_1].[Time Finish]<=[tblBooking].[Time Start]) Or 
([tblBooking_1].[Date]<>[tblBooking].[Date]) Or ([tblBooking].[Room]<>
[tblBooking_1].[Room]) Or ([tblBooking].[UniqueID]=[tblBooking_1].
[UniqueID]),False) - and the criteria is set to false.

  Return to Index