Results 1 to 4 of 4
  1. #1
    keiath is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2013
    Posts
    162

    Print report on form in view

    Hi All

    I have a two part question



    I have a button and i want it to print a report, of only the form record that I am viewing, how do you do this,

    Secondly, in the form i have a check box, that's from landlord table that notes if interest can be charged on arrears or not, this means I have two buttons that opens a report (for a letter) on is interest to be charged on is no interest to be charge, sop what I want to do is if the box is checked (to denote interest is chargeable) then i want the other button to not work, ie unavailable, how would i do this

    Many thanks

    Keith

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    use the ID on the master form to filter the report....
    docmd.openreport "myReport",,"[id]=" & me.txtID

    turn off 1 check box if the other is on...
    chk2.enabled=not chk1.value

  3. #3
    keiath is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2013
    Posts
    162
    DoCmd.OpenReport "1st Letter with Intrest", , "[Case]=" & Me.txtID

    Tried this, Case being the form and table name, but that doesnt seem to work

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    The WhereCondition argument of the OpenReport command is the 4th argument, not the 3rd.
    DoCmd.OpenReport "1st Letter with Intrest", , , "[Case]=" & Me.txtID
    ...you may also have a problem with the embedded spaces it the Report's name.

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

Similar Threads

  1. View/Print PDF attachment in report
    By bnecrush in forum Access
    Replies: 3
    Last Post: 02-15-2016, 11:44 AM
  2. Switch from Print Preview to Report View
    By MatthewR in forum Reports
    Replies: 5
    Last Post: 10-20-2015, 12:40 PM
  3. Replies: 1
    Last Post: 02-21-2015, 11:35 PM
  4. convert report view to print preview
    By DarrenUD in forum Reports
    Replies: 3
    Last Post: 03-19-2013, 12:21 AM
  5. Replies: 2
    Last Post: 05-06-2012, 11:10 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