Recent content by Flint

I am trying to run this report that takes up about 15 pages (from 15 records), but for some reason it only shows the first 10. Is there an option to get rid of this 10 page limit?

To set the criteria to show dates on the first day of the previous month: DateSerial(Year(Date()), Month(Date())-1,1) To set the criteria to show dates on the last day of the previous month: DateSerial(Year(Date()), Month(Date()),0) But what criteria do you enter into a query to show the...

Validation rule - data must 'not' be between two dates I have a data entry form based on a table where you can book in dates for jobs. One of the fields is called 'JobDate' and another 'StaffID' (which is related to tblStaff) I have another table called tblStaff which has fields StaffID...

Thanks for that link I have now solved my problem

What criteria do you need to enter to make a query that shows all records for 'this week'? I have a field called 'JobDate' and want to make a query which shows all the dates this week E.g. If you run the query today (Wed 24th March) the query will show all the records with dates between 22nd...

Thanks for that link, the site has given me a way to check for double bookings, I've now solved my problem although not in the way I originally intended to

I have entered the code in my form in the properties on the "Code Builder" next to "Before Insert" Private Sub Form_BeforeUpdate(Cancel As Integer) If DCount("[JobID]", _ "frmJobBookings", _ "[JobDate] = #" & Me.JobDate & "# And " & _ "[CustomerID] = " &...

Also why does it say: "Compile Error Expected: Expression" When I try to enter the code in Visual Basic?

I have gone onto form properties, event, BeforeInsert and put in that code. In visual basic it appeared in Red, and doesn't appear to be working. Any ideas why ?

I am setting up a bookings system, within this I would like a feature to book dates and times for jobs. This is proving difficult. I need to set up a validation rule to stop double bookings, has anyone got an idea of how I can do this? The bookings table contains the following fields...