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?
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?
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)
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
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.
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.
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.
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.
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.
There's a version problem with that last link. It won't open on my computer.
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.
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
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.
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.
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.
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