ado_rs.sort does not compile

[SteveApa]

Hi.



Access front end / sql server backend. I have vba sql to pull data from 3 joined tables. T1 left join to T2 Left joined to T3. I do not know if the T3 has any entries so I cannot add an "Order by T3.Element desc". I have to wait until I get the results to find out if there are any T3 elements. If I add the order by to the sql and there are no elements, I get a error as expected. So, I thought I would run and then use the ado_rs.sort I searched the web and found you .... ado_rs.Sort "ElementNameToBeSorted desc, ElementNameOfOtherToBeSorted asc". But, I get a compiler error: Invalid use of property. I got syntax from

https://docs.microsoft.com/en-us/sql/ado/reference/ado-api/sort-property-example-vb?view=sql-server-ver15

I assume there is not a special reference I need... all other ado stuff works as expected.

Can anyone help?

Steve
Harrisburg, PA

[June7]

This worked for me, note the = sign:

ado_rs.Sort = "ElementNameToBeSorted desc, ElementNameOfOtherToBeSorted asc"

[SteveApa]

This worked for me, note the = sign:

ado_rs.Sort = "ElementNameToBeSorted desc, ElementNameOfOtherToBeSorted asc"

I tried that and I get error message
"Run-time error '3251':
Current provider does not support the necessary interfaces for sorting or filtering."

I am windows 10 64bit, Microsoft® Access® for Microsoft 365 MSO (16.0.14326.20702) 32-bit

[June7]

Sorry, can't help with Office365.

My actual VBA is: rst.Sort = "FAAID DESC"
I assumed you have actual field names in place of ElementNameToBeSorted and ElementNameOfOtherToBeSorted.

[pbaldy]

Haven't used it myself, but I see this in the documentation: "This property requires the CursorLocation property to be set to adUseClient." Is that the case?

[June7]

Good point. Yes, it does make a difference.

Perhaps OP should give us their actual code.