MattBaldry's latest activity
-
MattBaldry replied to the thread Holiday Booking Database.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... -
This works for me? DoCmd.OpenForm "frmtbldaily", , , "Format([DailyDate], 'wwyy') = Format(Date(), 'wwyy')"
-
MattBaldry replied to the thread Solved Form Filter in VBA.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...
-
MattBaldry replied to the thread Solved Form Filter in VBA.Thank you, this worked. I had to edit it for the reset button as below, but it works. Me.Form.Filter = "Format([AppointmentDate]...
-
MattBaldry replied to the thread Solved Form Filter in VBA.I just filtered the form and then saved it. It then added it to the filter field in the form properties. ~Matt
-
MattBaldry replied to the thread Solved Form Filter in VBA.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...
-
MattBaldry replied to the thread Solved Form Filter in VBA.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...
-
MattBaldry replied to the thread Solved Form Filter in VBA.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...
-
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...
