Unanswered: Integrating a filter button with a report
Here we go:
I have an access database, with several tables, forms etc, on the switchboard, there is a button, subordinate to this i have created a button that will email the data (as a generated report) that is entered into that form to firstname.lastname@example.org.
I also have another button which, when clicked will ask for a date and when a date is entered, it grabs that information from a table and generates a report, I can email this by clicking "file > send to email recipient".
How can I implement so when a button is clicked, it will use todays date, generate the report and email it to the specified recipient automatically, without asking any questions as it gets annoying.
Any help would be appreciated, thanks for your time.