Results 1 to 11 of 11

Report on Existing Paper Form

  1. #1
    ekulrenlig is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2012
    Posts
    6

    Report on Existing Paper Form

    I need to build a report to print my data on a pre-developed form (paper). Normally the data has been written in by hand. What is the easiest way to go about this? The report needs to show 5 records of data per page, within the "boxes" on the form. I've tried to copy and paste the form as a background in the detail section, and then positioned my data just right within it, but can only get it to show one record per page. How can I show five records per page? Columns don't seem to work because of the form in the background. Maybe there's an easier way to go about this, I'm somewhat new to access, please help.

  2. #2
    June7's Avatar
    June7 is online now Moderator
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    29,633
    I am guessing you get one record per page because the image makes the Detail section so large the records are spaced that far apart. Size of the Detail section determines how much space between each record. Maybe not the easiest, but the correct way is to create a facsimile of the paper form by creating controls within report/page/group header/footer sections along with the Detail section.
    To provide db: Make copy, remove confidential data, run compact & repair, zip if large - 2mb allowed, attach to post. Attachment Manager is below the Advanced post editor window.
    If suggestion in this post resolves your issue, please use the Thread Tools and mark the thread as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

  3. #3
    ekulrenlig is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2012
    Posts
    6
    Ahhh....please explain. Create a facsimile?

  4. #4
    June7's Avatar
    June7 is online now Moderator
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    29,633
    Facsimile - something that looks like the paper form. Do this by positioning label and textbox controls, use of graphic lines and boxes, set font characteristics (style, size, color), logo image in the report header, etc.
    To provide db: Make copy, remove confidential data, run compact & repair, zip if large - 2mb allowed, attach to post. Attachment Manager is below the Advanced post editor window.
    If suggestion in this post resolves your issue, please use the Thread Tools and mark the thread as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

  5. #5
    ekulrenlig is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2012
    Posts
    6
    So, I'm attempting to tackle this project again. I basically created the report manually with lines and such to match the look of the pre-developed paper report. I have 5 columns and am able to show 5 records of data. I have a page header to show some other information. My problem now is that I need the 5 columns of data to be positioned on the right 3/4ths of the page. Then I need the labels or just plain text on the left 1/4th of the page. These labels will be the same on every page of the report, but I don't want labels in each column of data. Whats the easiest way to solve this. Please help.

  6. #6
    June7's Avatar
    June7 is online now Moderator
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    29,633
    Delete the unwanted labels?

    I would have to see the report design to really advise.
    To provide db: Make copy, remove confidential data, run compact & repair, zip if large - 2mb allowed, attach to post. Attachment Manager is below the Advanced post editor window.
    If suggestion in this post resolves your issue, please use the Thread Tools and mark the thread as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

  7. #7
    ekulrenlig is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2012
    Posts
    6
    Here is an excel file of what the final report is supposed to look like. At top in the first two "rows" has some page header information. Then below that is basically the labels for the data on the left, with 5 columns of data to the right of that. Then on the bottom has some other data, that maybe I'll have to show with a subreport?, I haven't gotten that far yet. The source data is a standard table, there are no calculations any where on the report. How can I make this "paper form" into an access report?
    Attached Files Attached Files

  8. #8
    June7's Avatar
    June7 is online now Moderator
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    29,633
    Clarify, the Excel example shows a blank form, no data. Are you wanting to output actual data onto this form? Looks like the records would output horizontally (left to right). This can be difficult.

    Review
    http://www.accessforums.net/programm...ias-21972.html
    To provide db: Make copy, remove confidential data, run compact & repair, zip if large - 2mb allowed, attach to post. Attachment Manager is below the Advanced post editor window.
    If suggestion in this post resolves your issue, please use the Thread Tools and mark the thread as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

  9. #9
    ekulrenlig is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2012
    Posts
    6
    Yes, the data would output horizontally. The report design in the link you sent would be pretty similar. I thought it would be pretty straight forward, but apparently I am more of a newbie than I thought. Attached is some pdf's of this report with one column of data on each page instead of 5 columns.Compartment_Examinations_2010_Y1C2.zip

  10. #10
    June7's Avatar
    June7 is online now Moderator
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    29,633
    Yes, that data output definitely reminds me of what I had to do and will require some creative programming. Use the example offered and attempt code for your situation. Post question when you encounter issue.

    I have another case that also looks much like your output. However, that situation requires Excel grabbing the data from Access and rearranging it horizontally on spreadsheet. Excel is necessary because the users are not permitted interaction with the Access interface and a very limited dataset is retrieved for their needs. They also need the data in Excel for import into another program.

    Older version of the Access file can be downloaded from link in this thread http://forums.aspfree.com/microsoft-...hs-445065.html

    Link to the Excel file https://www.box.com/shared/m6q4s1h99n
    To provide db: Make copy, remove confidential data, run compact & repair, zip if large - 2mb allowed, attach to post. Attachment Manager is below the Advanced post editor window.
    If suggestion in this post resolves your issue, please use the Thread Tools and mark the thread as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

  11. #11
    ekulrenlig is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2012
    Posts
    6
    Yeah, I have been thinking that Excel might be the better route. I'm pretty new to Access and haven't played around with any code, so I think there would be too much of a learning curve right now. I know Excel pretty well and think I can make some pivot tables to format the data how I need it. The raw data is actually from an ArcGIS shapefile (dbf) file so I can open it in Excel anyway. It just seams like there should be an easy way in Access to set up one column of data like I did in the pdf's, and then say record 2 goes in this column, record 3 goes in this column, and so on. Oh well. Thanks for your help, I'll be back when I have other questions.

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

Similar Threads

  1. updating existing report with new data in table
    By newtoaccess123 in forum Reports
    Replies: 2
    Last Post: 10-18-2011, 08:50 AM
  2. Replies: 3
    Last Post: 10-17-2011, 01:38 PM
  3. Replies: 0
    Last Post: 03-06-2010, 11:11 AM
  4. print report on paper for image
    By gromit95 in forum Reports
    Replies: 11
    Last Post: 01-12-2010, 06:09 AM
  5. Editing Existing Report
    By wsuspte in forum Reports
    Replies: 1
    Last Post: 02-11-2009, 12:53 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