Is there OpenArgs for Report?

[swingingming]

I want to print invoices. One Original and one copy, but I don't want
to keep 2 reports. I have 2 texboxes, How can I enable one in the first
copy and then enable (make visible) the second?
Thanks a lot.
ming

[Allen Browne]

So you want to print 2 copies of the invoice--one marked 'Original', and the
other 'Copy'?

1. Create a table with 2 fields:
CountID Number
CountName Text
Save it with the name tblCount.

2. Enter 2 records like this:
CountID CountName
1 Original
2 Copy

3. Create a query, containing this table and your original one. Make sure
there is no line joining the 2 tables in the upper pane of the query design
window, and drag all the fields you need into the output grid. Save the
query.

4. Open your report in design view. Set its RecordSource to the query. Open
the Sorting And Grouping dialog (View menu). On the first row dialog, choose
CountID, and in the lower pane of the dialog answer Yes for Group Header.

5. In the new group header section, add the CountName text box.

The report prints 2 copies of each record (because of the Cartesian product
query), with the appropriate heading on each one.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"swingingming" <mi******@gmail.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...

I want to print invoices. One Original and one copy, but I don't want
to keep 2 reports. I have 2 texboxes, How can I enable one in the first
copy and then enable (make visible) the second?
Thanks a lot.
ming

[Trevor Best]

swingingming wrote:

I want to print invoices. One Original and one copy, but I don't want
to keep 2 reports. I have 2 texboxes, How can I enable one in the first
copy and then enable (make visible) the second?
Thanks a lot.
ming

The way I would do it (assuming a title like "Customer Copy" or "Office
Copy") would be on the form that opens the report, have a textbox there
then...

Me!MyTextBox.Value="Customer Copy"
DoCmd.OpenReport "rptInvoice"
Me!MyTextBox.Value="Office Copy"
DoCmd.OpenReport "rptInvoice"

Then the report would have a title textbox bound to
"=forms!MyDataEntryForm!MyTextBox"

[Steve Jorgensen]

On 9 Aug 2005 00:05:12 -0700, "swingingming" <mi******@gmail.com> wrote:

I want to print invoices. One Original and one copy, but I don't want
to keep 2 reports. I have 2 texboxes, How can I enable one in the first
copy and then enable (make visible) the second?
Thanks a lot.
ming

In Access 2002 and 2003, there's an OpenArgs parameter for OpenReport. In
2000 and earlier, there is not.

[swingingming]

Innovative solutions! Thank you guys. I learned a lot here!

[David W. Fenton]

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in
news:42***********************@per-qv1-newsreader-01.iinet.net.au:

So you want to print 2 copies of the invoice--one marked
'Original', and the other 'Copy'?

1. Create a table with 2 fields:
CountID Number
CountName Text
Save it with the name tblCount.

2. Enter 2 records like this:
CountID CountName
1 Original
2 Copy

3. Create a query, containing this table and your original one.
Make sure there is no line joining the 2 tables in the upper pane
of the query design window, and drag all the fields you need into
the output grid. Save the query.

4. Open your report in design view. Set its RecordSource to the
query. Open the Sorting And Grouping dialog (View menu). On the
first row dialog, choose CountID, and in the lower pane of the
dialog answer Yes for Group Header.

5. In the new group header section, add the CountName text box.

The report prints 2 copies of each record (because of the
Cartesian product query), with the appropriate heading on each
one.

Clever. And if you wanted only one copy, you could add the condition
CountID=1, or to print *just* the copy, CountID=2.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

[swingingming]

Allen, I tried your method. And it works fine. Just that my second
report has a lot of sorting/grouping, so, it takes some time to get
them all correct. But it's a way of learning. Also, this reply is
better than the one on your webpage.
Thanks, ming