problem printing 10% of records

  • Thread starter Theresa via AccessMonster.com
  • 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
 
X

Xed

Try making the declaration of "PlusOne" Public, i.e.
Public Function PlusOne() as Integer

Xe
 
D

Duane Hookom

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
 
D

Douglas J. Steele

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

Theresa via AccessMonster.com

Douglas,
Yes, that was the problem. I thought it had to be something simple.

Thanks!
Theresa
 
Top