Re: Flexgrid Sort

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Milo (Milo_at_[remove-me)
Date: 02/18/05 

Date: Fri, 18 Feb 2005 14:37:35 +0000

I have the data in a msaccess database and am inporting it via ado

Many Regards,
    Milo

Charles Krug wrote:
> On Fri, 18 Feb 2005 11:10:18 +0000, Milo <Milo@[> wrote:
>
>>I am trying to sort my flexgrid.......here is my code:
>>
>> flxHistory.Sort = flexSortGenericDescending
>>
>>I have in column 0 a date (dd/mm/yyyy) and column 1 a time (hh:mm:ss)
>>
>>I want to sort latest at top but it isnt working!!! It is sorting by date fine, the time column not so well though. It sorts by hour fine but the minutes are all over the place! Look here to get a better view:
>>
>>http://www.freenetpages.co.uk/hp/milo/flex.jpg
>>
>
>
> What's the source of your data? If you're getting records from a
> database, you can use an Order By clause, and simply insert the records
> in the order they appear..
>
> If memory serves, a flexgrid uses lexical ordering, which might not work
> as you expect for nonstring values.
>

Relevant Pages

  • Re: VBA in Excel & ADO: some problems
    ... > I'm quite new in ADO and I need some help... ... > 1) can the same MSAccess database be accessed from Excel using ADO at the ... what should be the "mode" property on the connection string?? ...
    (microsoft.public.excel.programming)
  • VBA in Excel & ADO: some problems
    ... I'm quite new in ADO and I need some help... ... can the same MSAccess database be accessed from Excel using ADO at the ... what should be the "mode" property on the connection string?? ...
    (microsoft.public.excel.programming)
  • RE: How do I save data on a form to my database?
    ... What kind of backend are you using? ... I assume this is an MSAccess database as ... is no reason whatsoever to be using any recordset an all, let alone using ADO! ... and all of this is taken care of for you (using Access's native DAO, ...
    (microsoft.public.access.formscoding)
  • work with protected msaccess database through ado
    ... I lookin for a way to work with protect the MsAccess database through ADO. ... All my experiment endd with the message "wrong password" ...
    (borland.public.delphi.database.ado)
  • Database Update
    ... End Sub ... It updates the database but when I check the actual msaccess database ... Regards, ... Vibhu. ...
    (microsoft.public.dotnet.framework.adonet)