User Profile

Collapse

Profile Sidebar

Collapse
bryonone
bryonone
Last Activity: Jul 20 '21, 06:28 PM
Joined: Jul 20 '21
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • bryonone
    replied to openReport
    in Access
    Code:
    Dim SelLic, SelSW, SelArea As String
Dim whereStr As String

SelLic = "[swLicName]= Forms![frmViewLicToLoc]![txtSelectedLicense] _
    OR Forms![frmViewLicToLoc]![txtSelectedLicense] is null _
    OR Forms![frmViewLicToLoc]![txtSelectedLicense]=''"
    
SelSW = "[swName]=Forms![frmViewLicToLoc]![txtSelectedSW] _
    OR Forms![frmViewLicToLoc]![txtSelectedSW] is null _
    ...
    See more | Go to post
    Last edited by twinnyfo; Jul 26 '21, 10:12 AM. Reason: formatted Code

      Leave a comment:

    • bryonone
      replied to openReport
      in Access
      I had tried that before. It only recognizes the first string and ignores the rest. I just tried again triple checking the & and "". Still does not work.

      I also tried in the 'WHERE" entry,
      SelA + SelB + SelC
      See more | Go to post

        Leave a comment:

      • bryonone
        replied to openReport
        in Access
        If I set
        whereStr=SelA
        It works fine

        how do I get the whereStr to be equal to SelA, SelB, and SelC.

        I want to filter on all 3 fields.

        Any thoughts?
        See more | Go to post

          Leave a comment:

        • bryonone
          started a topic openReport
          in Access

          openReport

          Trying to open a report with multiple WHEREconditions . I have 4 strings (SelA, SelB, SelC, whereStr) all defined as strings.

          SelA, SelB SelC all pieces of the whereStr

          If I set whereStr = {any of the individual strings A,B or C}, the following works

          DoCmd.OpenRepor t "rptName", acViewReport , , whereStr

          When I try to concatenate the stings into 'whereStr', I only get the first...
          See more | Go to post
          No activity results to display
          Show More
          Working...