last updated - date AND user - Microsoft Access / VBA

83 New Member

is there a way to have my form automatically record when a record is changed? i figured how to make the date update JUST if you change a record, but i also wanted to have it record the user that was logged in and made that change as well.
currently i made a macro under BeforeUpdate event for the form for my LastUpdated field and it puts the date in when the record has been changed. i have a field for the UpdatedBy but it just fills in whoever is logged in at the time-it doesnt necessarily put the user that changed that record. hope that makes sense.
any ideas on how to have both fields update?

Apr 19 '07 #1

Subscribe Reply

5155

Denburt

1,356

Recognized Expert Top Contributor

If you have user security in place for the database then you can simply call:

currentUser()

If you would like to know who logged into that P.C.

Environ("UserName")

There is also other methods Neopa has an example here where he pulls it out of the registry:
http://www.thescripts.com/forum/post2152274-2.html

There are also several examples in this thread:
http://www.thescripts.com/forum/thread621606.html

Apr 19 '07 #2

jayme

New Member

currently i am using CurrentUser() in that field but it doesnt update when someone edits a record. it just has who is logged in.
like-for the date the field is blank until i change something then hit save THEN it updates that field for the modified date. the user field doesnt necessarily change with WHO made the change. so i was thinking there had to be another way besides currentuser().
ill look more into those other links you posted-maybe those have the answer im looking for.
thank you!!

Apr 19 '07 #3

Denburt

1,356

Recognized Expert Top Contributor

I don't quite understand this:

it just has who is logged in.

Are you saying that you have a user account that several people use?

Environ("UserName") Will give you the person logged into that P.C.

Where are you using CurrentUser() are you placing this in the default value property, the control source, or VBA somewhere?

I usually use it in my form using VBA under the On Dirty property.

Apr 19 '07 #4

jayme

New Member

i did not know about the OnDirty event....learned something new-once again! thank you!! sorry for not being able to explain my problem very well-but your help is definitely appreciated! i tried the OnDirty property for that and it worked! thanks so much!! that's exactly what i needed!

Apr 20 '07 #5

Denburt

1,356

Recognized Expert Top Contributor

Glad I could help, makes my morning knowing your all set.

Apr 20 '07 #6

Denburt

1,356

Recognized Expert Top Contributor

Oh just noticed one more thing are you using "date AND user" or "Date/Time and user" FYI, If your in the VBA window Date() gives you the date and Now() gives you date time info. have a nice day :)

Apr 20 '07 #7

jayme

New Member

Oh just noticed one more thing are you using "date AND user" or "Date/Time and user" FYI, If your in the VBA window Date() gives you the date and Now() gives you date time info. have a nice day :)

i was just using the Date() but I might give Now() a try and see what works for us. great...thank you!

Apr 20 '07 #8

Similar topics

4875

Display last recordset

by: Dan Matthews | last post by:

Hey everybody, I have an 2000 Access database that stores job listings from potential employers for a school. I would like to be able to display the date on a webpage the last time the database...

ASP / Active Server Pages

3210

Last Modified problems

by: Amanda | last post by:

Hi, hope you can help me with this one. If I want to get the date a page has been last modified, I can do something like .. document.write("<b>Last updated: "+document.lastModified+"</b>"); ...

Javascript

1708

Last Date Stored Proc Updated???

by: John | last post by:

Is there such a date/time? I see the Created date on the list of stored procs, but really want a Date Last Updated. After changing code for 3 hours, I tend to forget which procs I've worked on,...

Microsoft SQL Server

8663

DetailsView and ObjectDataSource - how to get updated object

by: Jim Hammond | last post by:

I am passing the whole object instead or parameters in my select and update methods. I can get the updated object if I set UpdateMethod, let ASP.NET autogenerate an update button, and then press...

ASP.NET

2063

show last updated date on reports

by: eal1 | last post by:

Does anyone know how to have Access put the "last updated" date on a report? I have a table of our university's athletic events, grouped by each sport per page. I'm trying to get the report to...

Microsoft Access / VBA

6865

Last Updated By Field in Access

by: abprules | last post by:

Is there a way that I can create a "Last Updated by" field in MS Access. I know how to do the Date Last Updated but can't seem to find out how to record the user who last updated the info. ...

Microsoft Access / VBA

3422

Last Updated script

by: kustomguitarist | last post by:

I'm working on updating a page for a club that I'm involved in at school. It's on an apache server and I am editing the .htm file through linux. Does anyone know a script that I could include in...

Javascript

6259

Create/Last Modification Date-Time Stamp

by: MarcJoseph | last post by:

I have a database that is shared my multiple users who enter and update records on a weekly basis. Is there a way I can add a field to my main data table that will automatically generate the...

Microsoft Access / VBA

1919

How to determine when back-end file has been updated

by: rdemyan via AccessMonster.com | last post by:

Anyone have any ideas on how to determine when the back-end file (containing only tables) has been updated with new data. The date/time of the file won't work because it gets updated to the...

Microsoft Access / VBA

1608

How to get the last updated date of a different file

by: Ade | last post by:

Hi, I am a complete novice to Javascript, so please excuse me if this is a simple task. I have been playing with frames in a test piece in a book I have, and one of them displays the data and...

Javascript

7051

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

7054

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

6993

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

4493

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

3003

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

2993

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1307

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

567

php

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

193

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General