sorting datasheets

[303factory]

Hi

My application has the main Access window hidden wth ShowWindow(Application.hWndAccessApp, SW_HIDE)

The problem is that in datasheet view the user cannot sort the results by any particular field because the right click menu is disabled.

Is there any way to allow sorting of datasheets with the main access windows hidden?

Thanks

Dan

 

[pl456]

I would sort the data in the query, its not dynamic to the users but at least puts a predefined order to the results

 

[303factory]

I would sort the data in the query, its not dynamic to the users but at least puts a predefined order to the results

I was considering doing it that way.. however there are about 20 forms, each one with about 10 different fields.. it's going to take aaages to set up the buttons and code to let the user sort by any field ascending or descending.. it would be a lot easier if there was an easy way to switch on the right-click menu..

Dan

 

[pl456]

you could try and create a custom menu, you may not need as much code.

this link looks pretty helpfull.

http://www.jamiessoftware.tk/articles/menubars.html

 

[303factory]

you could try and create a custom menu, you may not need as much code.

this link looks pretty helpfull.

http://www.jamiessoftware.tk/articles/menubars.html

I'm a little confused here. I've used these instructions to create a custom menu, and set it in the Other/Toolbars property of the form, and yet it doesnt appear whent he form loads. How would I decide where on the form it appears etc? The only place I can actually see the toolbar is in the main access application, which as I've already mentioned, is hidden while my application is running..

Tried lots of tutorials on the web about this but they only go as far as creating the toolbar, not putting it in a form

If anyone's got any further pointers that would be appreciated.

303

 

[pl456]

You make it your main menu, you disabale the main access menu and replace it with you custom one. I don't think you can set it up specifically for the form using this method but it will always be available for all forms.

I stand to be corrected and could be missing the point.

 

[303factory]

You make it your main menu, you disabale the main access menu and replace it with you custom one. I don't think you can set it up specifically for the form using this method but it will always be available for all forms.

I stand to be corrected and could be missing the point.

I see, so given that the access window is hidden when my application is running this custom made menu is no good to me.. ah well worth a shot tho thanks peeps ill just set some time aside to create lots of buttons that sort queries.

303

 

[pl456]

you can turn all of them off and display only the menus you wish, although you can turn database & web back on if your right click in the menu bar.