Search results

Thank you so much Pat! This has given me a whole new perspective to work with. Sorry for the slow reply.

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 you're suggesting for the forms themselves. The user security level isn't the same for all of my forms, but there are groups of forms that could use the same code...

My apologies...To clarify per your previous response: All of my form fields are unlocked by default. OnCurrent, my code loops through the form fields and locks all of them, then unlocks one specific field by name, then based on higher level user security level, unlocks the fields that have the...

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 the fields to remain unlocked so I didn't have to apply tags to all of my controls (there's a lot). Lastly I commented out the command button portion for later...

Your solution worked great for me! I know that it doesn't matter if the auto number is sequential, but if/when we use our "Clear Form" button it still burns a number and we just don't want that. This was the easiest solution for our troubles.

Here it is 2022, and you saved my day. Thanks!

I changed it to 'acCmdWindowHide = False' in that line and it resolved :rolleyes: As I said... Learning as I go.

Here's the error: If I click the exit command, the ribbon and navpane unhide. For anyone else, it exits the application. I replaced with 'acCmdWindowUnhide' and get this error on execution, though it still performs the desired function. *starts pulling out hair*

My code is below. I have tried to use 'Option Explicit' in this code and it basically kills the switchboard. Not sure why. I do have it on my other objects though. Some items are the same as your code (albeit in different places), but a lot is set up differently. Would I need to mirror your code...

I'm no expert, but I've been learning as I go for 3+ years (with still lots to learn). The current switchboard code I have was outsourced. I am able to modify one or two spots, but the rest I'm essentially afraid to mess with.

Thanks again Pat! After review, your set up is indeed what I am looking for, just more complex than I'd like Hahaha. It will take me some time to implement it (translating is slow work) but I'm sure I'll get it. Permission to come to you with any questions?

Pat, thanks again! After review, this is indeed what I am looking for, just more complex than I'd like Hahaha. It will take me some time to implement it (translating is slow work) but I'm sure I'll get it. Permission to come to you with any questions?

Thanks for your reply Pat! Not sure why, but it wouldn't let me reply to your post. I have other databases that run off of a "one form for everyone" type of method, but I really struggled with the coding when I had to make some forms read only for only some users. I'm looking at the link you...

I want the user to access the "Programs" switchboard menu. If it was just opening a form or report, I'd have no problem, but i don't know how to code "let them access the menu item they clicked on" Lol

Haha, yes, that's the code that I'm asking for help with. I think an If statement is the easiest way to do it, but I don't know how to code the action if the user has Level 2 security. If txtUserSecurity = 2 Then **This is the line I don't know how to code. Else (this code is fine) MsgBox...

Hi! To answer your question: I have a "Personnel" table that includes "UserLogin" & "UserSecurity" fields. I have no issues with the code that pulls the info when the database loads the Switchboard form. My trouble is how to code the first part of the "If" action when the button is...

I hope I'm understanding your question... Users are identified in the "Personnel" table with either 1, 2, or 3 security level and the switchboard pulls the Global Username and the Security Level when it opens. When a user clicks the "Programs" button in the Switchboard, I want it to check...

Long story short...Users do not want to manually login to databases, but some objects need to be limited to a handful of users. I created double the amount of forms to ensure those without explicit access could only View data. In this particular DB, it was easier to break it up this way. I...

Hi to all! Northeastern USA, Quality Analyst, self-taught Access Database administrator at a manufacturing company for the past 5 years (3 yrs as the DB Admin). I really enjoy the puzzle of coding in Access, mostly when I figure something out and it works properly LOL. Much of my self-teaching...