If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Deactivating order by on a form.
Dear Sir /Madame,
I want to deactivate the order by on form fields (when you press right click on a field you get sort ascending , descending options) because it creates enormous amount of locks on the sql database. There is no property "orderbyon" on the properties screen. I also tried to set in the open form event Me.OrderByOn = false but it did not make any difference I could still sort ascending or descending on any field I wanted. How can I achieve that ? Thank you in advance for your help. P. Scaram |
#2
|
|||
|
|||
Deactivating order by on a form.
Either change the form's Shortcut Menu property to 'No' to disable shortcut
menus, or create a custom shortcut menu with only the commands you want available, and assign the name of that shortcut menu to the 'Shortcut Menu Bar' property. You'll find these properties on the 'Other' tab in the Properties window in form design view. -- Brendan Reynolds Access MVP "P. Scaram" wrote in message ... Dear Sir /Madame, I want to deactivate the order by on form fields (when you press right click on a field you get sort ascending , descending options) because it creates enormous amount of locks on the sql database. There is no property "orderbyon" on the properties screen. I also tried to set in the open form event Me.OrderByOn = false but it did not make any difference I could still sort ascending or descending on any field I wanted. How can I achieve that ? Thank you in advance for your help. P. Scaram |
Thread Tools | |
Display Modes | |
|
|