Sort Datasheet View with Menu AZ item

  • Thread starter Thread starter Gary via AccessMonster.com
  • Start date Start date
G

Gary via AccessMonster.com

Hi,
Is it possible to sort in datasheet view using the menu icons of
ascending/descending on the menu. This would be similar to how excel would
function by highlighting the column in datasheets view and then click on the
ascending icon on the menu to sort the column ascending or descending??

If so, how would I code the icon on the menu bar? I've copied the icon to
the menu bar but I think I need to add the functionality to the module.

Thanks,
Gary
 
Hi Gary
Use the on click event. Say the field you want to sort is a text box called
txtName, use the following

Me![txtName].SetFocus
DoCmd.RunCommand acCmdSortAscending
 
Thanks! I'm using the onclick and on doubleclick to toggle between ascending
and descending of each column.

Thanks again!
Gary
Hi Gary
Use the on click event. Say the field you want to sort is a text box called
txtName, use the following

Me![txtName].SetFocus
DoCmd.RunCommand acCmdSortAscending
Hi,
Is it possible to sort in datasheet view using the menu icons of
Click to expand...
[quoted text clipped - 7 lines]
Thanks,
Gary
Click to expand...
Click to expand...
 
Back
Top