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,
--
Boomer642
Pride Runs Deep

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
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

"Boomer642" <(E-Mail Removed)> wrote in message
news:7B731CE0-4E5D-4D8D-A6F4-(E-Mail Removed)...
> 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,
> --
> Boomer642
> Pride Runs Deep

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" wrote:

> 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
> http://mvp.support.microsoft.com/
>
> Microsoft IT Academy Program Mentor
> http://microsoftitacademy.com/
>
> "Boomer642" <(E-Mail Removed)> wrote in message
> news:7B731CE0-4E5D-4D8D-A6F4-(E-Mail Removed)...
> > 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,
> > --
> > Boomer642
> > Pride Runs Deep
>
>

Boomer642 <(E-Mail Removed)> wrote:

>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.

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" <(E-Mail Removed)-DISCARD_HYPHEN_TO_END> wrote in message
news:%(E-Mail Removed)...
> 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
> http://mvp.support.microsoft.com/
>
> Microsoft IT Academy Program Mentor
> http://microsoftitacademy.com/
>
> "Boomer642" <(E-Mail Removed)> wrote in message
> news:7B731CE0-4E5D-4D8D-A6F4-(E-Mail Removed)...
>> 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,
>> --
>> Boomer642
>> Pride Runs Deep
>

Boomer642 wrote:
> 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,

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.

--
Joseph Meehan

Dia 's Muire duit

Boomer642 wrote:
> 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.
>
<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" <h_e_thompson AT comcast.invalid.net> wrote:

>> 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.
>>
><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!

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/