Search results

Thanks - I tried it but no change...this is the updated version. Dim outputSNP As String outputSNP = "j:\umps\this week\" & "Clock Hours for-" & Format(DateAdd("d", -1, Date), "yyyymmdd") & ".snp" DoCmd.OutputTo acReport, "DailyClockReport -All Employees", acFormatSNP, outputSNP, False THanks

I have used the code below to run a report to our server. I need to change the file name each time to be date specific. When I run the code I get run time error 3011 - Microsoft Jet Database Engine could not find object". When I get that solved - the query that the report runs from requires a...