Update Query For Capturing Log Out Time Of User

May 18, 2006

I have done some searching to find a method for logging & timestamping when users log in and out. I have no problems with capturing the Log IN information my problem lies with the log out portion where I am trying to use a Update query to update when the user logs out of the database:

I can get the update query to do what I want, but for some reason it is creating a duplicate record (exactly the same as the last record updated)

Here is the code I am using:

UPDATE LogInTable SET LogInTable.LogOutTime = Time()
WHERE (((LogInTable.LogOutTime) Is Null) AND ((LogInTable.UserName)=LogUserName()));


Basically I am trying to tell the Query to ONLY update records where the "LogOutTime" is Null AND where the UserName field in the table = the username of the person trying to run the update query.

Please help I can't figure out how to prevent these duplicates. :(

View Replies


ADVERTISEMENT

Capturing User Name From Form Field Entry

Feb 6, 2007

In this db, the users select their name from a dropdown in an auto-open form, but with no password. I want to capture this value for use as the default value in a field on another form, but with the first form closed. I have seen the ENVIRON(Username) function referred to many times on here, but I need to capture the entered value, not the Windows or network login.

Is this possible without leaving the form open? I suppose I could just set its Visible to False when they enter their name, but I try not to have any more windows open than are necessary.

THANKS for your help!!

View 8 Replies View Related

General :: Capturing And Saving User Name Who Created And Updated A Record

Jul 20, 2012

I have taken the Access Tasks template and modified a bit. It now captures and saves the time and date a record is modified. The database is on a network folder and is shared among our team users.What I would like to do next is make it,

1- capture and record on my Tasks table the user name of who created the record by using the fOSUserName() function. I have the table fields "Created by" and the VB code in a module. This would happen only once when the record is created.

I would also like to do this with the machine name for which I have the module too. fOSMachineName()

and,

2- capture and record the user name of who modified a record. For this I also have a field in my task table "Last Modified By" and i hope i can use the same fOSUerNmae() function.

I got to the point where I put an unbounded text box with the =fOSUserName() in it and it does show the user name but how do i get to record to my task table?how the template removes the tasks that are completed from the task list as soon as it is updated to completed? how can I make this happen with a cancelled option after I add it to the drop down list?

View 3 Replies View Related

Query Criteria - Capturing Data In A Certain Format

Mar 19, 2012

in a query, I would like to capture data that is in the following format:

123456 (6 digits) AND
A12345 (1 letter and 5 digits) AND
AB1234 (2 letts and 5 digits)

The letter could only be at the beginning of the abbreviation.

View 1 Replies View Related

Getting User Input For Field And Table On Update Query

Jun 5, 2006

Is there an easy way to get user input like the parameter value box in an update query, where you want the user to specify the table name and field name to run the query on?

View 1 Replies View Related

Queries :: Show Data - Query Based On User Selected Time And Date Range

May 17, 2013

I have a form that request information from the user (StartDate, StartTime, EndDate and EndTime) the problem is that it's not working. The only way I can get any data to show is when I remove the StartTime and EndTime. Only then will it pull the items from the StartDate and EndDate.

Here is what I have as my criteria: Between [Forms]![OpPROD_ALL]![StartTime] And [Forms]![ OpPROD_ALL]![EndTime] And Between [Forms]![ OpPROD_ALL]![StartDate] And [Forms]![ OpPROD_ALL]![EndDate]

The users will be able to request a report based on a start and end date along with a start time and end time.

Side note: this is to pull date for 3rd shift (Example) 4/14/2013 10:00PM - 4/15/2013 10PM

View 1 Replies View Related

How Can I Update A Table Each Time I Run A Query?

Dec 5, 2007

Hello Everyone!

I am new here and this is my first post.

I have a table with two fields: ID and Date. The ID is set to autoincrement. How can I update a table with the next ID and date to current, each time a query is run.

Thanks,
Ket

View 6 Replies View Related

Update And Delete Query Of A Record By Date At The Same Time..

Oct 9, 2006

I have two tables. PreOrder and Order Tables. When our customer actually order a product, I want all information of that product to move from PreOrder table and append it to Order table. Currently, my user has to run an append query to add the record from PreOrder and add it to Order table. After that, she has to run a delete query to delete the record from PreOrder table. Since our query is setup to run by date, and order number..My user has to type the same thing twice. Is there anyone out there know the easy way? Thanks in advance..

