Search results

Thanks for helping, but I still really don't know what to do :( Do I need to search for the overlaps in a query, and then use DCount to count the records in the query? Or can I do it all with VBA? I'm sorry, I'm really basic with Access :(

I know there are a lot of previous threads about double booking, but I'm really not sure how to carry this one out. Currently, my database is a B&B. In the B&B, there are 3 types of each room (3 Standard, 3 Double and 3 Deluxe). I want to have a check availability button, so I can check if the...

Hello! I found the solution. The error messages were the wrong way round.:o:o:o:o The final code is: Private Sub Command138_Click() If DCount("*", "QRYDuplicates", "[Time_of_Session]='" & Me.Time_of_Session & "' And [Date_of_appointment]=#" & Me.Date_of_Appointment & "#") > 0 Then MsgBox "This...

If there's no practical solution, please tell me, so I don't have to worry about fixing it!

Okay, I tried this. But now it sems to accept every single booking, even when I know there are duplicate values. So the coding isn't working, but thank you.:( Is there any way I other way I could do it? Could I run a query to check for duplicates, or is that just too complicated? By the way...

I tried putting square brackets in, and then underscores, and then both. No luck unfortunately, it's the same error :(

Hello! I need a bit of help, I'm making a database based on a beautician's spa. Basically, I want to use VBA (or queries, if necessary) to check that an appointment isn't already confirmed for a particular appointment. At the minute, I have a query which contains: Date of appointment (Format...

Hi. My ICT coursework requires this database to be normalised to 3NF, and I was wondering if you could check if it works? To me it makes sense, but I don't think that's a great way to confirm it!:p In short: *One customer can have many credit cards attributed to them. *One customer can create...

Firstly, I'd like to say this is my ICT coursework, and I'm unfortunately pretty inexperienced with Access. I can use VBA to an extent, but I really need help! I've created a database based on a beautician's spa. Basically, I think there may be a problem with the relationships in the database...