Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Posts
    2

    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 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 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.


    Brendan

  2. #2
    Join Date
    Jan 2003
    Location
    UK
    Posts
    5
    Assuming that the 'grab' is done by a query.

    Set your date field criteria in the query to Date() , instead of your inputbox statement.

    use the SendObject function (via macro or event procedure) to email the report.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •