Search results

Hi all, Had a look at the attached and it is great. But I was wondering if anyone could point me in the direction of adding half days to the calendar? I think I can edit it to everything else I would like it to do, but half days I cannot figure out. ~Matt

I tried this approach but it didn't work. Loading the form with the filter wasn't the main issue, it was creating a reset. But I now have a working solution :) ~Matt

Thank you, this worked. I had to edit it for the reset button as below, but it works. Me.Form.Filter = "Format([AppointmentDate], 'wwyy') = Format(Date(), 'wwyy')" ~Matt

I just filtered the form and then saved it. It then added it to the filter field in the form properties. ~Matt

I wouldn't either, this is just the filter that access generated when I filtered it using my command buttons. But pasting this into VBA to load/reset doesn't work. ~Matt

I am trying to filter by the current week as default, adding the ""ww"" does not work though, I have tried this and get the "Expected list separator" error. ~Matt

I wouldn't either, that is the filter the Access generated for me, but it doesn't work Yes, I want the continuous form to display the current week every time it is opened, or if the reset button is clicked default back to this. ~Matt

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...