Recent content by Tom Knight

Thanks mate.. i think that's solved a problem that quite a few people have posted about on here.

Can anyone help me finish off a rather annoying problem that i've been working on? I've got a continuous subform which only usually has a few records in but can potentially contain loads (therefore requiring the scroll bar to rear it's ugly head!!) I tried out a few ideas to make it...

Ignore that post.... Access newbie at work!!!

Yesterday i posted about a query effectively ignoring a criteria from a form if the field on the form is left blank. Someone suggested putting Is Null on the second line and that worked for one individual field but I have 6 fields that have criteria in the query. 3 are text fields so i don't...

Thanks mate, that works. Appreciate the help. I can't believe i've been trying combinations for hours and it's really that simple... Oh well always the way i suppose!

Hi, I'm using a form to generate criteria for a query column that contains a date, the problem is that i only want a criteria generated if a field contains a value. If the field is empty I want the query to show all records I've entered the following... CRITERIA...