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 whoever@email.com.
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 the days date, generate the report and email it to the specified recipient?
Any help would be appreciated, thanks for your time.
Brendan
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 whoever@email.com.
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 the days date, generate the report and email it to the specified recipient?
Any help would be appreciated, thanks for your time.
Brendan