Search results
-
R
VBA coding help & Form Linking
I have a form called "Search Issues' and a Subform within call "Browse All Issues". Browse All Issues Record source is a table that contains all the data called Issues. I'm trying to create search features within "Search Issues" where I can select multiple criteria from List box and when I...- rwrig
- Thread
- Replies: 21
- Forum: Modules & VBA
-
R
Event not triggering when clicking Search Button
Hello All: I have the below VBA in a from for it to filter the records below based on the criteria: Private Sub Search_Click() Dim strWhere As String strWhere = IIf(Len(Me.AssignedTo & "") <> 0, "([AssignedTo] Like ""*" & Me.AssignedTo & "*"") AND", "") & _...- rwrig
- Thread
- Replies: 4
- Forum: Modules & VBA
-
R
Multiple Criteria search form help with the VBA Code
Hey Guys I need help constructing the VBA code for this form so that a user can be able to select the multiple criteria and click search and the table below will filter the criteria selected. I included the screen shot and all fields names are the same names as the labels. Here's my current... -
R
New to VBA need help
Private Sub Search_Click() Dim strWhere As String Dim lngLen As Long Const conJetDate = "\#mm\/dd\/yyyy\#" If Not IsNull(Me.AssignedTo) Then strWhere = strWhere & "([AssignedTo] Like ""*" & Me.AssignedTo & "*"")" End If If Not IsNull(Me.OpenedBy) Then strWhere = strWhere & "([OpenedBy] Like ""*"...