Re: How to show / print a system variable in a report

Wow, What a speedy response. Thank you very much. It gives me a better
approach.

The question is no longer relevant to my immediate problem but . . . .

Is there a way of printing the variable on the report?


--
Thank You again

Charles


"Allen Browne" wrote:

The technique described in that article is flawed.

It relies on repeating some report events, but if you print just some pages
of the report (e.g. starting at page 5), the events for the intervening
pages may not fire, and so you get incorrect results.

For a more reliable approach, see:
Printing a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html
The article explains how to generate the right number of records for the
labels (using a Cartesian Product query), and also explains how to add the
"Label x of y" to each label.

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

"Charles" <Charles@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EF6C0E1B-9758-4D69-B344-9E72D6435299@xxxxxxxxxxxxxxxx
I am using the rather technique shown in:

The Knowledge Base Article ID : 95806
How to Skip Used Mailing Labels and Print Duplicates

Which works a treat.

What I would like to do, on each "label", is to have a control that shows
something like:

Label No X of XX

The normal "Runing Sum" method seems not to respond in the way I want.

There are a number of variables in the code, which is reproduced below:

Function LabelInitialize ()
BlankCount& = 0
CopyCount& = 0
End Function

'==================================================
' The following function is the main part of this code
' that allows the labels to print as the user desires.
'==================================================

Function LabelLayout (R As Report)
If BlankCount& < LabelBlanks& Then
R.NextRecord = False
R.PrintSection = False
BlankCount& = BlankCount& + 1
Else
If CopyCount& < (LabelCopies& - 1) Then
R.NextRecord = False
CopyCount& = CopyCount& + 1
Else
CopyCount& = 0
End If
End If
End Function

'==================================================

It seems to me that somewhere / somehow, I should be able to use "
CopyCount
".

--
Thank You in advance



.

Relevant Pages

  • Re: Determine copy number within Report
    ... Add a page break after each page and repeat the invoice as many times as ... In other words, if it is a 3 page invoice, make a 3 page report. ... Use something similar to printing multiple copies of the same label to ...
    (microsoft.public.access.reports)
  • Re: print of report is different than preview
    ... The knoweldgebase article you referred to works for a single-page report. ... However, it does not work if you are printing reports that spill over onto several pages, unless you actually print all the pages. ... Print a Quantity of a Label ... the first label and not as the preview showed. ...
    (microsoft.public.access.reports)
  • Re: Fields in Label dont give correct information
    ... tables where the data was stored in the query the query would not run. ... half the time with very few errors (other than that label problem I had.) ... report all of the information shows up on the report the way I want it to. ... For example in the Room assignment on the report an idividual will be ...
    (microsoft.public.access.reports)
  • 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: Heres one for ya
    ... If lblTotals is an attached label, and the control it is attached to has its Visible property set to No, then the label won't show. ... Allen Browne - Microsoft MVP. ... If bolCntrOn = True Then ... as that particular report had 22 records. ...
    (microsoft.public.access.reports)
Loading