I'm creating a sign in roster. I have everyone in the class on the roster. I need each name numbered all the way down the page. Is there a way to do that?
I'm creating a sign in roster. I have everyone in the class on the roster. I need each name numbered all the way down the page. Is there a way to do that?
?? Numbered??
Check this http://allenbrowne.com/ranking.html
and/or
this one on various ways to do row numbering
Last edited by orange; 09-20-2019 at 05:34 PM.
For each line printed, I need a number (1, 2, 3....) There are 30 rows, I need all them numbered (1 - 30)
You are doing this in a report? Try adding a textbox, set its control source to =1 and set the running sum property to 'over all'.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
That almost worked. My work wants blank lines for the whole page. Right now, I have a roster with 6 people on it. I have the 6 lines filled out. The rest of the page is empty, however, the lines are there. When I did this, I got 1-6 (for the lines that were filled out. After that, "6" was repeated.
Are you using VBA to generate blank lines? Producing sequence number might require 'dummy' table approach.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I'm using this database as a guide. Actually, I stole the whole thing. This is how I'm generating blank lines.Lines.accdb
I am familiar with that method. Here is another that does not use counter textbox. https://www.vb123.com.au/200310_dl_pad.htm
However, I don't think either will be able to generate sequence number because they both rely on forcing last record to repeat therefore the running sum repeats.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
That was an interesting article. I'm not sure where that code is entered, in the detail format? If it's only generating blank lines, like what I'm doing now, I don't think it will add the numbers I need.
Code is behind report. Already stated it won't produce sequence numbers you want.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.