Search results

Sorted! I deleted the Table where it places backup details and then remade it.

I have done that and still no change. But the Macro is to run a VB Module which automatically backs up my database. I know the code works as I can run the Macro manually

Hi, I have made a macro and entitled it "Autoexec" under the belief that it would run when I open the database. But it doesnt work automatically. Any ideas as to why? Thanks

Would I write that in the "Field" Row in Query Design View or somewhere else?

What you could do is: Create -> Form Wizard -> Then proceed through the wizard adding the fields from a particular table...

If DCount("*", "Booking_Tbl", "Driver ID" & Me.Driver ID & " AND Time of Meeting = #" & Me.Time Of Meeting & "#") > 0 Then MsgBox "Cannot book, booking already exists", vbCritical Exit Sub End If Perhaps I have manipulated that code wrongly...

Sorry, me again! I have tried to re work that code above but I get this error message. "The expression you entered contains invalid syntax. You may have entered an operand without an operator." Access then proceeds to highlighting "DCount"

Thank you for this! I will try that later on today. Incidentally my table is Booking_Tbl and the field names are "Booking ID" - AutoNumber, "Driver ID" - Number (Related to Driver ID in Drivers table, "Instructor ID" - Number (Related to Instructor ID in Instructors Table), "Meeting ID" - Number...

Would setting the Driver ID as Unique mean that I wont be able to add another booking, on a different meeting for a driver? But thanks for your response, Mihail, I will give it a go!

I am making a Database for a Driving School and I have a table that stores all of the bookings (Booking ID (PK), Driver ID, Instructor ID, Time of Meeting) and I have then made a Form that enables my client to easily enter the data. Would I be able to set up a query, an If Statement, a lookup...