Prompt For Password And Username Each Time While Pressing Cmd Button
Jan 23, 2007
Being dealing with my database and having quite some trouble with it. Is it possible to track down what the users did, during the time they login into, database, is it possible to prompt users for password and username when they buttons for like, delete cmd, or update command.
Just a breif idea on what im trying to do.(hopefully it won't confused you all)
Im trying to created a 2 main username. One is for admin group and another is for users group. Then users can login in to database, however whenever the users update or delete entries in the database, the user will prompt for their username and password (not the users group login ). Is it possible to build a table to store in the username and password for the prompting purposes one.
Sorry for confusing question. Actually im trying to think of another way, but for now this complicated event all i have think of. Feel free to voice your suggestion here. Thanks alot. TQ
View Replies
ADVERTISEMENT
Jan 20, 2014
I would like to ask how can i validate the username and password in a textbox? I have a frmLogin and frmMain.
I have also a table called 'tblUsers' with column fields 'username and password'.
If username is not found in database then a msgbox will prompt 'Username is not yet created'.
If username is okay and password is incorrect then msgbox will prompt 'Incorrect password'
If username and password is okay, then a msgbox will prompt 'Successfully login' and will continue to frmMain.
View 3 Replies
View Related
Mar 24, 2015
I have a form in which I collect approvals from two different departments. To approve an item the user selects their name from a combobox, and then tick an option box to indicate approval. The combobox is from table 'Users' and has a query as a source with the following fields, 'UserNum, First, Last, Password'. The 'approval' fields are on table 'Approvals' and are yes/no fields.
What I'd like to have happen is that the user chooses their name from the combobox and then ticks the option box for approval; when ticked I would like a messagebox to appear asking for the users password based on the name chosen in the combobox.
Is this even possible?
View 6 Replies
View Related
Sep 26, 2004
I created a password for my database and now I cannot access it. The dialog box says that either the username or password may be incorrect. I do not know what the requested username is. I do not recall creating a username during the process of creating the password. I do not know what username ACCESS is asking for. I think I know what the password is. I think the problem is the username. However, if I somehow do not know the password, what can I do?
After you finish laughing at me, please help. Thanks for any assistance you can provide.
View 1 Replies
View Related
Aug 10, 2006
I want to secure my Access database with a username and password. I want to be able to pull the nt login of the user and have them access only the things i need them to access. How can I do this?
View 4 Replies
View Related
Sep 25, 2007
Hi,
i have an access db which i want to protect with various usernames & passwords how do i go about this?
View 3 Replies
View Related
Jan 10, 2007
Hello!
I have a problem regarding using usernames and passwords to restrict access to certain tables/forms/reports etc....
I have read around the forum and various other websites but cant seem to get much relating to exactly what i am wanting to do.
I think i understand the way the access workgroup security works. But does this not just restrict users being able to view the database as read-only or with other certain rights like that? So, firstly would i be able to use this to restrict the database the way i want?
Or is there a way to create a table with names and passwords and create a form at the beginning where the user inputs their details and then according to the details gives/restricts access to parts of the database? Ideally i'd like the startup form to direct them to a different menu according to the user which gives them only the options they are allowed?
Seems a bit of a mouthfull and i sound like a complete newb but i been trying to figure this out all day!!
Thanks
View 2 Replies
View Related
Jun 23, 2006
I created security using the security wizards, separating admins vs. data entry users. I gave everyone a username and a password but when I reenter the database it doesn't ask me for my username or password. Does anyone know why or how can I fix it?
View 2 Replies
View Related
Sep 17, 2004
Hello,
I was wondering if it were possible to make a msg box pop up when opening a database asking for a user name and password. And that will be the only way to enter the database.
Thanks
View 2 Replies
View Related
Nov 2, 2014
I have an error message or debug message in my code in username & password log in.. it has an error in if else statement
empname is a cobobox
empass is a txtbox
logempID is a autonum I.D
usrnmpass is a table name
there's an specific record in a table of usrnmpass showing in the attachment
this is my code....
Private Sub Command1_Click()
If IsNull(empname) Or empname = "" Then
MsgBox "You must enter a User Name.", vbOKOnly, "Required Data"
empname.SetFocus
Exit Sub
End If
[code]....
View 14 Replies
View Related
Oct 19, 2014
I want to create a user name and password in to access my data base
View 3 Replies
View Related
Sep 13, 2006
Hi Freinds,
After viewing all the threads i got some useful information but just wanted some help as i am not a programmer but can understand logics. There are 2 issues i want to resolve
1. First query is i have a login form and in a table there is username password. Now issue is based on the username person should be able to view things. There would be 6 differrent departments. So i would have six users and 1 id only for viewing. These six users should be able to see there own records either assigned to them or create new query and assign to any other 5 users. Now option is either I create six replicated forms and based on the user login i open user form or switch board. Can there be any option where in a table i store the activities they can do and whereever these guys go the code check in table and enable or disable the view of items for other guys. Users would be accessing forms, reports and they would have option of entering cusotmer information and querying and changing information. The user which has option of viewing reports will only have option of seeing some customized reports.
2. Second query is that these six users would be addressing issues to each other regarding cusotmer issue. In this every response of the case should be stored in a table. i.e. like for customer x user1 said abc on 10th then user2 said cbf on 11th. so this would have history of case what was happeining in the matter.
I dont know how to go about this and if there is a easy solution. I dont want to use access security cause then all the six users would have security file.
Would apreciate your help and till now whatever responses i have seen in other forms they were quite helpful and did help me lot in understanding access.
Thanks to all who would be visiting this thread and taking pain in answering the query.
Take care
Ankur
View 3 Replies
View Related
Apr 8, 2014
I would like to implement a login form to my DB.
I have a table db-users with three fields: empID; empName; empPassword
I have a form with an unbound combo box: cmbdbUserName
And I have a text box: txtPassword where the user will type in their password.
cmdDBLogin is the button I want to add the VBA code to on click.
Code that will compare the inputs of the two objects listed above to the data in the table fields listed above that?
View 11 Replies
View Related
Jan 15, 2015
How to make a form that must Check the username and password of a user, in case if they are true then let the user to visit other forms and Tables...
View 1 Replies
View Related
Jul 25, 2013
i have a password logon form, after the user enters his password he then has to click on the button to validate and move to the next form.i have been asked to set this so that the user only has to hit enter on the keyboard to do this.
View 5 Replies
View Related
Nov 7, 2005
I have a form which contains several controls and a listbox. I have set the Default setting to yes for a command button that returns the results of the search, so when i click the Enter key on any control (with the exception of other command buttons), the result is returned.
Question: I want to prevent the Default command button from activating when pressing Enter from the listbox.
I thought of using the KeyDown event with this code
If KeyCode = vbKeyReturn Then
'do something
End If
but i can't get it to disregard the default
Suggestions?
Scott
View 1 Replies
View Related
Nov 16, 2014
I have a button that when I press it it goes to new screen where I can add new data in, and then save it.I have 10 texboxes in this form, how can I when press the button to add data let it on 3 texboxes show info eg. 4321MAG01- and when I am on the new form I can change or add to it. eg 4321MAG01-123
View 6 Replies
View Related
Mar 11, 2015
I've created a form including a text field and a search button - and have added a separate/specific filter button as well as a "New Record" button - but now when I press enter twice in the text field it opens a the New Record form.
View 3 Replies
View Related
Jun 29, 2012
So I have created this database for a lessons learnt system. Is it possible in Access 2007 to create a button that if pressed automatically sends an email out to someone? So my main form in the database is a split form which contains a search filter, which works well and also contains a button called add new lesson. This button is linked into another form and when pressed brings up this new form. In this form it has a save and close button. What I actually would like is when the form is updated and this save and close button is pressed, an email is sent to a "project head" who has to confirms the information before the data is saved into the database. Is this actually possible?
View 1 Replies
View Related
Oct 6, 2005
Hi there,
I am stuck for over a week now, and tried just about everything I am capable off ...
I have two forms: COMP (where I fill in fields for Company Table) and PERS (where I fill in fields for Person Table).
On the COMP-Form I have a button, named: 'Add Person/Employee to Current Company'.
The two tables (Company and Person) are linked by PK - FK (PK_CompanyID & FK_EmployedAtID).
I can't get it to work properly.
The PERS-form must be filled with the company info I filled in the form COMP, after I press the button.
But the PERS-form also must be filled out normally (not via COMP, but seperately), choosing the company in the comboboxfield 'Company Name' on the PERS-form. Do you stick with me?
So I want to start the PERS-form with the filled in company Info by pressing the button.
And I want to be able to start the Form seperately (which I can off course) and choose the company myself , by selecting the right company in the combobox.
I have a attachment sent with this.
Can someone look at this for me, and explain what I am doing wrong.
I tried to do it with a autofill macro, and with some code ...
I just don't seem to get it right.
Thanx in advance for all the help,
Quinten
View 1 Replies
View Related
Apr 9, 2014
How can I add a new line of record below a previous record after pressing the add button? I have attached a picture of my project.
View 3 Replies
View Related
Nov 20, 2014
I added several records in another table but it wont show the records until I press the Refresh button at the ribbon of Home-> Refresh. How can i view the records automatically without pressing the Refresh button?
View 2 Replies
View Related
Aug 21, 2013
I have a form (Pipeline) with an on load event that automatically directs the user to a new empty record.
Code:
Private Sub Form_Load()
DoCmd.GoToRecord , , acNewRec
End Sub
Now my problem is that I am trying to design a 'search form' that will allow the user to look up a specific record in the main form by pressing a command button. Creating the search form is easy enough. I cannot figure out how to override the on load event in the main form when pressing the command button.
As it is right now, the button opens the form and then go directly to a new record.
View 5 Replies
View Related
Nov 19, 2013
I do not have a split db. I am prompted to enter my password when the db opens which is fine. However, when I close the db it prompts me to enter a password (not normal) and when I enter it it says invalid password. Also, when I try to change my password it says invalid password and when I try to compact and repair my db it say invalid password.
View 1 Replies
View Related
Feb 22, 2015
This code puts pdf reports into a folder . I am prompted for a number via the query I run because I have more than one report the query asks me 3 times. Could this be modified so I only get prompted once for all the reports in the code
On Error GoTo Err_Handler
Const FOLDER_EXISTS = 75
Const MESSAGE_TEXT1 = "No current invoice."
Const MESSAGE_TEXT2 = "No folder set for storing PDF files."
Dim strFullPath As String
[Code] .....
View 6 Replies
View Related
Feb 6, 2008
I have a field that is a Date Time field (mm/dd/yyyy hh:mm:ss) and I would like to prompt the user for a begining date range and ending date range. I know how to prompt the user, but I would like for them to only key in the Date portion and not the time. Can anyone offer any suggestions on how to handle this? Thanks
View 1 Replies
View Related
