Recent content by jasonfl1

How would I do this then?

In my form I have a sub/form which is based off a query just showing a few fields from the customers table. I can type a filter into my main form which affects the subform using the VBA code: Private Sub cmdFilter_Enter() Me.frmCustomerListing.Form.Filter = "tblCustomers.Firstname LIKE '*"...

Im not having much luck, how on earth do you do that? IIf(Date()<#Year(Date)-06-23#,0,1) :confused:

Well exactly that was the next problem. Any recommendations to make this fully automatic?

Doesn't seem to work, it could be because the date/time field doesnt actually have a format and they are all in uk format dd/mm/yyyy I tried this because its more what I need: Between DateAdd("YYYY",IIf(Date()<#23/06/2008#,0,1),#06/06/2007#) And...

Oh this is what I have currently: >=#06/06/2007# And <=#23/06/2008#

In my criteria for my query I need it to return results between 6th June 2007 and 23rd June 2008 (inclusive). The catch is that after 23rd June 2008, the criteria should return results between 6th June 2008 and 23rd June 2009! Is this possible or will I have to edit the criteria manually? The...