Email button > using a filter

[Bmstenner]

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

 

[danvlas]

Base your report on a parameter query.
Point the query parameters to the form where you have the date and recipient displayed.
Check the SendObject method or action...
And that's all...

Good luck

Daniel Vlas
Systems Consultant
danvlas@yahoo.com

 

[Bmstenner]

Hi Daniel,

How would I go about doing this?

Thanks,


Brendan