problem printing 10% of records

  • Thread starter Thread starter Theresa via AccessMonster.com
  • Start date Start date
T

Theresa via AccessMonster.com

Hello,
I'm using Access 2002. I'm trying to write a report to print every
tenth record so we can audit the data entry (we have 15,000 records to
enter, so we can't double check them all). One record is saved into 4
different tables. My query works fine. It returns every record in a
certain logbook. I tried using the code I found on the Access web
(http://www.mvps.org/access/queries/qry0006.htm), but it doesn't work. I
followed the directions, but I get an error that PlusOne is an unknown
function. I saved it in it's own module (not attached to a specific form
or report). What am I doing wrong?
I have log books piling up that need to be audited. Help!

Theresa
 
You can add a text box to the detail section of the report
Name: txtRunSum
Control Source: =1
Running Sum: Over All

Then add code to the On Format event of the detail section:
Cancel = Me.txtRunSum Mod 10 <> 0
 
What did you name the module? I'm guessing you called it PlusOne, and you
can't name the module the same as any function or sub.
 
Douglas,
Yes, that was the problem. I thought it had to be something simple.

Thanks!
Theresa
 
Back
Top