Will Access print data to a blank hard copy form?

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

Guest

I have blank printed forms that I want to print data from an Access report.
The positioning of the report data on the blank form is important. Each
record must print on a new page. Is this within the capabilities of Access,
and if so how do I get instructions to set it up?

Thanks in advance,
 
I'm not sure what you're asking.

Since Access uses the Windows printer driver(s), when Access prints, Windows
prints.

Can you do what you need to from Word (get the print to happen in the right
place)?

If so, you can adjust where Access starts printing to line up to your
pre-printed form as well.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
OK, let me try to explain a bit further... I have a four part NCR form which
has to be filled out with customer data when an appointment is scheduled with
the customer. The form has blanks which are traditionally completed by hand
and therefore the output from the report must place the customer data at the
appropriate position(s) on the blank form. My question is... can the output
of a report be be formatted to fill in the blanks on the form? Keep in mind I
will need a new form (new page) for each record to be printed from the
report.
--
Boomer642
Pride Runs Deep


Jeff Boyce said:
I'm not sure what you're asking.

Since Access uses the Windows printer driver(s), when Access prints, Windows
prints.

Can you do what you need to from Word (get the print to happen in the right
place)?

If so, you can adjust where Access starts printing to line up to your
pre-printed form as well.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
Click to expand...
 
Boomer642 said:
OK, let me try to explain a bit further... I have a four part NCR form which
has to be filled out with customer data when an appointment is scheduled with
the customer. The form has blanks which are traditionally completed by hand
and therefore the output from the report must place the customer data at the
appropriate position(s) on the blank form. My question is... can the output
of a report be be formatted to fill in the blanks on the form? Keep in mind I
will need a new form (new page) for each record to be printed from the
report.
Click to expand...

Sure.

But why not recreate the entire form as a report within Access?
Including all the boxes and text and such.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
yes it will but I have found (USAF) that it is easier to recreate the form
in the report and then you don't have page and formatting disasters that
take forever to get to comply to access.
Jeff Boyce said:
I'm not sure what you're asking.

Since Access uses the Windows printer driver(s), when Access prints,
Windows
prints.

Can you do what you need to from Word (get the print to happen in the
right
place)?

If so, you can adjust where Access starts printing to line up to your
pre-printed form as well.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
Click to expand...
 
Boomer642 said:
I have blank printed forms that I want to print data from an Access
report. The positioning of the report data on the blank form is
important. Each record must print on a new page. Is this within the
capabilities of Access, and if so how do I get instructions to set it
up?

Thanks in advance,
Click to expand...

In my experience it is easier to re-create the entire form. I have also
found that for complex forms that require precise placement of data, it may
be easier to print via a Microsoft Word form.
 
Boomer642 said:
OK, let me try to explain a bit further... I have a four part NCR
form which has to be filled out with customer data when an
appointment is scheduled with the customer. The form has blanks which
are traditionally completed by hand and therefore the output from the
report must place the customer data at the appropriate position(s) on
the blank form. My question is... can the output of a report be be
formatted to fill in the blanks on the form? Keep in mind I will need
a new form (new page) for each record to be printed from the report.
Click to expand...
<snip>

Boomer,
Others have answered the question adequately.
I just wanted to comment on the printing of NCR forms.Theese forms
require a heavy-duty impact printer, laser and inkjet printers will only
affect the top page.
As I recall, early dot-matrix printers weren't able to print more than
two readable copies, try before buying!

Harvey Thompson
 
Harvey Thompson said:
<snip>

Boomer,
Others have answered the question adequately.
I just wanted to comment on the printing of NCR forms.Theese forms
require a heavy-duty impact printer, laser and inkjet printers will only
affect the top page.
As I recall, early dot-matrix printers weren't able to print more than
two readable copies, try before buying!
Click to expand...

Good point. I made the assumption that he was trying to replace the
NCR paper, which is expensive to produce, with four laser printed
copies of the form.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Back
Top