Search results

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...