Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Concatenation of search criteria with db.FindFirst
Bill - I appreciate your help. The database you sent back did a great job of looking up the requisite Zip & Zip4. However, I need to return the closest 36 records (2-pages of report) to the first instance of the selected zip/zip4 combo when the entire database is sorted by: Zip...- polyonoma
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
Concatenation of search criteria with db.FindFirst
I'm still getting "Missing operator in expression" error. It's the same error I was getting before.- polyonoma
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Concatenation of search criteria with db.FindFirst
I need to search within a table, defined as rec1, for records that match both criteria: field [Zip] = input zip code field [Zip4] = input zip+4 code. Current code as typed into the form is: rec1.FindFirst "Zip =" & [Forms]![form1]![ZipName] rec1.FindFirst "Zip4 =" &...- polyonoma
- Thread
- Replies: 4
- Forum: Microsoft: Access Modules (VBA Coding)
