Specify the number of records shown

  • Thread starter Thread starter Round up on .01
  • Start date Start date
R

Round up on .01

I am running a report and i want it to prompt me and ask how many records i
need shown.
 
One method is to add a column to your query like:
NumToPrint: [Enter number of records to print]

Add two text boxes in the detail section:
Name: NumToPrint
Control Source: NumToPrint

Name: txtCount
Control Source: =1
Running Sum: Over All

Then in the On Format event of the detail section, add code like:
Cancel = (Me.txtCount > Me.NumToPrint)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print every other record in a form 13
Sequential numbering records (skipping some records) 1
Sum for previous (x) number of records in detail 5
Counting specific records 2
counting records 0
Filter records 2
Report Not Showing All Records 3
want to add sum fields in different sections of a report 1

Back
Top