treeview sort

[meydeydat]

There is a treeview example with access

It's very useful. But ordered is in the table of "sections", "SectionPath" column is ordered.

But I would like to order is in the table of "sections", on "Sira" column.



I caouldn't do it. Waiting for your help.
Thank you for interested.

(I am sorry, for bad english)

 

[jdraw]

This is the current recordsource of the Form

SELECT 
BuildKey(SectionID) AS NodeKey
, BuildKey(BelongsTo) AS ParentNode
, Sections.*
FROM Sections
WHERE (((Sections.[SectionID])=63));

What do you want exactly?

 

[meydeydat]

I want to sort.

But I would like to sort in the table of "sections", with "Sira" column.

 

[jdraw]

What have you tried?
Whose data is in the table? Is this your data or something from a sample you found?

We can't help you if we don't know more about your environment, your requirements and the database.

What will sort do with the treenodes, if anything?

You can sort your table by Sira, and try the form. Readers have no idea of your real requirements.

If necessary, write something in your own language, then use Google translate to English -- if that is easier.

 

[meydeydat]

I want to to sort "Sira" coloumn. İn Treeview.
Dont order by "SectionPath"

I Want to ORDER BY "Sira"

(I dont speak english. I use google translate. I am sorry.)

 

[jdraw]

I have no idea what the output should be. I can change the sort, reorder the table, but I would not know if that is what you are looking for.

Did you try to sort by Sira?
What is your native language? -- perhaps another forum member can help you.

Can you show us what nodes(hierarchy) you want, if that is the issue?
_________________

Ben çıkış ne olması gerektiği hiçbir fikrim yok. Ben, tür değiştirme tabloyu yeniden düzenlemek, ama bu sizin için ne arıyorsanız eğer ben bilemeyiz olabilir.

Eğer Sira tarafından sıralamak denedin mi?
Anadil nedir? - Belki başka bir forum üyesi size yardımcı olabilir.

Bu sorun olup olmadığını, ne istediğinizi düğümler (hiyerarşi) bize gösterebilir misin?

 

[meydeydat]

I want to sort by Sira.
I want to sort the TreeView by "Sira" column.
But I couldn't.

(I am Türkish)

 

[pbaldy]

I am posting this for a user trying to help but unable to post:

Hello Meydeydat,

I believe this is what you may be looking for:

http://i.imgur.com/KN0C58E.jpg

Which results in the following:

http://i.imgur.com/vpPpGYO.jpg

I added the Sira field to the query and specified that it should be sorted in ascending order (you could sort in descending order, of course), and when I ran the query, it sorted all the records according to the Sira field value, which is what I understand you were hoping to achieve?

 

[meydeydat]

I do not care about the ordering of records in the table.
I want to sort nodes in Treview.
I want to sort the TreeView by "Sira" column.

Treview get sorted as in the example.

example

Root: Headquarters
Node 1. = Finance/Administration
Node 2. = YIL
Node 3. = Logistics
Node 4. = Human Resources
Node 5. = Global Relations
.........
....

 

[N1755L]

Hello again Meydeydat,

Well I was WAY OFF about what you were after, but I've already found an answer for you:

Search on YouTube for the following, from a user by the name of TheSmileyCoder:

Treeview in MS Access: Part 1 - The basics, loading information into the treeview


I'm not sure if you will be able to follow the information contained within that video, since you're not a native English speaker, but if you can get someone to help you translate, all the information you require to accomplish your task is here, this time I'm fairly certain.

Good luck.