Search results

Hi all, I am trying to apply a form filter on a continuous form on a reset button. When I save the form filter, it gives me the below. (Year(tblAppointmentList.AppointmentDate)=Year(Date()) And DatePart("ww",tblAppointmentList.AppointmentDate,0)=DatePart("ww",Date(),0)) But when I apply this...

The issue is they may have logged onto different worksorders at the same time, so I need to use the earliest start time and latest end time within the same time period. The 4 below are all different orders worked on at the same time. 31/10/2024Employee One07:19:5010:51:5203:32:02...

I was lazy and used Excel and didn't check the workings out. You are correct, I will do them properly :)

This would be useful, but I have no idea were I would start on this. ~Matt

Those 10 seconds are not logged because they logged off a job at 10:52:03 and then logged onto a new job at 10:52:13. I know on this example it is only 10 seconds, but other people have greater time between a log off and log on. If we take the below example of a different employee, you will see...

Hi all, I have the below table and I want to work out how many hours worked in a day based on the earliest start time and latest end time a person has logged on. In the data below we can see that Employee One logged on to 4 jobs around the same time, starting at 07:19:50 and ending these at...

No, I have given up on this at the moment. Sadly other things have become more important, so this is on the back burner for a while.

I simply use the below. Private Sub Form_Activate() Me.Move 10, 10 End Sub This works fine for me. And I have different locations for other forms. ~Matt

Hi Larry, No, this would only be needed to work out when an activity should end based on how many minutes it should take, and when it should start. It is just a start and end formula needed. ~Matt

Thanks Doc, You have explained it very well and you are right. I need to find a way of taking the start date and then adding all minutes needed for the activity, including any breaks, out of hours times, public holidays and such. For now, if I can get a way of just taking the start time and...

That does make sense. I feel your pain of people and entering of data. I have had to write more code than I would care to make simple entry foolproof. And I still get amazed some days on what people have done.

Hi Larry, Thank you for the db. I have had a quick look and wonder why you have separate fields for the date and time? If you have these in a single field, you can just use the DateDiff to get the answer your formula shows. DateDiff: DateDiff("n",[ActivityStartDate],[ActivityEndDate])/60 This...

Hi plog, At the moment I am as basic as below for the employee side. EmployeeID, EmployeeName WorkingHoursID, EmployeeID, MondayStart, MondayEnd (and remaining weekdays) TeaBreakID, EmployeeID, MondayTeaStart, MondayTeaEnd (and remaining weekdays) LunchBreakID, EmployeeID, MondayLunchStart...

Apologies, I got over excited. The tea break should have been 10 minutes.

Skiving time 😆 they have more of that than anything.... ~Matt

Hi plog, I have tried this, but I need to add the time only during the working hours. If I add 600 minutes to 07:30 I would get 17:30, not 09:40 the next day when you take out the breaks and out of working hours.... ~Matt

Hi all, I am trying to get my head around the possibility of something, and hoping someone somewhere may already have this in the dust and cobwebs. I want to be able to work out the end date/time of an activity based on start date/time, worked out based on working hours. Example we have John...

Why not have the data entry part on a different form? Click add new data button and open a popup form to enter the new data, leaving the continuous form exactly where you have it. Once you close the data entry popup, the data would be at the bottom as normal, but your continuous form would...

If you do this, can I please have a copy when you are finished, purely for research purposes. And that would not be my name appearing on your statements....

Hi all, Has anyone ever been asked if it is possible to have a way of shutting all open databases down after a period of inactivity? ~Matt