Results 1 to 6 of 6
  1. #1
    mike23 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Apr 2014
    Posts
    16

    Printing specific record


    I need help with the code to print the current record I am viewing on a form in a report. I have records in a database that need name badges, some may need to print individually. I want the current one I am viewing the only one to print. I use a field called "ID" as the primary key.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,643
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    mike23 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Apr 2014
    Posts
    16
    Thank you for the reply, I am not sure if I am understanding the code.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,643
    Have you tried it? You can use the same wherecondition argument with OpenReport.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    mike23 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Apr 2014
    Posts
    16
    i think im just confused on how to use it.

  6. #6
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    Maybe Allen's example will be easier for you to understand:

    http://allenbrowne.com/casu-15.html

    Linq ;0)>

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

Similar Threads

  1. Printing a single record in a report
    By kelann in forum Reports
    Replies: 28
    Last Post: 10-04-2012, 10:07 AM
  2. Replies: 12
    Last Post: 08-21-2012, 02:40 PM
  3. Printing report from first record works...
    By TinaCa in forum Programming
    Replies: 10
    Last Post: 01-17-2012, 10:59 AM
  4. Replies: 0
    Last Post: 05-25-2011, 06:13 AM
  5. Printing the active record only
    By aligahk06 in forum Access
    Replies: 3
    Last Post: 12-02-2010, 08:22 PM

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