I'm working on an Access 2016 database for logging pass/fail conditions in my factory. I have everything I need if I want to run everything manually, now I want to automate my database.
I've got a report that pulls data from a query. When I run the report, the query's criteria prompt is triggered, asking for the date in mm/dd/yyyy format. Manually entering in the info works fine, but how can I create a macro that automatically puts a value into the prompt for me?
I've tried using the Macro design tool to "OpenReport" with the following Where Condition line:
Where Condition =
[DailyReport Query]![LogDate] = Date()
Date() in the query criteria field under Log Date instead of putting it in the macro.