Sort Order not reflected in Form's Recordset

M

MrSuaveh

All,

Unfortunately I have a client that still uses Access 2000. That's not so
bad, but there is one feature that I cannot find a way to add and it only
fails in Access 2000.

When we create an ADO recordset and then bind it to an Access 2000 form we
can't find a way to sort the records. For some reason when the rs.Open
<source> uses a <source> string where the Len() is greater than 256
characters then we get a 'Class Not Registered' error the next time we click
anywhere on the form. This seems to prevent the OrderBy and OrderByOn from
working.

BTW, this isn't for just 1 form on 1 workstation, that is consistent for 30+
workstations on 6 different forms.

Anyway, so I say heck with OrderBy, I'll do something like this:

dim rs as new adodb.recordset
set rs = me.recordset
rs.sort = "Field"
set me.recordset = rs

However, this also does not work. If I loop through rs it shows the correct
sort order. After binding it to the form though the correct sort order is
not reflected on the form.

So waz up? Anyone ever run into this funkiness? What obvious things am I
missing? Please illuminate.

Thanks,
Rick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sort in VB using a ComboBox Column Other than the Bound Column 4
Assign recordset - subform 1
ADO recordset can not be updated 0
Me.Recordset vs a recordset variable. 9
When I set the Orderby to true on my form access crashes by why? 1
Changing pivot table ADO recordset 0
Binding a form to a disconnected recordset and making it capable to update such recordset 2
Form data not refreshing after editing 1

Top