Search results

Well I got around the issue by adding: Me.LabInputForm.SetFocus Right after "Case 3" and before the calls to visible or not Don't know if that was the right way but it worked

Well it almost worked. As I started testing: I logged in as user1 (admin) and all tabs showed. I logged in as user2 (Visual Inspector) and the proper tabs showed. I logged in as user3 (Lab Tester) and I got a run-time error "2165" "You can't hide a control that has the focus". highlighted this...

So I just got it to work with this code on my main form (frm_home): Option Compare Database Private Sub Form_Open(Cancel As Integer) If Credentials.AccessLvlID <> 1 And Credentials.AccessLvlID <> 2 And Credentials.AccessLvlID <> 3 And Credentials.AccessLvlID <> 4 And Credentials.AccessLvlID...

So if I login with this code in the login form: Private Sub Command1_Click() If IsNull(Me.txtLoginID) Then MsgBox "Please Enter Login", vbInformation, "Need ID" Me.txtLoginID.SetFocus ElseIf IsNull(Me.txtPassword) Then MsgBox "Please Enter Password"...

Well I cant figure it out with my very limited coding brain.

I changed the codes that you mentioned. I have attached a copy of the database if that helps to determine how to get the tabs to show. and by the way... I can't thank everyone enough for helping me and putting up with my ignorance. to log into the database the usernames are user1, user2 etc...

So... my database recognizes who just logged in shown by the login code I posted in post #9. From post #1 I showed the login form code I had previously which directed users to individual navigation forms based on their AccessLvlID. I don't allow users to choose their "roles" e.g. visual...

After trying that code... no matter who logs in... the only page visible is 5

I am looking into this right now to see how it works. I am a bit confused about 1 thing... The last sub... I do not understand what this is... I do not have any combo boxes related to opening forms... what is that for?

I did move the code that was in the form open event that shows or hides the tabs... but by moving it to the form load even it made the error trying to open the form after logging in. I believe the form is not knowing about the Credentials thing.

I tried that but it pops the run-time error 2501 OpenForm action was canceled and it highlighted this line in my login form code: DoCmd.OpenForm "frm_home"

I understand. I have been trying to implement solutions suggested. I now have my login form (frm_loginform) working and recognizing who is logged in with this code: Private Sub Command1_Click() If IsNull(Me.txtLoginID) Then MsgBox "Please Enter Login", vbInformation, "Need ID"...

That is definately the desired configuration but i am realizing I have to strip all of my existing code and start over and I have been struggling with the login form code.

Ugh... I think I will stick with the navigation forms... it works Thanks guys for the input

I am pretty lost on this one as I know very little about tabbed controls since the navigation form option was easy enough. Been reading so much I don't know what to think anymore.

Through other threads of asking and receiving help on my database it was suggested that I ditch the navigation form layout and go with tabbed controls. I was finally able to figure out how to get all of the forms in the tabbed control and them function correctly. I was being stupid and was...

Any time someone tells me they KNOW they typed their password correct but it didnt work... the db won't let them in because they always didn't type it in correctly or they forgot it. I know for sure because I used to be the one that had to go in and check if they remembered it correctly or not...

I understand a bit more about what you were saying now. I have noticed that if you sit idle in the front end for a while, the little locked icon in the folder where the back-end is located that shows someone is in the database will go away and will come back again when you start doing something...

I have attached a copy of my database with most of the data stripped and converted all of the tables to local. The first 7 records were the ones where I noticed the zero's for the userid in the LabInspectorUserID field of the tbl_auditdata. They do not reflect that now because I changed their...

My relationships window only contains relations for the navigation but here it is