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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by GFish1
-
Problem with syntax
UPDATE: I got it working ! I had to modify a function in a module ...must have missed ! Thank you all for your expertise - very commendable !- GFish1
- Post #11
- Forum: Microsoft: Access Queries and JET SQL
-
Problem with syntax
I didn't create the database or I would have made numerous changes. I am stuck trying to support it. I am not getting it to filter....I know a combo box has the feature I need, but might be too involved. I quickly attempted to put in a combo box and the search works, but when I try to select a...- GFish1
- Post #9
- Forum: Microsoft: Access Queries and JET SQL
-
Problem with syntax
Yes I am using Access, so i used the "*". I put this in: strFilteredList = "SELECT [Employee Info].[Last Name], [Employee Info].[First Name] FROM [Employee Info] WHERE [Employee Info].[Last Name]] LIKE '" & Me.txtSearch.Value & "*" ORDER BY [Employee Info].[Last Name];" and get a compile...- GFish1
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
Problem with syntax
Hello, I am trying to do the following: - use a text box to type in e.g., smi and have a filtered query run and display all names starting with smi - I have a list box below the text box that has a full queury of all records. So the text i type in the text ox above needs to be captured and...- GFish1
- Thread
- Replies: 11
- Forum: Microsoft: Access Queries and JET SQL
