ACCESS forms with multiple...

[clfeld]

I am trying to use access to do a estimating program, i have the estimates
and all the pieceds i need working, what i dont have is a way to print the
estimate niceley for the customer, i would like to be able to pull the data
from a form that has multiple data sources, so i creeate an estimate with the
customer info and the items i am quoting, that works great now i need to have
a button that takes that info and plugs in a header and a footer in something
i can email or print, witht he info that was in the quote form.

 

[John W. Vinson]

I am trying to use access to do a estimating program, i have the estimates
and all the pieceds i need working, what i dont have is a way to print the
estimate niceley for the customer, i would like to be able to pull the data
from a form that has multiple data sources, so i creeate an estimate with the
customer info and the items i am quoting, that works great now i need to have
a button that takes that info and plugs in a header and a footer in something
i can email or print, witht he info that was in the quote form.

Create a Query containing the data that you want to print, and then create a
Report based on that query. Print that report.

Do note that a report prints data *stored in a table*, not in a form. Forms
are just windows, tools to put data into tables - not data repositories in
their own right.

 

[Danny J. Lesandrini]

You 're comment is kind of all over the place.

First, create a report, with headers and footers ... and a detail section.
Use this line to email it ...

DoCmd.SendObject ...

Follow the intellisense prompts to fill in where the ... is above.