Permissions alphabetical order

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I open the permissions dialog box, Tables and Queries are shown in
alphabetical order, but Forms, and Macros are not. Now that I have hundreds
of Forms and Macros, searching to assign permissions is a chore. Can I sort
these alphabetically?
 
When I open the permissions dialog box, Tables and Queries are shown in
alphabetical order, but Forms, and Macros are not. Now that I have hundreds
of Forms and Macros, searching to assign permissions is a chore. Can I sort
these alphabetically?

This has been an annoyance for me as well, and if anyone has a
solution I'd love to hear it!

The getaround I've found is that if you select the form in the Forms
window, and *then* choose Tools... Security... User and Group
Permissions, the selected form will *usually* (not always) be selected
in the dropdown as well.

John W. Vinson[MVP]
 
John Vinson said:
This has been an annoyance for me as well, and if anyone has a
solution I'd love to hear it!

The getaround I've found is that if you select the form in the Forms
window, and *then* choose Tools... Security... User and Group
Permissions, the selected form will *usually* (not always) be selected
in the dropdown as well.


Usually? Interesting John, as that has always worked for me. Have you
noticed a pattern as to when it doesn't?
 
Usually? Interesting John, as that has always worked for me. Have you
noticed a pattern as to when it doesn't?

Usually when I'm in a hurry and the Citrix connection is slow... and
browsing the list of forms takes three minutes or more... :-{/

I may have not actually selected the form the few times that it seemed
to have failed.

John W. Vinson[MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Alphabetical table 3
sort alphabetical in report 4
record sorting 3
Update combo box 2
How can I change the column order using VBA 5
Auto Sort 1
Sorting Month-Year in Query 7
Sort with Combo box 2

Back
Top