+ Post New Thread
Results 1 to 9 of 9
Office Software Thread, Yet another Access question in Technical; Im not sure how I would go about this, whether it would be a form or a query or whatnot. ...
  1. #1

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,531
    Thank Post
    1,341
    Thanked 470 Times in 307 Posts
    Blog Entries
    6
    Rep Power
    200

    Yet another Access question

    Im not sure how I would go about this, whether it would be a form or a query or whatnot.

    I have a database with reports Ive created, which when I print print out the whole data set, unless i specify which pages I want. Its very tiresome doing a print preview and then finding out which 5 pages out the 2000 are the relevant ones. So I'm trying to think of a way to only print certain records.

    Ideally Id like it to prompt for, say the students name, and then print only those records.

    How would I go about doing this please?

  2. #2

    Domino's Avatar
    Join Date
    Oct 2006
    Location
    Bromley
    Posts
    4,127
    Thank Post
    217
    Thanked 1,323 Times in 812 Posts
    Blog Entries
    4
    Rep Power
    518
    I would have thought you could knock up a quick form with drop downs that point to the various fields.

    This is probably overkill, but should point you in the right direction How do I… Select records for a dynamic label report in Access? | How Do I… | TechRepublic.com

    However for the simplicity the built in wizards might be better

  3. #3

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,531
    Thank Post
    1,341
    Thanked 470 Times in 307 Posts
    Blog Entries
    6
    Rep Power
    200
    What I want to do though is print off the exact report that Ive got, not just a form with a summary of the data.

    Would i need to create a form that looks the exact same way as the report and then just have a drop down for the fields i want?

  4. #4
    krisd32's Avatar
    Join Date
    Feb 2006
    Location
    Longridge, Preston
    Posts
    545
    Thank Post
    85
    Thanked 68 Times in 47 Posts
    Rep Power
    43
    Why don't you create a query finding the data you require and then create a report from the query you've just created?
    Thats how i'd do it or am I getting the wrong end of the stick?

  5. #5

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,531
    Thank Post
    1,341
    Thanked 470 Times in 307 Posts
    Blog Entries
    6
    Rep Power
    200
    yeh u are hehe.

    I have the query, selects all the data, and fills in a nice report.

    But the report is 2000 pages long.

    Sometimes I want to just to print 5 pages of the report (each 5 pages correspond to a new student for example, and I want to just print 1 student)

    At the moment, I need to print preview the report, then scroll all the way through to page, for example, 1835, until i find Johnny Zebra's pages, and then print only page 1835 to 1840.

  6. #6

    Domino's Avatar
    Join Date
    Oct 2006
    Location
    Bromley
    Posts
    4,127
    Thank Post
    217
    Thanked 1,323 Times in 812 Posts
    Blog Entries
    4
    Rep Power
    518
    Yeah, I'd create a form that filters (either the final report, or the query itself - it'd run quicker if it was the query) and outputs just the pages you want.

  7. #7

    Join Date
    Sep 2008
    Posts
    5
    Thank Post
    0
    Thanked 3 Times in 2 Posts
    Rep Power
    0
    Duplicate the query that finds all the data for all the records and then just set it to ask you for a students name. When you run the report it'll ask you to type that students name in and then only produce the 5 pages associated with that student. If you copy the query and report there's no reason it'd look any different from the original. (except for being a lot shorter).

    Putting [Please select student] in the student criteria box should give you the prompt.

  8. Thanks to cehwitham from:

    RabbieBurns (21st October 2008)

  9. #8
    krisd32's Avatar
    Join Date
    Feb 2006
    Location
    Longridge, Preston
    Posts
    545
    Thank Post
    85
    Thanked 68 Times in 47 Posts
    Rep Power
    43
    Thats kind of what i meant but obviously didn't explain myself that well! its just been one of those days!
    Last edited by krisd32; 20th October 2008 at 04:32 PM.

  10. #9

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,531
    Thank Post
    1,341
    Thanked 470 Times in 307 Posts
    Blog Entries
    6
    Rep Power
    200
    Quote Originally Posted by cehwitham View Post
    Putting [Please select student] in the student criteria box should give you the prompt.
    That's the bit I didn't know how to do. Thanks

SHARE:
+ Post New Thread

Similar Threads

  1. Microsoft Access 2007 Report Printing Question
    By RabbieBurns in forum Windows
    Replies: 7
    Last Post: 20th May 2008, 02:23 PM
  2. Access question
    By Jobos in forum Windows
    Replies: 3
    Last Post: 7th October 2007, 09:44 PM
  3. Replies: 2
    Last Post: 31st May 2007, 04:15 PM
  4. Replies: 42
    Last Post: 10th April 2007, 09:18 AM
  5. Wireless Access Point SSID Question
    By mseaney in forum Wireless Networks
    Replies: 14
    Last Post: 14th October 2005, 08:23 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
  •