+ Post New Thread
Results 1 to 8 of 8
Windows Thread, Microsoft Access 2007 Report Printing Question in Technical; Hello, was recommended this place by an existing poster.. Hopefully this is the right place to post this question. I ...
  1. #1

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,476
    Thank Post
    1,305
    Thanked 469 Times in 306 Posts
    Blog Entries
    6
    Rep Power
    198

    Microsoft Access 2007 Report Printing Question

    Hello, was recommended this place by an existing poster..

    Hopefully this is the right place to post this question.

    I have an MS Access database that I would like to be able to print from two reports at once, but collate the printouts, if that makes sence.

    I.E: Its a reports database for THE school, and so theres an MS Access report that prints out all the subject reports for a student (normally about 7 -10 pages per student, 1 subject per page)

    But then theres the Headmaster MS Access report, that prints out 1 page per student.

    Is there any way to link these MS Access reports, so it will print a students Subject reports, and then print the Headmaster report, and then go back to the next students subject reports .. etc etc ?

    Ive had a look about the MS Access sections on the microsoft site, and google hasnt really thrown up much.. Cheers

  2. #2

    Join Date
    Jan 2007
    Posts
    22
    Thank Post
    0
    Thanked 3 Times in 2 Posts
    Rep Power
    15
    The word you need is 'subreport'.

    Check the help file. You can use your existing reports as subreports in a new main report. You will probably need to change the headers and footers in the sub reports and create something similar in your main report.

  3. Thanks to Opensource from:

    RabbieBurns (23rd April 2008)

  4. #3

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,476
    Thank Post
    1,305
    Thanked 469 Times in 306 Posts
    Blog Entries
    6
    Rep Power
    198
    thanks yep thats what Im looking for

    Its hard work though trying to get them to fit together though ;/

  5. #4

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,476
    Thank Post
    1,305
    Thanked 469 Times in 306 Posts
    Blog Entries
    6
    Rep Power
    198
    Ive managed to get the subreport looking decent, but when I go to print preview it warns that the margins are bigger than the page, and then it has 2 blank pages after every page.

    Cant figure it out. Any suggestions?

  6. #5

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,476
    Thank Post
    1,305
    Thanked 469 Times in 306 Posts
    Blog Entries
    6
    Rep Power
    198
    Hopefully someone can help me with this. I want to get a list of subjects, and a grade, for each pupil, on a seperate page, but I cant seem to figure out how to get each PupilID onto a seperate page. The report layout is below.

    http://www.peninsulafm.com/access.jpg

    Any suggestions?

    Thanks in advance

  7. #6

    mac_shinobi's Avatar
    Join Date
    Aug 2005
    Posts
    9,212
    Thank Post
    2,766
    Thanked 935 Times in 875 Posts
    Rep Power
    343

    just a thought

    not sure if this will work so before you continue you may want to close down the database and make a copy / backup of it and then try this.

    Create a blank report

    then open it up how you have there where it shows you the reports on the left, then try and drag and drop another report in there ( if it lets you ) if it does then drag the blank report into the main window and drag the other fields from one report into the blank report.

  8. #7

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,476
    Thank Post
    1,305
    Thanked 469 Times in 306 Posts
    Blog Entries
    6
    Rep Power
    198
    got another question regarding the printing of reports.

    When this is finished, its going to be sitting in the wwwroot folder of the IIS server. The problem is though that the admin staff are going to need to be able to print off reports from within the MS Access database.

    Im trying to think of the best way to do this without either giving them access to the wwwroot folder or without manually copying the .mdb file to somewhere they can access.

    Is there any way to initiate print commands from maybe an .asp page?

    Ive started to look at Auto-it as well as a possible method for them to print without having to open up MS Access themselves?

  9. #8

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,476
    Thank Post
    1,305
    Thanked 469 Times in 306 Posts
    Blog Entries
    6
    Rep Power
    198
    Sorted with a vbs for now

SHARE:
+ Post New Thread

Similar Threads

  1. Office 2007, problems with saving/printing
    By maniac in forum Windows
    Replies: 2
    Last Post: 24th September 2007, 10:30 AM
  2. Word 2007 printing ranges
    By Filfoot in forum Wireless Networks
    Replies: 0
    Last Post: 12th July 2007, 10:34 AM
  3. he 2007 Horizon Report
    By russdev in forum Blue Skies
    Replies: 0
    Last Post: 24th January 2007, 09:18 PM
  4. Microsoft Vista and Office 2007: Interim report
    By CyberNerd in forum School ICT Policies
    Replies: 6
    Last Post: 12th January 2007, 09:36 AM
  5. Printing Access Reports... or not!
    By Frazer in forum Windows
    Replies: 0
    Last Post: 20th October 2005, 11:03 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •