Re: non-identical report copies

you might try moving the label control, (and the page numbers control) to
the Page Footer section of the report, then run your code in the
PageFooterSection_Format event procedure.

hth


"atlantis43 via AccessMonster.com" <u24690@uwe> wrote in message
news:64057ff87388f@xxxxxx
Allen; thanks for response. I've noted similar 'solution' descriptions
for
this problem in monster, but I'm not sure that they are not more
complicated
than simple for my problem. Though I might try & see, I'm hesitant
because:
1)my reports (invoices) are obligatorily in many different formats (for
medical insurance billing), and the recordsources are variable-order
subqueries constructed on the fly. Adding another level of decision
construction seem like it might further complicate the logic.
2)While some forms REQUIRE several non-identical copies (2 or 3), others
only
need them in certain circumstances, further confusing the programmer.

">If you initialize the variable in Report_Open, it will increment with
each
time you go through the report. So if you open it in preview, and then
print, it will have the wrong value."

Is there any way to compensate for this in code, so that I don't have to
change the logical construction of what worked so well in Ac2?
Thanks, richard



Allen Browne wrote:
If you initialize the variable in Report_Open, it will increment with
each
time you go through the report. So if you open it in preview, and then
print, it will have the wrong value.

Here's a solution that requires no code, and can't go wrong.

A simple workaround it to create a table containing the names you want on
your report. A table with just 2 fields:
PrintTextID Number
PrintText Text
Enter 2 records:
1 Original
2 Copy

Create a query for the report, and add this table as well as your
original
table. (If you already have a query, just add the new one to it.) It is
important that there is no line joining the 2 tables in query design
view.
Save the query.

Now open the report in design view.
Make sure its RecordSource is the query you just saved.
In the Sorting'n'Grouping box (View menu), insert a row at the top
Put the PrintTextID field in that row of the dialog.
In the lower pane, choose Yes beside Group Header.
In the new group header, add a text box for PrintText.

The query now feeds 2 copies of the record to the report, and the header
now
prints Original or Copy on the 2 copies.

If you do want to print just the original or just the copies, you can add
criteria to the query, or use the WhereCondition of OpenReport.

Hi; Wondering if anyone can solve this problem, which worked fine in
Ac2
and
[quoted text clipped - 39 lines]
Any suggestions for correction are needed.
Richard

--
Message posted via http://www.accessmonster.com



.

Relevant Pages

  • Re: Populating a list -- table structure?
    ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
    (microsoft.public.access.forms)
  • Re: Fields in Label dont give correct information
    ... You need to create a query based on tblRegEvent and tblRegPayment. ... -If your DCountis to count values in your report, ... half the time with very few errors (other than that label problem I had.) ... For example in the Room assignment on the report an idividual will be ...
    (microsoft.public.access.reports)
  • Re: Tips on domain aggregate replacements
    ... This already is a split db, but the users are 400 miles away from the server hosting the data:) They are all running the same copy of the FE locally on a single terminal server via TS/RDP sessions. ... It doesn't seem to have much impact on performance; the report takes just about as long to run if they are all logged in as it does when I am logged on testing it at night. ... I would do DSums from the controls on the report on the data returned by the query. ... The biggest offender is a certain report that needs to Sum a particular complex total for each of the next twelve months (the DSum in VBA was a sideline to this issue) and present these as items on each line of output. ...
    (microsoft.public.access.modulesdaovba)
  • Re: using a form with combo box to input criteria
    ... Candia Computer Consulting - Candia NH ... When you removed the criteria, ... Then your criteria in the query would be... ... query behind your main report. ...
    (microsoft.public.access.forms)
  • Re: using a form with combo box to input criteria
    ... Candia Computer Consulting - Candia NH ... When you removed the criteria, ... Then your criteria in the query would be... ... query behind your main report. ...
    (microsoft.public.access.forms)