Sorting data in a form by clicking on the header

[MsLady]

Is there a way to sort data in a form by clicking on a corresponding control (e.g. label/txtbox) in the FormHeader?

 

[ShaneMan]

Is there a way to sort data in a form by clicking on a corresponding control (e.g. label/txtbox) in the FormHeader?

Hey MsLady,

You could give this a try. I haven't myself but have heard several folks brag on it. Follow the link below:

http://www.utteraccess.com/forums/s...re=&Zu=&Zd=l&Zn=&Zt=1&Zs=a&Zy=#Post506705&Zp=

HTH,
Shane

 

[CEH]

I usually create a custom toolbar. For example include "Find","filter by selection", "remove filter", "sort ascending", "sort descending".
This way you do not have to add it to every form, and it can be used by every form.
You can easily put a command button with the wizard, pick form operation, apply filter. Then you would need to write your code for your filter.
But much easier to let Access do the work for you from a custom toolbar.

 

[MsLady]

Hey MsLady,

You could give this a try. I haven't myself but have heard several folks brag on it. Follow the link below:

http://www.utteraccess.com/forums/s...re=&Zu=&Zd=l&Zn=&Zt=1&Zs=a&Zy=#Post506705&Zp=

HTH,
Shane

Great! Thanks Shane!

 

[MsLady]

I usually create a custom toolbar. For example include "Find","filter by selection", "remove filter", "sort ascending", "sort descending".
This way you do not have to add it to every form, and it can be used by every form.
You can easily put a command button with the wizard, pick form operation, apply filter. Then you would need to write your code for your filter.
But much easier to let Access do the work for you from a custom toolbar.

Hi there
Thanks alot. Sounds interesting. never thought of it. I'll give it a shot

 

[ShaneMan]

Great! Thanks Shane!

Your welcome. Hope it works out for you.!

Shane