User Profile

Collapse

Profile Sidebar

Collapse
niallmc
niallmc
Last Activity: Oct 4 '06, 06:31 PM
Joined: Sep 11 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • niallmc
    replied to Using VBA filter on one or more fields
    in Access
    Thanks for that.

    What I am trying to do is return all records when eith one is true OR both fields are true. OR only works with one field.
    Any suggestions?

    niall
    See more | Go to post

      Leave a comment:

    • niallmc
      started a topic Using VBA filter on one or more fields
      in Access

      Using VBA filter on one or more fields

      Hi,
      I am trying to open a VB form based on stLinkCriteria, using 2 fields.
      It is successful for me if both fields have information in them.
      However I wish to be able to search on either field

      Here is my code
      Dim stDocName As String
      Dim stLinkCriteria As String

      stDocName = "frmOpen"
      stLinkCriteria = "[Code1]=" & "'" & Me![Code1]...
      See more | Go to post
      No activity results to display
      Show More
      Working...