Recent content by MattBaldry

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