Results 1 to 4 of 4
  1. 12-22-2011, 01:25 PM #1
    cbrsix
    cbrsix is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    214

    Printing question


    I want to be able to print a report in alpha order by Last Name then First Name. What is the best VBA for this?
    Reply With Quote Reply With Quote
  2. 12-22-2011, 02:21 PM #2
    pbaldy's Avatar
    pbaldy
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,527
    You shouldn't need VBA. Just set up that sort in Sorting and Grouping.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com
    Reply With Quote Reply With Quote
  3. 12-22-2011, 02:44 PM #3
    cbrsix
    cbrsix is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    214
    Thank you. I don't know why I didn't think of that. It's so simple. Been a long day lol.
    Reply With Quote Reply With Quote
  4. 12-22-2011, 03:18 PM #4
    pbaldy's Avatar
    pbaldy
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,527
    No problemo!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Another Question on Printing Forms
    By MJeanBap in forum Forms
    Replies: 7
    Last Post: 01-05-2012, 07:52 AM
  2. Printing
    By mrkaye in forum Reports
    Replies: 12
    Last Post: 09-11-2011, 07:20 PM
  3. Printing from a form
    By paradox6996 in forum Access
    Replies: 3
    Last Post: 05-04-2011, 02:07 AM
  4. Printing!!!!
    By Kipster1203 in forum Access
    Replies: 7
    Last Post: 05-14-2010, 08:58 AM
  5. Help with my printing
    By mattwill2001 in forum Queries
    Replies: 4
    Last Post: 08-17-2009, 01:55 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums