Page 1 of 2 12 LastLast
Results 1 to 15 of 27
  1. #1
    UT227 is offline Expert
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    581

    Empty rows

    I made a sign in sheet. It populates with everyone scheduled to be in the class. I need for it to put empty cells till the end of the page. Possible?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    then you either:
    make a graphic grid, that holds no data, to fill the page for users to sign-in
    or
    use a table that has numbers 1-N, make the report hide the # part, but display unbound cells (with border lines)

  3. #3
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    if this is just to print a piece of paper for manual entry, you can use excel, word, publisher, whatever to generate the look you require

  4. #4
    UT227 is offline Expert
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    581
    I'm not sure how to make a graphic grid. I need it at the end of the names and up to the end of the page. This should look continuous.

  5. #5
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    You want to pad the page with blank lines following the names? Review http://www.tek-tips.com/viewthread.cfm?qid=1695691 and https://www.pcreview.co.uk/threads/a...eport.3962249/
    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.

  6. #6
    UT227 is offline Expert
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    581
    I was told that I cannot accomplish what I want with a continuous report. He said that I need to make a report with all the empty fields and use something called ADODB Recordset to populate the fields from my query. Can anyone help me with this? I'm still trying to figure out VBA.

  7. #7
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    By continuous I presume you mean multiple records as opposed to a single record output.

    A 'graphic grid' is just adding a bunch of line controls or unbound textboxes to report and no RecordSource.

    But you want to output data then pad the page with blank rows. I provided you two links with code to accomplish this so don't know why your advisor says cannot be done. However, the code in those links is complicated and some even incomplete. Can download an example db from https://access-programmers.co.uk/for...d.php?t=183782. I checked it out and it is much simpler than code in other links. It uses vertical and horizontal line controls to create the blank rows. Because it came from UK, report page size is set to A4 - you can change that and adjust margin settings. To change the number of rows per page, change the constant 30 in the PrintLines function. This code looks like what I tried several years ago but abandoned because did not work with my report design. Change the report open default to PrintPreview. Code only works in PrintPreview or direct to printer.

    Just OK through the conversion error message and can delete the table that creates.

    I expect any solution will involve some VBA. Unless you want to manually add a bunch of blank rows to table as needed.

    Here is example using recordset to create dummy records in 'temp' table (table is permanent, records are temporary) https://answers.microsoft.com/en-us/...0-f4c6e94f0cb5
    Last edited by June7; 03-09-2018 at 05:15 PM.
    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.

  8. #8
    UT227 is offline Expert
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    581
    Thanks. I will try it again. I've been trying to use those codes, but kept getting errors. I worked on the errors and finally decided to ask again. I'll give this link a try.

  9. #9
    UT227 is offline Expert
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    581
    There's a version problem with that last link. It won't open on my computer.

  10. #10
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Internet Explorer version? Time to upgrade?

    Try Chrome or Firefox or Edge?
    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.

  11. #11
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    The link worked fine for me
    See attached for the example database from that link - its an old MDB file so I've converted to ACCDB & included both in the attached ZIP file
    Attached Files Attached Files
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  12. #12
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    The last link in post 10 does not have a db. But thanks for attaching the file from the other link
    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.

  13. #13
    UT227 is offline Expert
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    581
    I was able to open the link fine. I downloaded it and unzipped it. The database is not compatible with my version. I'm using 2016 and I'm not sure which that one is.

  14. #14
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Apparently, 2016 cannot convert old mdb (pre-Access2007) format.

    ridders has attached converted db you should be able to use.

    You might want to edit your forum profile.
    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.

  15. #15
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    There are 2 files in the zip I uploaded back in post 11 - MDB file (A2003) and ACCDB converted in A2010 which you should be able to open
    The latest Access version that can open A2003 files is A2013
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 04-25-2016, 08:32 AM
  2. Replies: 5
    Last Post: 06-13-2013, 08:42 AM
  3. code to delete rows based of empty cells
    By jcbrackett in forum Programming
    Replies: 3
    Last Post: 03-05-2012, 02:27 PM
  4. fulfilling empty rows
    By vojinb in forum Queries
    Replies: 2
    Last Post: 07-31-2011, 01:50 PM
  5. How to get rows with empty fields as well?
    By Orabidoo in forum Queries
    Replies: 10
    Last Post: 04-24-2009, 06:08 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
  •  
Other Forums: Microsoft Office Forums