Hello,
This question may sound too general and confusing but I am trying to keep it simple.
I have a form that managers log into to view a list of the employees reporting to them. They are linked by the manager number.
I have a command button to open up another form that has a drop down list of possible courses that they may have taken or been assigned to. Once you choose a course from the drop down, it lists all employees...
CanuckChuck
Last Activity: Jun 22 '07, 07:47 PM
Joined: Nov 10 '06
Location:
-
Opening Subforms With Linked Criteria
-
Thank you for your reply. I had actually previously done that, but the option still remained on the top default menu bar....
As I read your post I solved my problem while viewing another discussion thread... I found the code to use for the On Open event of the form. Here it is for anyone else who comes across the same problem:
'To disable the Remove Filter/Sort Option on the Records Menu
CommandBars("Re cords").Control s(4).Enabled... -
Disable Remove Filter Option
Hello,
I have all the necessary security setup for my database. The only problem is once the users have logged in, they can go to the Records Menu and click Remove Filter/Sort and they can view everybody else's records. Is there a way to get rid of this option on the default menu?
Thank you for your comments -
Works like a charm!
Thank you so much Mary for your continued expertise!...Leave a comment:
-
Shift Bypass Enable/Disable Password Protection
I have a code for enabling a command button to password protect the enabling/disabling of the Shift bypass. For some reason though I keep recieving a syntax error when I try to use it. I copied the code from the following link: http://www.databasedev.co.uk/disable_shift_bypass.html It seems to have a problem with the part that reads:
MsgBox "The Bypass Key has been enabled." & vbCrLf & vbLf & _
"The Shift key... -
Thank you for the reply, I was just posting as you were.....and I agree I like as well. I may try the shortcut also, as you can see in my last reply I am having another issue and maybe that will resolve it...Leave a comment:
-
O.K so I fixed the problem. I am not 100% sure how I did it, but it was either because I had not removed the default admin account from the admins group, or because I went in and set it up again from the actual network drive.
Now I have the problem that others seem to have where if I change back to my original Workgroup I can access the database without any security enabled?
It seems there is always something with...Leave a comment:
-
Access 2003 Security On a Network Drive
Hello there,
I have recently followed the steps to creating my secure database as outlined by the following link: http://www.databasedev .co.uk/access_security .html
I have copied the Workgroup information file to the network drive where the database resides and set up the security using the security wizard. Everything works out fine on my workstation. The problem I am having is when someone else from another workstation... -
I am not really sure....I have given up on this code and have since taken the "easy" way out and have just created a command button that opens another form that the employees can click. This other form is linked to the password table, so they can change it right in the table via the form. I don't know if this is a good way to do it, but I guess it works for now?
Thanks for your continued help and patience though Mary....Leave a comment:
-
Hmmmm......I put the End If in and now it gives me a run time error 13 mismatch message and in the debugger highlights the line:
pswd = MsgBox("Please enter a new password", "Change Password")
any ideas??...Leave a comment:
-
Forgive my ignorance, but where would the End If go then?...Leave a comment:
-
Now it executes all the way to the very end, and then there is an error "Block If Without End If" and it highlights the End Sub command, but I can't see where the incongruency in the code is?
Thanks
Charlie...Leave a comment:
-
now the code stops running at this line with the error message: "method or data member not found" and highlights the pswd part. But the message box is not appearing when I enter the default password, and I am under the impression that it should be appearing regardless of the error in the line below as it occurs after the password would be changed?
DoCmd.RunSQL "UPDATE strEmployees SET [EmpPassword]= '" &...Leave a comment:
-
O.K., now I am getting a "Compile error: syntax error" for the line:
pswd = InputBox "Please enter a new password", "Change Password"...Leave a comment:
-
O.K. So, I tried attaching the code to my OnClick event of my command button and I keep getting a Compile Error: syntax error pop up. I also have recieved the message Compile Error: Expected: List Separator or ) when trying to fix it.
I will attach the full code that is attached to my command button
...Code:Private Sub Command14_Click() 'Check to see if data is entered into the UserName combo box
Leave a comment:
-
Thank you for your response. I have tried the code, modifying it to match my data and I can't seem to get it to work.
The username is chosen from a dropdown list named Combo10. My textbox for the password entry is named Text12.
I will attach my modified version of the code so you can see what is wrong with it.
I keep getting a syntax error for the line with the DLookup function, as well I forgot...Leave a comment:
-
Login Forms
Hello,
I will mention that I am a beginner at Access in every sense of the word. I have created a database for all the training records of my employees. I have set up a login form that requires a password linked to the employee table.
My question is how do I create a command button or action that will prompt the login user and enable them to change their password once they have logged in or chosen a user name from...
No activity results to display
Leave a comment: