User Profile

Collapse

Profile Sidebar

Collapse
Tamille2020
Tamille2020
Last Activity: Feb 24 '22, 06:30 PM
Joined: Feb 22 '22
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Tamille2020
    replied to Ability to Create/Print Report from User Filtered Sub-form
    in Access
    Great suggestion NeoPa. I was able to get the sub-form filter to transfer over to the report via the following code:
    Code:
    Private Sub PrintPDF_Click()
    Dim strCriteria As String
        strCriteria = Trim$(Me![SearchQSubform].[Form].[Filter] & "")
    If Len(strCriteria) Then
        strCriteria = Replace$(Replace$(strCriteria, "[SearchQSubform].", ""), "SearchQSubform.",
    ...
    See more | Go to post
    Last edited by NeoPa; Feb 25 '22, 05:01 AM. Reason: Added the mandatory [CODE] tags.

      Leave a comment:

    • Tamille2020
      replied to Ability to Create/Print Report from User Filtered Sub-form
      in Access
      Hi NeoPa. The SubForm Control is SearchQSubform. I tried the suggested code, I get the "Enter Parameter Value" popup box. It is asking for "SearchQSubform .Recipients" input. The column that is being filtered by the user is "Recipients ".
      See more | Go to post

        Leave a comment:

      • Tamille2020
        started a topic Ability to Create/Print Report from User Filtered Sub-form
        in Access

        Ability to Create/Print Report from User Filtered Sub-form

        My end user is using a filter on a sub-form (SearchQSubform ) then pressing the "PrintPDF" button that is located on the form (SearchForms). However, all the searched data in the sub-form is printing. I only wish to print the user's filtered data. I tried putting the following code in the "On Click" event procedure for the "PrintPDF" button:

        Private Sub PrintPDF_Click( )

        DoCmd.OpenRepor t...
        See more | Go to post
        No activity results to display
        Show More
        Working...