I am trying to send out an email with the listing of a report based on information on a form.
Is there anyway to dynamically filter the report for the send object?
This is what I have so far:
DoCmd.SendObject acSendReport, "wpr_assignment_report", acFormatRTF, strToWhom, , ...
Mor information on this problem
main form is wpr_tab
tab control is ctl0
form on page two of tab control is wpr_components
text field I am trying to filter on with the where clause is wpr_components_tab
Thanks for the quick answer, but I'm still having problems. I get the message box asking me to enter the parameter value forms!wpr_tab etc.
When I take this out of the tab control it works, but does not seem to work in the tab control. Do I have to refer to the page of the tab control somehow?
I am trying to run a query that uses a where clause that points to a field on a form that contains tabs. On one of these tabs I have a sub form. On the where clause of the query I am trying to point to the field on the tab, but it does not seem to recognize it. Any help would be greatly...
First question, we are using Access 2000 and some of our clients have windows xp. When they print reports with xp the report does not format correctly. This does not happen with nt or win 98. Is there a fix for this?
Also when I export a report into rtf format, the report has gaps between...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.