Results 1 to 6 of 6
  1. #1
    qbc is offline Advanced Beginner
    Windows 2K Access 2003
    Join Date
    Aug 2009
    Posts
    30

    Creating a Report with Pages Attached

    Hi,
    I have created a report for my company and would like to add about 100 pages of terms and conditions to it for my company and make it part of the report.
    Is there anyway I can hard code this in?
    I don't think I'll be able to put it into a memo field because it will be too large.

    Any help would be much appreciated.

    I am using Access 2003.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,626
    What do you mean by 'part of the report'? You want page numbering to continue from the Access report onto the 100-pager? Is this a Word document? I suggest you have reference in your Access report to an appendix then print or photocopy the document as such. This article discusses printing a Word document from VBA code http://www.ehow.com/how_6552358_prin...nt-access.html

    Printing the Access report and the 100-pager would be two print jobs.
    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.

  3. #3
    qbc is offline Advanced Beginner
    Windows 2K Access 2003
    Join Date
    Aug 2009
    Posts
    30
    Let me clarify.
    I am running a report in Access drawing from my table and included in that report, I need to include about 100 pages of standard terms and conditions. These terms and conditions need to be part of the report.

    i.e.
    Pages 1-5 - Is the information drawn from my table
    Pages 6-106 - Are the standard terms and conditions that do not change.

    Any thoughts?

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,626
    Access is a relational database, not a word processor.

    I know data from Access can merge into a Word document, I think data can be extracted from a Word document into Access table.

    You could create a table TermsConditions. Each record would be a term or condition statement. Include these records as part of the report. Maybe as a subreport.

    So your choices seem to be:

    1. Merge the Access data into pages 1-5 of Word document

    2. Table of TermsConditions in Access
    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.

  5. #5
    qbc is offline Advanced Beginner
    Windows 2K Access 2003
    Join Date
    Aug 2009
    Posts
    30
    Yes, I don't want to go with option 1.
    I'd like to create a table with the terms and conditions in Access. The question/problem I have is how many characters can I enter in the field?
    The terms and conditions are about 100 pages long so there would be a lot of characters.

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,626
    A text field can have 255 characters, memo field 65,535.
    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. One page report is printing as 666 pages
    By JackieEVSC in forum Reports
    Replies: 3
    Last Post: 12-20-2011, 10:10 AM
  2. Creating Web Pages
    By prstoessel in forum Access
    Replies: 7
    Last Post: 08-06-2011, 11:28 AM
  3. Report pages
    By combine21 in forum Reports
    Replies: 1
    Last Post: 03-05-2011, 04:39 PM
  4. Balnk Pages in Report
    By jbarrum in forum Access
    Replies: 3
    Last Post: 01-28-2010, 01:58 PM
  5. Blank pages between report pages
    By jonsuns7 in forum Reports
    Replies: 2
    Last Post: 10-01-2009, 05:06 AM

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