How To Sort Records Alphabetically BUT Exclude Just One Record

[nicebasic]

Thank you very much, Delerna.

Thank you very much, Delerna.

You've been so kind in this case. I thank you so much for being so informative.

Actually, you seem to be a really professional programmer. Your method is a brilliant and systematic one. There is a problem with me, however. I'm not as knowledgeable as you are in this case.

I wonder if it's possible to apply your commands to an ASP Classic code. Since the syntax of SQL Queries in ASP Classic is different from Access VBA, I'll have to focus on this matter more.

Thank you very much indeed for your kind attention.

I warmly appreciate your help, Delerna.

[ADezii]

I took the liberty of creating a 2nd Demo based solely on Delerna's approach, which again is more efficient. The Method, I feel is essentially foolproof in that:

1. The Combo Box will only display 'Unique' Cities within the Country Table.
2. Select a City from the Combo Box, then click on the Command Button to Open a Query based on Delerna's Logic. There need be no Validation on the City Name with this approach.
3. Should the Combo Box not contain a Value (NULL) when the Command Button is clicked, the User is warned of this via a Message Box, focus is now set to the Combo Box, and it is Dropped Down for another try.
4. Download Sort2.zip and you'll see exactly what I mean.

@Delerna - I hope you did not mind that I used your Code. It's simply that yours is a much better approach, and I would prefer to see it used in this case. I am definitely not trying to 'Step on Your Toes'. If you feel as though my adaptation can be further improved, please feel free to do so. Thanks.

[Delerna]

Adezii
I have no problems with that at all.

I come here to share what I have learned as well as to learn from what others share

[Delerna]

Nicebasic

I wonder if it's possible to apply your commands to an ASP Classic code. Since the syntax of SQL Queries in ASP Classic is different from Access VBA, I'll have to focus on this matter more.

Classic asp is starting to become "old school" but the answer is yes. I still use classic asp connecting to MSSQL server (access is not much different) and querying for data to display on intranet web pages for almost everything I do.
What, exactly, do you need to know? I will help if I can

[nicebasic]

This is really great, ADezii.

You made a great demo in your excellent Sort2 project.

Thank you again and again for being so kind.

[nicebasic]

I have learnt a lot thanks to ADezii's and YOUR contribution to THIS POST.

I still cannot apply this code to my ASP Classic project. Since you're familiar with ASP Syntax, I wonder if you can help me accomplish this in ASP Classic.

To make this question more relevant, I have posted this question in the ASP Classic Section as well. The link to the ASP Classic Question Page is as follows:

Please Visit This Page!


I appreciate any kind of help you might have for me. You seem to have a special method or technique of your own that is unique.

I hope I can use your sophisticated method in my ASP Source Code.

Thank you again for being so helpful and informative.

Good luck, Delerna.