View 1 Replies View Related

Queries :: Run Append Query And Update A Field At Same Time

Nov 7, 2013

is possible to run an Append Query and update a field at the sametime?

i.e. I would like the MealDate field to be incremented by 1, just not sure how to write the code within the query!!!

This is what I have so far!!! not working

MealDate: ([MealDate](Date()+1))

View 5 Replies View Related

Queries :: Change Time Portion Of Datetime Field In Update Query?

Sep 12, 2013

I have some incorrect time entries in a column that I need to fix with an update query.

So, 04/11/2013 08:00:00 needs to be changed to 04/11/2013 09:00:00

View 5 Replies View Related

Forms :: Update Time Portion Of Date / Time Field

Aug 29, 2013

I have a date/time text field on a form with the General Date format and a combo box next to it that has sequencial times as the row source (IE. 12:45 AM, 1:00 AM, 1:15 AM, 1:30 AM, ETC.) When the user chooses a time in the combo box, I want the time portion of the text box to be updated with the chosen time in the combo. I have tried a few things but cant seem to get it right.

View 4 Replies View Related

More Than One User At A Time?

Feb 5, 2008

Okay, i need to know if there is a way so that more than one person can be in an access database at one time. Both need to be able to edit, add, delete, etc. within the database.

Is this possible? :confused:

View 12 Replies View Related

First Time User Please Help

Dec 21, 2007

Hi I am a first time access user so i would like you to go easy on me. I work in an export firm where I have to maintain Order Dispatch schedules for different customers with different products. I becomes very difficult as at the moment I am using Excel andd have to maintain different files for each customer. I was hoping if a common base for the same can be created in access so that i am able to input all data pertaining to different customes in a single table and get reports of the same according to my need.

Awaiting for a reply. Plz help.

View 7 Replies View Related

Time Out For User

Aug 27, 2005

Is there a way to automaticaly close a database after it has been open for a period of time? I am having trouble with users leaving their database open after use. This causes a problem when they shut down their computers at the end of the day not knowing that the database is still open. What I want to do is to set it so that after mayby an hour of inactivity on the database, the database opens a warning message. The user can then click on the warning message to continue working on the database or the database would automatically closes. Any help would be greatly appreciated.

View 3 Replies View Related

More Than A User To Access The Db At The Same Time

Mar 14, 2007

Hi all
How are you?
I have a small problem...
I have an access db called MainDB, which has tables, queries, data entry form. This db (MainDB) is located in the network server.
I have another access db called BranchDB. This db (BranchDB) has no tables, it has linked tables to those tables from the MainDB, and it has the forms for view only (No Data Entry).
The problem is that users from there local machines can not access the BranchDB at the same time.
What can I do?
Your help will be highly appreciated.

View 8 Replies View Related

After 2003 Domain, Only One User At A Time

Aug 8, 2005

We have a database created in access 2000 laying on a server that two clients connect to using access 2000 from WinXP Pro. We have just moved the database from our old win2000 server to a 2003 server. The clients now logon to a 2003 domain instead of the old 2000.

Since we moved to 2003 only one user can open the database at a time, when the second user tries to open nothing happens. There's no error message, there's just nothing happening! When the first user close access the other user can open the db.

What's going on????

View 6 Replies View Related

First Time Access User Needing Help

Jan 18, 2008

Hi
I am a teacher using Access 2007 for the first time.
I have downloaded and created a Student Info database which contains details of nationality, guardian's contact info, etc.
I also have an Attendance Excel Sheet which calculates daily / monthly attendance in its most basic form.
How do I link the cells that show the current attendance of each student to the Access db? Can I link it so that it appears on the db forms / tables / individual student page?
Please advise.
I'd appreciate the coming to me in painfully simple steps.
I teach English and Humanities and am not well versed in computer language ... although I enjoy its challenges and use a lot of it for teaching and administratie purposes.
Thanking you in advance,
Kscape.

View 1 Replies View Related

First Time Multi-user Problems

Jan 13, 2005

I'm trying to create a multi-user application for the first time and am confused on the proper set-up. (Access 2000)

I first created the app as stand-alone, then split it.
I then map the fileshare containing the back-end table and copied the front-end to the remote system. It's a simplistic application so security isn't an issue. Will this scheme work ok for me?

