sort by headers - question

[battenberg]

How would I go about creating a datasheet style form with 'sort by' headers

for example:

I could create a form with a list box sorted by 'name' by default. If i wanted the same data to appear but sorted by 'Address' or 'Phone Number' how would I go about this?

Many databases give a datasheet view of the data where you can sort by clicking the appropriate header... how could this be achieved in access?

any hints or suggestions welcomed?

 

[CEH]

I have found a customized toolbar to do the trick...... I add the "Find binoculars", the AtoZ, ZtoA, a "Filter by Selection" icon and of course a "Remove Filter" icon. Having it as a toolbar comes in handy.... You can use it on any form.

 

[pbaldy]

Another option would be buttons or labels along the top. Clicking on each would reset the source of the listbox, with the appropriate sorting.

 

[battenberg]

It seems like access does not have this functionality built in? maybe something for the next version...

 

[dan1dyoung]

battenberg,

Would something like attached not do as suggested by Paul

Thanks

Dan

 

[battenberg]

Dan,

Thankyou for your reply,

The way I eventually did it was as suggested by Paul and the same as your sample database.

Thankyou for your time and effort to write this sample, I hope it helps many people in the future.

What would be cool are headers that could dynamicaly resize the width of the column!

Rgds
Bat

 

[dan1dyoung]

Bat,

Would be great, maybe they have done something in access 2007??

Will have a look myself as i would like some other things that Alpha, filemaker, 4d, e.t.c do but access does not, but there are things i can do in access that i can not do in any of them so access with more functions is best!!

Thanks

Dan

 

[battenberg]

I found a sample database that allows you to resize on the fly... not yet tried it out yet...

http://www.access-programmers.co.uk/forums/showthread.php?t=112753

will try to implement this when i get time...

 

[dan1dyoung]

Bat,

Looks good, just posted here to try see if someone can see how to resize the label/button aswell, as i am not having much luck yet.

Dan