Search results

Access version: 2013 Hey all Didn't really know whether to put this one in Report forum or Query forum as it kinda applies to both but is regarding a query for the filter property of a report so put it here :) This is a fairly weird issue that has had me stumped most of the morning. I have an...

Private Sub CreateReport_Click() Dim Serv As String Dim Manu As String Dim Boil As String Dim Steam As String Dim Hot As String Serv = "[TypeOfWorkServicing] = '" & Me!Servicing & "'" Manu = "[TypeOfWorkManufacturing] = '" & Me!Manufacturing & "'" Boil = "[TypeOfWorkBoilers] = '" &...

Gday all, having issues storing dates as variables. The intent of this beforeUpdate() function is to check the 'latest update' field of the Product table and if the latest update of the product was over 2 weeks prior then undoChange. The problem is that this is only working for some of the...