Recent content by Mark Smith

Sorted! (well, it works at least!) SJ, Peter, Thanks for all your help. I have put together something that works. I'll paste the code below so you can have a look at it. I ended up ditching the parameters and replaced them with functions. The functions return date values that are set when the...

Peter, SJ, Thanks for your help! I like the advice on declaring parameters, much more readable! I will look into the form being opened as dialog tomorrow. I'll post a reply and let you know how its gone! Mark (Frozbie)

Peter, SJ, I was sure about the lines until you questioned them... In the queries I am using, I capture the start and end dates of the periods I want to look at from the main form frm_Hours_Worked the SQL for qry_Hours_Worked_Update is below: SELECT tbl_Hours_Worked.EmpHoursID...

Thanks again for taking the time to look at this. I have moved the DAO reference into fourth place and tried running the routine again. I still get the same Data type mismatch in criteria expression and the debugger is looking at the same line: Set rs = qdf.OpenRecordset() I closed the...

Hi SJ, Thanks for your reply. I did have a reference to DAO added. I've attached a picture of all references currently set in the VBE. Would it be helpful to upload the database? It is quite large now, even as a zip file (380kb) Mark, Frozbie (I made the mistake of changing my email address...