where I can find VBA for (Tracking User LogIn/LogOut) I have tried researching to no avail.I just need a simple code to track users logging date & time in and out of my DB.When they click on the icon on the desktop id opens the DB to login screen with username & password then into the DB.
View RepliesHi.. Been trying to work this out for a little while now. I run an IT workshop for adults with learning issues and although my other office skils are pretty good, my Access skills are a little lacking.
My clients login and out on paper at the moment but I would like to change this to a database type system. The entries would only be name and an automatic one to record actual time of login.
Can anybody help me with the automatic entries?
Many thanks
Hoodlums
Hi,
I want to make database only for time spent in office. In that database i want people to login and when they finish there work press logout. The table would consist nt username, time logged in and time logged out. This would enable time spent at work. When the person presses login it would stamp the time on the table along with the username.In this only check i want to enable is if the person presses login again then it says already logged in press logout. So no duplicate entrys in the database unless person first logs in and then logs out. I want to enable check before entering the data in the table. Attached is the database for further analysis. Please advise.
Thanks and Regards
Ankur
hi,
i've completed the whole access DB, but now i need to implement the login form, so each user can access their data + admin access.
what is the simples/fastes way to do this, since i've got working db. I add fields (user-log-id and password)to "userTable" and now i just need simple veryfication to login and logout.
thank you in advance,
t.
I am using this [URL] .... in our project but have made a minor change so it logs people out rather than close Access completely. It works beautifully but I want to take it a step further.
Instead of hardcoding the times in these two values
intMinutesUntilShutDown = 10
intMinutesWarningAppears = 2
I'd like to give users the options to set these themselves as not everyone will be the same. I am thinking I would have to check for who is currently using the database, this is stored in a hidden form in the following field.
[Forms]![frmwhoson]![whoson]
This username matches the users First Name in table Employees and in this table I have two fields to store these values
logmeoutafter
showlogoutmessagefor
So passing these values for the current user rather than having the logout times hardcoded.
I have recently started a project and become stuck already. I have a login form created that works (code below). What i want to do is allow access to the users of 1-7 in table (level of access) which will determine which page they view after logging in. IE if the have Access in table "Users" as "1" then when they log in the will see a form thats called L1. Same with 2,3,4,5,6 & 7.
Code:
Private Sub LoginButton_Click()
If IsNull(Me.LoginUsernameText) Then
MsgBox "Please Enter Username", vbInformation, "Username Required"
[Code].....
I have been trying to create a login form that allows the user to change his/her temporary password logging it to the proper table along with timestamp and who done it info.But, after spending the morning trying to find the proper syntax I am flummoxed.
I can get everything to work accept the update of the fields. I can get the command to work (writes to the location) but it does the pop-up what is the parameter thing when it works. I have all the information just need to get it in so the command recognizes it.
DoCmd.SetWarnings False
DoCmd.RunSQL "UPDATE lut_TeamList SET Pass = txt_Password.value WHERE TeamListID = Me.cbo_UserName.Value"
DoCmd.RunSQL "UPDATE lut_TeamList SET UpdatedBy = Me.cbo_UserName.Value WHERE TeamListID = Me.cbo_UserName.Value"
DoCmd.RunSQL "UPDATE lut_TeamList SET UpdatedWhen = Now() WHERE TeamListID = Me.cbo_UserName.Value
DoCmd.SetWarnings True
Access2007
At this point, FE db has 4 linked tables, 3 are located in FileBE1, and the 4th is located in FileBE2.
The production BE is located on a server, the test (when working remotely) is on a local computer that is not able to connect to the server. Also, the test BE files (but not the table names) have different names than the production.
I have the idea of creating a table in the Front End that contains a list of users, filename and location (server or local drive).
Upon startup, how could I set up the vba to check the links and if they need to be changed will go and change them without the user having to click on link table manager or be prompted for names and path.
For now, I envision three rows in the table, one for the test user, one for local user and a default UNC for everyone else. (or would it be six rows since there are two files that need link checking and relinking).
I want to track how many orders a user makes. So every time they place an order it increments 1 after each order.
I currently have the following tables,
Order
OrderDetail
User
Should i create an UserOrderHistory table?
Eventually i want this information to form part of an order number. eg
196(order primary key) AR (UsersInitials) /23 (number of orders User has placed)
I have finished the database application, and now want to make a user login for specific users to run the application (but not to change the internal desgin or data).
How can it be done ?
Do I need to split the database first before doing that ? :confused:
Hi,
I need to capture the windows user name who modifies the data in the form/table, is there a function or command to capture it in access 2007 ?
Thanks for the help
Joy
hi,
i am a new memebr so i want to say hello to everyone, anyways i have created a database in microsoft access and have created a login screen where i have created different users and given them different access rights and permission in using my database, and that all works fine when i log on to the database from where the computer i created all these rights i get a login screen where the user enters the username and pass and then that opens up the database and allows the to view parts of the database which they are allowed to however my problem is this...
it works fine on the computer i created these access using the security (user-level security wizard) feature in microsoft access but when i open the database on a different computer it doesnt bring up a user login screen, meaning it lets anyone access the database etc so what do i do??? please help
regards rix :eek: :confused:
I want to create a database need user login the system at first, i try to use a function to handle the checking, but it return "Type mismatch" & Runtime error "Operation is not allow when the object is closed", i am not sure my code is all right, can anyone help me to find out what the problem in my program?
View 5 Replies View Relatedhey,
can ne1 tell me how to create a User Login form in Access??? i want disply this form 1st, when i open the bd???? i am very new to Access. :)
thanks :) :)
Hello,
I am developing a cylinder tracking system, when i user logs in its necessary to record this action, as when they try to fill a cylinder i need to be able to record that this particular employee has updated the table and by recorindg the user login in i will able to do this.
IS the anyway of being able to record whos logged in?
I Have a table votes where a user is able to vote for a specific campaign, when the user votes his username and the date and time is logged in the table votes.
After the user voted he is logged out, then displaying the login form for the next user.
At the login form I want to check if a user already voted and if so he should not be able to login again. How can you do this ?
I have created a login form, with a user name and password. It works great. However I need to use the login form for three different command buttons, on my main access form. The same login form will be used but It will need to open three different forms depending on what command button was selected on the main page.
Main page- PID
3 command buttons- building, documents, assessments
login form- login
3 documents- build, docs,assess
I open main page, PID- click on buildings the login form pops up and I enter the correct username and password the building doc opens. Got it?? The same process for each, I would like to know how is this possible? How do I change the differnt documet that opends according to the command button that has been pushed? :confused: Thanks in advance
Hi,
Sorry if this has been covered before but I couldn't find a post on it anywhere.
I have a login form but am not sure where to go with it now. I want the "Login" button to look up the username in the table "users" and check the password with the one submitted in the form. After this has been authorised I have also created field "permissions" in the users table and I would like that permission to be assigned to the users session.
Thanks,
Chris Farrants
I'm still working on creating that HR Database. I've successfully created the NEW USER logon. Now I'm stuck on getting the "Returning User" verified during logon.
From a simple form with 2 unbound controls, we ask for the allegedly existing UserID and password. The premise is as follows:
There is a query qry_Employees linked to the form in the background. We're not editing anything directly in the query.
1) To Lookup/goto the record with the EmployeeID in the qry_Employees which matches the UserID on the "Returning User" Form.
2) To Check whether the Password "UserPW" provided on the form is the same as the one in the query "qry_Employees.EmpPW" for that EmployeeID/UserID
3) If its the same then send the user to the main screen and apply a FILTER to the qry_Employees.EmployeeID so that records reated to that one EmployeeID are all that's viewable. The filter is important for Privacy Concerns.
I can't seem to get the UserID isolated and the filter on so that only the User with that unique UserID is browsing the related data in the subforms.
Could anyone help with this one?
Thanks,
Goh
I am trying to create a multi user login form for my Access 2010 database. I will have 2 different types of users (administrator and staff). The administrator will be able to see all tables and forms and edit/ add to them. The staff will only be able to view a switchboard form and 2 forms (as well as using combo boxes to look up specific records). However, I don't want the staff to be able to view the tables or edit anything.
View 3 Replies View RelatedI created a form with an "add record" and "delete record" button. I need to create a simple login form for 2 users (user1 and admin1) that will disable able the "delete record" button when the user, "user1" logs in. Whenever the user, "admin1" logs in, then both "add record" and "delete record" buttons are enabled.
View 7 Replies View RelatedI currently have a network shared database. I setup permissions but only one PC shows a login screen when it starts up. The other just logins to "Admin" account which I have taken permissions away from and therefore cannot make any DB changes.
Any idea how to fhix this?
I want to print different versions of a report depending on on the user login id "quserid" which I have on a login form "authorise".
As a simple example I have tried using a single user with the syntax shown below but get an error message "Object required". I suspect the problem is in the way I identidfied the quserid field. Can anyone please advise me on this.
Regards
Peter
If AUTHORISE.quserid = "ADMIN" Then
Dim stDocName As String
stDocName = "FUNDING CONFIRMATION LETTER"
DoCmd.OpenReport stDocName, acNormal
Exit_PrintConfirmationLetter_Click:
Exit Sub
Err_PrintConfirmationLetter_Click:
MsgBox Err.DESCRIPTION
Resume Exit_PrintConfirmationLetter_Click
End If
Into the form named: Administratorsfrm, I added a textbox defined as usertxt and also a textbox named passwordtxt as well as a button named logincmd.
The user defined is the Network user and this is added automatically to the usertxt field everytime when I open the Administratorsfrm form. To do this I use the next code:
Private Sub Form_Open(Cancel As Integer)
Dim wshNetwork As Object 'New wshNetwork
Set wshNetwork = CreateObject("WScript.Network")
Me.Usertxt = wshNetwork.UserName
Set wshNetwork = Nothing
End Sub
I would like that the user types his/her password (Network password or Unlocking computer) and after this could Login to the database application. I mean, the user will type his password and then the event should compare the password typed with the network password or unlocking password and if this is correct should open the database application (Main Menu Form: Mainfrm)
how to display the user's record or database after he/she login in on the system. Currently I have a database where in the user enters his username and password. But the I dont know how can I make his records display after login.
View 1 Replies View Relatedhi.. i have a database stored on my main computer. all pcs on the network have windows xp.the database is stored in a shared folder.. and at the moment.. everyone on the network can open the database.. but not at the same time..basically if i have the database open.. my colleague on the pc next to me has to wait till i close it.so what i am asking is can someone direct me to a simple tutorial or some reading material..that introduces the methods needed to allow multiple pcs to access a single database with or without a login system.i imagine there will be certain read/write and locking issues.. but i really need it.thanks.
View 9 Replies View Related