Custom Recordset Sorting

databases United States
  • 19 years ago

    Hi there,


    How can I sort a custom recordset? I uses the following statement:


    Rs1.Sort = "Field1 ASC"


    and it return this error:


    Order cannot be opened

  • 19 years ago

    Are you using ADO or DAO. I would strongly recommend using ADO, and then you can just use a SQL statement...

Post a reply

Enter your message below

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“A computer lets you make more mistakes faster than any other invention in human history, with the possible exceptions of handguns and tequila” - Mitch Ratcliffe