Recent content by barryjohnson

I think I will be having a lot of fun, but I will try to use it. Barry

Sure. I'd appreciate any help and I'm not opposed to changing what I have coded so far. It works well except for the re-sort problem and the highlight (color, bold, etc.) of the items added from my second database. I'm going to look into the idea presented about the icons - I don't think the...

strongm, did you have any ideas to the second part of my thread? Barry p.s. - I'f I didn't have so many other things going on right now, I might be tempted to play with the "deeper" API calls -- maybe someday.

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...

I found the Option Compare in VB and tried both text and binary. It didn't help.

Our new ProductFamily 'values' can take on the form: xx#### or xx##### XX#### or XX##### xx####x or xx#####x XX####x or XX#####x x & X = alpha # = numeric I understand your responses and I appreciate them! You answered my question regarding how Access 'views'...

Where do you set "option compare"? I can't find reference to it in my Access manuals.

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...

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...