Search results

Thanks DBguy. The solution offered by MajP worked and was so simple. Just created a list box and based it on a query of that field showing just that part of the attachment field and it worked perfectly. ~Matt

Good shout. I shall give this a go. Update: Tried and this works fine. So simple. I feel dumb for not trying this first. Now, can I open the file from here now on a double click? ~Matt

Yes, this does work. But I wanted it just shown on the form itself.

Hi all, I have been looking but cannot find a work thread for what I am after. Nice and simple, be able to display the list of filenames in an attachment field on a form. I can get it to display the first attachment, but it won't show anything after that. Hoping that it is something simple...

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