Print command button that will print report?

  • Thread starter Thread starter Scott
  • Start date Start date
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?
 
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?
|
|
|
 
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,

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?
| > |
| > |
| > |
| >
|
|
|
 
Scott & Eric

I was looking for the same button info as you. But I don't know enoug
about VB to get it right I guess. I went to the knowledgebase link an
followed the instructions but I keep getting an error message.

2497
The action or method requires a Report Name Argument.

What does that mean.

Thank
 
Scott & Eric

I was looking for the same button info as you. But I don't know enoug
about VB to get it right I guess. I went to the knowledgebase link an
followed the instructions but I keep getting an error message.

2497
The action or method requires a Report Name Argument.

What does that mean.

Thank
 
2497
The action or method requires a Report Name Argument.

It means that you need to specify the name of the report that you want
to open as the first argument to the OpenReport method: e.g.

DoCmd.OpenReport "rptMonthlySummary", <other arguments>

or

strDoc = "rptMonthlySummary"
....
DoCmd.OpenReport strDoc

In either case, you need to tell Access what report it is you want to
open; the error suggests that you're not doing so.
 
Back
Top