Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Disable sorting in datasheet 1
- Thread starter rjurgens
- Start date
Hi
Maybe disabling the right click menus in options ?
Why do you want to disable this, seems like a useful thing to allow users to do ?
Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - UK
Maybe disabling the right click menus in options ?
Why do you want to disable this, seems like a useful thing to allow users to do ?
Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - UK
- Thread starter
- #3
Hi Ken
The reason I do not want them to sort it is because it is based on a time schedule and sort on a hidden keyid field. Since alot of the people in other departments share the same PC, I would hate for someone to sort it by another field, then someone else comes to the PC, sees the next thing on the list performs a function that should be done at the end of the schedule.
I looked in the Options menu, but do not see an option for Right-click anywhere.
Thanks
Robert
The reason I do not want them to sort it is because it is based on a time schedule and sort on a hidden keyid field. Since alot of the people in other departments share the same PC, I would hate for someone to sort it by another field, then someone else comes to the PC, sees the next thing on the list performs a function that should be done at the end of the schedule.
I looked in the Options menu, but do not see an option for Right-click anywhere.
Thanks
Robert
Hi
Sorry, I was thinking of startup options, but I see that you cannot disable the popup sort menu in this way
Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - UK
Sorry, I was thinking of startup options, but I see that you cannot disable the popup sort menu in this way
Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - UK
Robert - am I missing something here? You have a subform based on a table with a sort key that you want to use and hide. Why not just sort the subform by that key and exlude it from the subform. Then no matter what the users do, the next time that form is opened it will resort by the hidden key.
Simon Rouse
Simon Rouse
-
1
- #6
Dr. Simon's method will work. There is also a ShortcutMenu property on every form.
Set that to "No" and there will be no shortcut menu available to the user. You'll also want to deal with the menu up, top, though.
Turning off the menus and creating your own menus is quite a commmon thing to do in Access applications, and allows you to control the user experience much more tightly than leaving the standard menus available at all times.
Jeremy
==
Jeremy Wallace
AlphaBet City Dataworks
Access Databases for Non-Profit Organizations
Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.
Set that to "No" and there will be no shortcut menu available to the user. You'll also want to deal with the menu up, top, though.
Turning off the menus and creating your own menus is quite a commmon thing to do in Access applications, and allows you to control the user experience much more tightly than leaving the standard menus available at all times.
Jeremy
==
Jeremy Wallace
AlphaBet City Dataworks
Access Databases for Non-Profit Organizations
Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.
- Thread starter
- #7
- Status
Similar threads
