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. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,340
    Thanks
    1
    Thanked 18 Times in 18 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
  •