Faxing form report from access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

debraj007 - 19 Jan 2006 23:19 GMT

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

Reply to this Message

David Lloyd - 24 Jan 2006 22:15 GMT

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.

Signature

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

Reply to this Message