Recent content by jon92

Thanks ghudson It works a treat

I have a button on a form - when the user has completed a certain task they click the button, this logs the time and date task name etc. The following code is attached to the onclick event: CODE Me.fldtasktype.Value = "Task description" Me.fldtaskCode.Value = "xxx" Me.fldUsername.Value =...

Thank-you for your help & advice I now see where I was going wrong. I have decided to view the results in a form using the following metbod: SQL 1 SELECT tblclocktimes.ShiftNum, tblclocktimes.fldtimeEmpID, tblemployee.fldEmpLname, tblclocktimes.fldtimeclockdate, tblclocktimes.fldtimeclockin...

Pat Sorry I'm confusing you. The query posted returns times in tblclocktimes.fldtimeclockin that are greater than 06:00 (I have 1 as the criteria for tblclocktimes.ShiftNum) Therfore if staff clockin on time or just before 06:00 the query won't return anything fine so far. But if someone...

Sorry for the delay replying. I have made the changes you suggested but I'm still getting the same results from the query. Re - populating the two time fields - I am doing this manually (I get a weekly printout from Human Resources for my derpartment) I have tried running the query with just...

Pat Sorry it's still not working. My tables structures are as follows: tblEmployees fldEmpID - text, PK fldEmpLastName - text fldEmpFirstName - text fldEmpPayroll - text tblDefaultShifts ShiftNum - number,Double, PK fldDefaultIn - date/time...

Pat Yes [ShiftNum] is numeric and the parameter is not surrounded by quotes. I think I will admit defeat and go back to the drawing board with my table(s) design I dont' think they are quite right - Thanks for your patience !

Pat Thanks once again, I seem to be getting the results I require now I have tried to add a shift parameter (Iv'e named them 1 2 + 3) if I put "1" as the criteria for tblmytable.ShiftNum it gives records for 1 2 + 3

Pat I have tried what you suggest using the following: SELECT FROM tbldefaultshifts INNER JOIN tblclocktimes ON tbldefaultshifts.ShiftNum = tblclocktimes.ShiftNum WHERE (((tblclocktimes.fldtimeclockin)>[tbldefaultshifts].[flddefaultin])) OR...

Thanks Pat I can't use the fancy method - The shifts are set 8hrs ie the 06:00-14:00 shift is relieved by the 14:00 - 22:00 shift. I have opted for Between>#06:00#And#07:00#[timclockedin] OR Between <#13:00#And#14:00#[timeclockedout] This seems to give the results I require. Now all I have...

I have a table which includes two fields - [timeclockedin] and [timeclockedout] What I would like to be able to do is - run a weekly check on these two fields and check if staff have clocked in late or clocked out early. Example an early shift works 06:00 - 14:00, so I was thinking along the...

Calvin I remember reading a post a few months ago about a similar problem (compile error) The answer was to create a new database and import everything to the new database, so I've tried this and what do you know - It works! Thanks very much for your help and patience! I am very grateful...

Calvin I'm still getting the runtime error. Could it have something to with the trim function & declaring it? I notice in your code that trim is not declared. If I do the same I get the following error: Compile error - can't find project or library sorry to be a pain

Calvin I think the problem is: I am testing on access 97 because my db at work is a97. I have tried your 2nd code example (in access 2000) and it seems to working - but the message "No file was found" is appearing - there is 1 file in the directory e:\temp2 Here is a copy of the function...

Calvin Just a question on your suggestion I have tried the example you have given and I am getting runtime error 13: type mismatch on this line of the code Do While trim(strPath) <> "" Could you assist please