Re: Print Recordset - loop question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Ned Nefarius wrote:
> I need to print 1 report for each record in a recordset. That set is
> based on a query and the report on a different recordset - related by
> an ID.
>
> I can't seem to get the code working on my form (based on the query)
> to print the first record (ID) then move to the next, and so on, 'til
> it reaches the end.
>
> I can get it to print the first record - but the Link Criteria in the
> print routine sez "=Me.ID"...which is the current record on the form,
> I need to reference the next and so on...
>
> Me.RecordsetClone
> Do
> ...Print "Report"; Link = "Me.ID"...
> Loop Until Me.RecordsetClone.EOF
>
> Help, thanks in advance, N.

If that is not pseudocode above it is completely wrong.

Usually a report is simply designed and run. There should be no need for any
code to print a report for each record in a recordset.
The query that relates them is all that is needed.


.

Relevant Pages

  • RE: Transpose data in a report-Field values broken down to separat
    ... GiftDate info for the first record in the row. ... gift records. ... Then create a main report based on only the unique values of ID and Name. ... a query, along with my response, that explains the need further: ...
    (microsoft.public.access.reports)
  • 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)