Re: Using WHERE when using SendObject to Email in Outlook

Thanks MGFoster,

It's been awhile since I dabbled in VBA. I get your point, and see how
it would work your way. I've never needed to directly email from
Access.

But here's an issue: there is 1 report selection form from which many
reports can be made. A user may want to view, print, and email many
types of reports at once from the report picker form. Therefore, I'd
like it if everything was controlled from the already made report
picker.

Thinking out loud now...once a user selects the criteria in the report
picker, and then clicks the button to email that type of report, is
there a way to store the criteria, open the report to be emailed,
change the report's criteria, close the report, insert the report in
Outlook...

The above may create a major overhaul. Just curious.

Thanks

.

Relevant Pages

  • Re: using a form with combo box to input criteria
    ... Candia Computer Consulting - Candia NH ... When you removed the criteria, ... Then your criteria in the query would be... ... query behind your main report. ...
    (microsoft.public.access.forms)
  • Re: using a form with combo box to input criteria
    ... Candia Computer Consulting - Candia NH ... When you removed the criteria, ... Then your criteria in the query would be... ... query behind your main report. ...
    (microsoft.public.access.forms)
  • Re: using a form with combo box to input criteria
    ... When you removed the criteria, ... Then your criteria in the query would be... ... query behind your main report. ...
    (microsoft.public.access.forms)
  • Re: Running 2 reports in a form together
    ... Form where the report is run from is called "clientanddate" ... Dim strReport As String 'Name of report to open. ... here is an example that tests criteria and builds a filter string to use as a parameter in OpenReport ...
    (microsoft.public.access.forms)
  • Re: Running 2 reports in a form together
    ... Form where the report is run from is called "clientanddate" ... Dim strReport As String 'Name of report to open. ... What I need it to do is also filter in the date report using the clients name ... here is an example that tests criteria and builds a filter string to use ...
    (microsoft.public.access.forms)