Faxing form report from access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report in access that fills in report information from a query. This
report may go to 1 customer or may go to 20, and I've set up the report so it
will create a new page for each customer.

I would like some way to be able to enable the user to fax this report to
each customer individually. In other words, each page would go to a different
fax number. I have no idea of the coding to use to enable this or if it's
even possible. Can anyone help? In addition, using access, is there a way to
create a custom fax cover sheet for each page of the report? Thanks in
advance for any help you can provide.

Deb
 
Deb:

Below is a link to a KB article that does something similar to what you are
trying to do.

http://support.microsoft.com/kb/299016/en-us

Regarding the fax cover page, one alternative might be to create a subreport
inside your main report for the cover page. You can use the Link Child
Fields/Link Master Fields properties of the subreport (Data tab) to keep the
subreport in sync with the main report.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I have a report in access that fills in report information from a query.
This
report may go to 1 customer or may go to 20, and I've set up the report so
it
will create a new page for each customer.

I would like some way to be able to enable the user to fax this report to
each customer individually. In other words, each page would go to a
different
fax number. I have no idea of the coding to use to enable this or if it's
even possible. Can anyone help? In addition, using access, is there a way to
create a custom fax cover sheet for each page of the report? Thanks in
advance for any help you can provide.

Deb
 
Back
Top