Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jun 2003
    Location
    Camp Lejeune, North Carolina, USA
    Posts
    20
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Access 2007 Printing single record using report

    We have a database I am building that lists all jobs we have received for clients to view. They can query by Job Title or Location. I want to put a button on report so that a single job can be printed. On print properties window print current record is greyed out.

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,325
    Thanks
    1
    Thanked 12 Times in 12 Posts
    Quote Originally Posted by lockwoodbf View Post
    We have a database I am building that lists all jobs we have received for clients to view. They can query by Job Title or Location. I want to put a button on report so that a single job can be printed. On print properties window print current record is greyed out.
    The "Print Current Record" merely prints the screen. this is seldom what you want. You should create a report the shows the job information like you want it printed. You then add a Command button to the screen with a caption of "Print Job". It calls this report you created, specifying the job. Something like this:

    docmd.OpenReport "rptJobs",view:=acViewNormal,wherecondition:="JobI D=" & txtJobID

    I made a bunch of assumptions: rptJobs is your report, JobID is the job identifier, and txtJobID is a control on your form containing the job you want to look for.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Tags for this Thread

Posting Permissions

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