Solved

VB6 - Sort ID AutoNumber descending issue

Posted on 2012-12-29

3 solutions

673 Views

Last Modified: 2012-12-29

Hello all

I have a MSHFexgrid1 that have data from my Microsoft Access dbase.

I want to sort column 1 that have the ID AutoNumber from MS Access.

The problem is that when i do this, i see that result:
99
98... 'going down
89
88... 'going down
29
28... 'going down
100
1

So i don't have a real descending sorting.

How can i fix this?

Thanks again

Full code

'Sort grid
            With MSHFlexGrid1
                .Col = 1
                .Sort = flexSortStringDescending
            End With

Open in new window

Comment

Question by:Wilder1626

[X]

Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

Help others & share knowledge
Earn cash & points
Learn & ask questions

Join The Community

4 Comments

LVL 47

Assisted Solution

by:Martin Liss

Martin Liss earned 167 total points

ID: 387301242012-12-29

Create a column with zero width. Put the same data in the column except use Format(MyValue, "00000"). Then sort on that column.

LVL 10

Accepted Solution

by:honestman31

honestman31 earned 167 total points

ID: 387301282012-12-29

well, there is nothing wrong with the result you are getting, the result is based on String sorting

and in String sorting 100 is less than 28 ( one is less than 2 )

try to check if there is numeric sorting option or not

.Sort = flexSortNumricDescending ( not sure if that exist or not , however you got the idea

LVL 29

Assisted Solution

by:IrogSinta

IrogSinta earned 166 total points

ID: 387301342012-12-29

As mentioned by honestman, you need to use flexSortNumericDescending. For a list of other sort options, check out this link:
http://msdn.microsoft.com/en-us/library/aa261266(v=vs.60).aspx

LVL 11

Author Closing Comment

by:Wilder1626

ID: 387301392012-12-29

Hello all

Thanks for all the help.

I will go with this:

'Sort grid
With Form3.MSHFlexGrid1
.Col = 1
.Sort = flexSortNumericDescending
End With

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Tax Refund Phishing Scam – Protect Your Money

Article by: Dermot

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it

Creating an Access Database Taskbar Item in Windows 7 through 10

Article by: Helen

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database. This article shows how to recreate this functionality in Windows 7 through 10.

Microsoft Access

Excel Error Handling Part 1 -- Basic Concepts

Video by: crystal

This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

How To Make a Graph with Microsoft Access

Video by: crystal

Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…