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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: barryjohnson
- Content: Threads
- Order by date
-
Color an item added to a ComboBox?
I have a ComboBox called "cboPlatform". I query a Access Database and populate cboPlatform from a Products Table with all the Distinct values in the Field called Platform. Then I query a second Access Database that also has a Products Table/Platform Field and compare the values in...- barryjohnson
- Thread
- Replies: 10
- Forum: Visual Basic (Classic)
-
Select DISTINCT question
I have a Acces97 database with several thousand entries. I have a field that's called ProductFamily. When we started using the database several years ago, we only entered UPPERCASE ProductFamily names, such as "BREAKERONE", "BREAKERTWO", etc. Now we need to start using...- barryjohnson
- Thread
- Replies: 6
- Forum: Microsoft: Access Queries and JET SQL
-
Select DISTINCT question
Access 97 Data: ABOY, aboy, BBOY, bboy When I run an SQL query: Select DISTINCT Data from table I get this as a response: ABOY, BBOY It doesn't give me back the aboy & bboy. How can I make the query see the other two values? It looks like Access97 or SQL sees them the same as the uppercase...- barryjohnson
- Thread
- Replies: 5
- Forum: Microsoft: Access Other topics