I can view the records fine this way (using queries based on the BE table), but am having a problem when iItry to delete a record from the remote table.

I'm guessing I'm not properly opening the recordset??

Here's the bit of code that's giving me the error when I try to delete the remote record:

Set db = CurrentDb()
Set rec = db.OpenRecordset("BoutRecord", dbOpenTable)

Actually, this doesn't even work on the system where the B-E file resides, yet it worked fine before I split the DB...

Do I need to open the table differently when it's linked/split?

Sorry if this is a dumb/basic question...(so basic, I couldn't find references elsewhere in the forum...) I'd appreciate any giudance as I'm just getting started with Access development.

View 1 Replies View Related

Change User In Run Time (without Restarting Access)

Mar 8, 2007

Hey guys!There is any possibility of changing user on the run without restart ms-access and prompt for user again?Cheers!:)

View 1 Replies View Related

URGENT!!! Time Registry On User Entry

Nov 21, 2006

Hi I'm a newbie in access, i've read almos all of the threads posted

my problem is that I need to register times

for example
I ask for user number (this is an exlcusive number)
and by the time User clicks on Accept i need acces to record this time

user 19394 time 7:35 am (for example)

can this be done in access??

and another i need acces to display a pop-up message like

"User 19394 Jhon Smith
is this correct?"

can you help me

View 1 Replies View Related

Queries :: Display Date And Time User Log On And Log Off

May 21, 2015

I would like to make a query that count simultaneous connection.

Here is my tables
Users (ID_User, Name)
Date_logon (Id_on, Date_logon, time_logon, Num_user#)
Date_logoff (Id_logoff, Date_logoff, time_logoff, Num_user#)

Here is a part of a query that display users date and time of log on and log off.

Users Date_logon Time_logon Date_logoff Time_logoff
Utilisateur1 13/05/2015 17:38:42 13/05/2015 18:52:15
Utilisateur2 13/05/2015 17:12:21 13/05/2015 17:30:24
Utilisateur3 13/05/2015 16:59:08 13/05/2015 17:16:06
Utilisateur4 13/05/2015 16:54:14 13/05/2015 18:32:13

Then I put that result in a pivot table in Excel. In line we have time logon by date and in column we have time logoff by date.

Here is the issue : In Excel for the 4 lines above, it counts 2 logon at 4PM and 2 logon at 5PM. We should have 4.

View 14 Replies View Related

Capturing Parameter From Parameter Query

Jul 12, 2005

I have a form whose data source is a select query, q3, that is built from 2 other select queries. I'll call them q1, q2, and q3. q1 is a parameter query where I enter a "Cutoff Date" that the 3 queries manipulte and generate the desired results that appear in the form. The problem is that I don't know how to capture the parameter "Cutoff Date" from q1 to display on the form.

View 2 Replies View Related

Capturing F11 Press, Possible?

Sep 18, 2007

Hi,
I've read a few posts regarding removing the facility of the F11, open Db window, but is there a way to capture if someone presses F11?
I have a few people (users) who think they know a thing or two about Access and I'd like to know if/ when they're accessing the Db window.

I was hoping for the ASCI code or similar for the F11 key!?
Thanks
Matt

View 4 Replies View Related

Changing Idle Time In A Multi User Database

May 24, 2007

There are between 10 - 15 users at one time. It is a shared network, the front_end is on individual hardrives and the tables are located on the server. We just converted to Access 2003, our data file size is 47kb.

Users who are not active in the database get disk or network error message and have to close out. Is idle time a possible factor? Some users maybe entering information sporadically through out the day, but need to have the database open, they may need to refer to a member record upon receiving a phone call.

:confused:

View 4 Replies View Related

Forms :: Last Login Time Stamp For Each User Logged In

Mar 19, 2014

Was trying to set the value of text to current date and time when a submit button is clicked. I've managed to set

Control Name:- txtLastLogin
Property:- Value
Value:- now()

The above expression works but the last logged data in tblEmployee gets replaced as another user logs in.

How can i add a time stamp to each user loged in.

View 2 Replies View Related

Forms :: Restrict A Form So That Only One User Can Open It Any One Time

Oct 10, 2014

On a split database, is there a way to restrict a form so that only one user can have it open at any one time?

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved