Results 1 to 13 of 13
  1. #1
    mrkaye is offline Advanced Beginner
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Nov 2010
    Posts
    43

    Printing

    I have a phone directory report with many pages, the problem that I need help with is the printing.



    What I want to do is have a new page to start after all the A's to C's have printed and than have the D's to G's printed and again start with a new page and so on. can you help with how this can be done.
    Last edited by mrkaye; 09-10-2011 at 11:22 AM. Reason: Title change

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    50,074
    One way is to have a calculated field in the report recordsource that will set a value for each alpha group (If first letter Like [A-C] = 1, etc). Use this value as a group criteria and set Force New Page in Group header property.

    Check out the Switch function for the expression http://www.techonthenet.com/access/f...ced/switch.php
    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
    mrkaye is offline Advanced Beginner
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Nov 2010
    Posts
    43

    Printing

    The Switch function did not work. I have a report sorted by Last Name, And when I print it is just as I want it, BUT I would like to have a new page inserted lets say at the end of the C's, then start at the top of a new page with the D's and a new page at the end of the G's and so on.
    this way if i have to add a new person who's last name starts with a B, I wont have to print the whole report again it would only be from the A's to the C's.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    50,074
    Show the expression you tried. If Switch won't work then need nested IIF.
    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
    mrkaye is offline Advanced Beginner
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Nov 2010
    Posts
    43
    I Tried the query and my report was blank. I'am a total novice at this and I dont know VBA and have no idea how to set it up, if you can help with a sample I will try it.
    TIA

  6. #6
    mrkaye is offline Advanced Beginner
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Nov 2010
    Posts
    43
    The Query was
    Expr1:Switch([Last Name]=1,"A-C",[Last Name]=2,"D-G")

  7. #7
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    50,074
    Syntax wrong. Try:

    Expr1: Switch(Left([Last Name],1) Like "[A-C]",1,Left([Last Name],1) Like "[D-G]",2)
    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.

  8. #8
    mrkaye is offline Advanced Beginner
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Nov 2010
    Posts
    43

    Printing

    I will try again.
    Will let you know (:
    Thanks again.

  9. #9
    mrkaye is offline Advanced Beginner
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Nov 2010
    Posts
    43
    I made the query just the way it was and there were no breaks in my report.

  10. #10
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    50,074
    Did you create a report group header on that field?

    Can you attach project or an extract of the relevent objects?

    I have done something like this so it should be possible for you.
    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.

  11. #11
    mrkaye is offline Advanced Beginner
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Nov 2010
    Posts
    43
    ok so far in the report view i have my 1's and 2's so far so good, how can i just print all the 1's and not the rest or how can i just print the two's and not the one's or three's and so on, you are getting me there but I think you can do it.

  12. #12
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    50,074
    You have a group header for the alpha grouping and its Force New Page property is set to After Section?

    If you don't want to report all the alpha groups then filter the RecordSource with criteria for this constructed field.
    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.

  13. #13
    mrkaye is offline Advanced Beginner
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Nov 2010
    Posts
    43
    it works, thank you so much.
    You were able to get me there.

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

Similar Threads

  1. Martin
    By mtownend in forum Access
    Replies: 3
    Last Post: 10-21-2010, 08:35 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 - Senior Forums