Search results

abcdefghijkl

To TJPoorman Hi there, I entered the codes exactly the way you posted them and placed them in the correct locations as instructed. Furthermore the bits that you highlighted in red were already matched to my database so apart from double-checking, I didn't do anything to them. However now...

After trying the following code: Public Function CheckDoubleBook(lngRoomID As Long, lngCustomerID As Long, datBookingStartDate As Date, datBookingEndDate As Date) As Boolean 'This function will return True if the room is double booked Dim rs As Recordset Set rs =...

Okay, so I've put the code in a general module and I'm trying to call it from the command button using the above code however I keep getting the error: Expected =

Attached is a zip file containing an image of the relationship. My current client requires that the current tables and table structures remain the same/as similar as possible to the existing format. However he also wants to prevent double bookings automatically without changing essential...

Why not trying providing a central location for the values and then referencing the combo boxes to that location?

Combo box values from another combo box? Hmm. I'm pretty sure there would be a more efficient method of getting the values.

That's the thing. Its compulsory for me to remain with the current tables and table structures - I need to be able to prevent double bookings with the current tables.

Bare with me guys. So I've made two separate copies of the database in order to prevent too many errors/changes. I've used both your provided codes - TJPoorman's code in one copy and Stopher's in the other copy. I've put each code as the event procedure for a blank command button however every...

Hi there, thanks for your response. I was however hoping if anyone was able to provide me with a custom code that I can simply pop into my database since I have received similar and extensive help from people here on Access World Forums in the past. It's just that I'm a real novice! I looked at...

Hello everyone, I'm having some significant difficulties with a simplistic database I have designed for a hotel scenario. I want my database to automatically prevent double bookings from occurring (and also inform the user that the double booking has been prevented) and due to my lack of...

What do the following things mean: If Not rst.EOF Then 'there is a clash Me.Undo Else ' there is not a clash End If Set rst = Nothing

What do these mean: rst! rst

Hello and thanks for responding. The Viewings table now that I think of it is technically the Bookings table. www(dot)i62[/url] (dot) tinypic (dot) com/27wwpe1 (dot) jpg The above are my Relationships for the database. Sorry to say, I'm a bit confused. When I added the fields in my Viewing...

Hello everyone - new user here and a complete Database/Access novice. I have some rather troubling issues with my work and I was hoping this wonderful community could resolve these issues. I have a Database with four tables (Property, Buyer, Viewings and Agents), two forms (Search Screen and...