Recent content by MattBaldry

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