Results 1 to 10 of 10

Numbered lines

  1. #1
    UT227 is offline Competent Performer
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    461

    Numbered lines

    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?

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    14,333

  3. #3
    UT227 is offline Competent Performer
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    461
    For each line printed, I need a number (1, 2, 3....) There are 30 rows, I need all them numbered (1 - 30)

  4. #4
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    6,436
    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'.
    - "doesn't work" is no help. Post err msgs and where.
    - Use code tags for code/sql. Implement changes in copies of your database.

  5. #5
    UT227 is offline Competent Performer
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    461
    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.

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,360
    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.

  7. #7
    UT227 is offline Competent Performer
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    461
    I'm using this database as a guide. Actually, I stole the whole thing. This is how I'm generating blank lines.Lines.accdb

  8. #8
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,360
    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.

  9. #9
    UT227 is offline Competent Performer
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    461
    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.

  10. #10
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,360
    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.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Loop through numbered variables
    By Ruegen in forum Programming
    Replies: 3
    Last Post: 06-06-2015, 04:21 AM
  2. Sequentially Numbered Column
    By DMullane in forum Access
    Replies: 1
    Last Post: 12-09-2014, 01:50 PM
  3. Replies: 4
    Last Post: 11-10-2011, 03:26 PM
  4. Replies: 4
    Last Post: 08-31-2011, 12:36 PM
  5. A column numbered: 1,2,3,4,5...
    By eezing in forum Queries
    Replies: 1
    Last Post: 08-18-2009, 09:44 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums