vba - how can i get the values in this column to sort according tothe hierarchy?

A

anovak

I'm using this SQL statement to pull in hierarchical custom field
values:

rs.Open "Select MemberFullValue,MemberDescription FROM
MSPLT_Performer_UserView WHERE (MemberValue <> '')", Conn

But I can't use an ORDER BY on this data type (MemberFullValue)

How can I get these values sorted in a combo box as they normally
appear in the hierarchy in Project Server?

I'm very new to this, so specifics would be very welcome! :)

Andy Novak
UNT
 

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

vba - how can i get the values in this column to sort according tothe hierarchy? 3
VBA Compile Error: User-Defined Type Not Defined-Please Help : ) 1
VBA Compile Error: User-Defined Type Not Defined-Please Help : ) 8
VBA: How can I get the type of the control programatically? 9
How can I get Hex values to appear in the Visio color information 1
How can I change all negative values in a column to = 0? 3
Formula in Excel 07 to get the formula used in one cell in anothercell, showing VALUES, not cells re 1
Formula in Excel 07 to get the formula used in one cell in anothercell, showing VALUES, not cells re 2

Top