Recent content by angeljtm
-
A
runtime error 3075
This is what occurs in the immediate window for debug.print strCriteria. Where [Region] LIKE '*north*' & Left$(strCriteria, Len(strCriteria) - 5)- angeljtm
- Post #4
- Forum: Modules & VBA
-
A
runtime error 3075
Hi! I am using the following code to search a form form a pop up form. Private Sub cmdSearch_Click() If Len(cboSearchField & vbNullString) > 0 Then strCriteria = "[" & cboSearchField.Value & "] LIKE '*" & txtSearchString & "*' And " End If If Len(cboSearchField1 & vbNullString) > 0 Then...- angeljtm
- Thread
- Replies: 5
- Forum: Modules & VBA
-
A
Using Gcriteria to Open report from Form
Hello! I've been trying to get this to work for awhile and have had no success. I am following this example http://www.techonthenet.com/access/forms/search2.php. I am trying to search records on a form by using a pop up form with the following code: Private Sub cmdSearch_Click() GCriteria =...