Print command button that will print report?

S

Scott

I need to print a command button that will print a report I created. This
report is formatted so that each record is one page of the report. how do I
print only the current record showing on my form to this report?
 
P

prabha

Hi Scott,

See: ACC2000: How to Print a Single Record from a Form in a Report
http://support.microsoft.com/default.aspx?scid=kb;en-us;209560

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."


--------------------
| From: "Scott" <[email protected]>
| Subject: Print command button that will print report?
| Date: Sun, 22 Feb 2004 14:36:05 -0600
| Lines: 5
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <OOyAAOY#[email protected]>
| Newsgroups: microsoft.public.access.forms
| NNTP-Posting-Host: pcp08660979pcs.500ash01.tn.comcast.net 69.137.64.227
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.forms:256429
| X-Tomcat-NG: microsoft.public.access.forms
|
| I need to print a command button that will print a report I created. This
| report is formatted so that each record is one page of the report. how do
I
| print only the current record showing on my form to this report?
|
|
|
 
S

Scott

Thanks Eric,
That was a good link for me.

Ok Great that works, but what if I all ready have other command buttons that
prints other reports for the same form? How do I incorporate another ?
 
P

prabha

Hi Scott,

I'm not sure I understand your question.

You can have multiple buttons on your Form that do various things (e.g.,
Button "A" prints out Report "1", Button "B" prints out Report "2" and "1",
Button "C" runs Macro "3", "4" and "5", etc..)

Eric

--------------------
| From: "Scott" <[email protected]>
| References: <OOyAAOY#[email protected]>
<$M475ha#[email protected]>
| Subject: Re: Print command button that will print report?
| Date: Sun, 22 Feb 2004 22:27:54 -0600
| Lines: 62
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
| Message-ID: <uaeymVc#[email protected]>
| Newsgroups: microsoft.public.access.forms
| NNTP-Posting-Host: pcp08660979pcs.500ash01.tn.comcast.net 69.137.64.227
| Path:
cpmsftngxa06.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTNGXA05.phx.gbl!TK2MSFTNGP08
..phx.gbl!tk2msftngp13.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.forms:256461
| X-Tomcat-NG: microsoft.public.access.forms
|
| Thanks Eric,
| That was a good link for me.
|
| Ok Great that works, but what if I all ready have other command buttons
that
| prints other reports for the same form? How do I incorporate another ?
|
| | > Hi Scott,
| >
| > See: ACC2000: How to Print a Single Record from a Form in a Report
| > http://support.microsoft.com/default.aspx?scid=kb;en-us;209560
| >
| > I hope this helps! If you have additional questions on this topic,
please
| > respond back to this posting.
| >
| >
| > Regards,
| >
| > Eric Butts
| > Microsoft Access Support
| >
| > "Microsoft Security Announcement: Have you installed the patch for
| > Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
| > you to review the information at the following link regarding Microsoft
| > Security Bulletin MS03-026
| > <http://www.microsoft.com/security/security_bulletins/ms03-026.asp>
and/or
| > to visit Windows Update at <http://windowsupdate.microsoft.com/> to
| install
| > the patch. Running the SCAN program from the Windows Update site will
| help
| > to insure you are current with all security patches, not just MS03-026."
| >
| >
| > --------------------
| > | From: "Scott" <[email protected]>
| > | Subject: Print command button that will print report?
| > | Date: Sun, 22 Feb 2004 14:36:05 -0600
| > | Lines: 5
| > | X-Priority: 3
| > | X-MSMail-Priority: Normal
| > | X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| > | Message-ID: <OOyAAOY#[email protected]>
| > | Newsgroups: microsoft.public.access.forms
| > | NNTP-Posting-Host: pcp08660979pcs.500ash01.tn.comcast.net
69.137.64.227
| > | Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
| > | Xref: cpmsftngxa06.phx.gbl microsoft.public.access.forms:256429
| > | X-Tomcat-NG: microsoft.public.access.forms
| > |
| > | I need to print a command button that will print a report I created.
| This
| > | report is formatted so that each record is one page of the report. how
| do
| > I
| > | print only the current record showing on my form to this report?
| > |
| > |
| > |
| >
|
|
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top