avincent61's latest activity
-
avincent61 replied to the thread Need to lock all fields except the search box.Thank you so much Pat! This has given me a whole new perspective to work with. Sorry for the slow reply. -
avincent61 reacted to Pat Hartman's post in the thread Need to lock all fields except the search box with
Like.
It isn't too late to change;) Using the group concept going forward makes maintenance much easier. I also assign a group to a form... -
avincent61 replied to the thread Need to lock all fields except the search box.Considering I use public codes in my modules that check users security level, I'm disappointed that I didn't think to go the route...
-
avincent61 replied to the thread Need to lock all fields except the search box.My apologies...To clarify per your previous response: All of my form fields are unlocked by default. OnCurrent, my code loops through...
-
avincent61 reacted to Pat Hartman's post in the thread Need to lock all fields except the search box with Like.
You're welcome. I'm glad you found it useful. You need to review the logic again. The ONLY controls that require a Tag are those that...
-
avincent61 replied to the thread Need to lock all fields except the search box.This was absolutely perfect for my application! I only used the "'lock" portion of the Private Sub. In the Public Sub, I used Case"" for...
-
avincent61 reacted to Pat Hartman's post in the thread Need to lock all fields except the search box with Like.
To clarify, The code I posted there shows how to use a user's security level to lock/unlock the controls. It differs from Uncle's...
-
avincent61 reacted to Pat Hartman's post in the thread Need to lock all fields except the search box with Love.
This is the code I use when I want everything on the same form. Since my apps have security, I check it in the form's current event and...