PC Review


Reply
 
 
Irene
Guest
Posts: n/a
 
      17th Apr 2008
i have a system. how can i detect the user who has been change the data or
update the data? i want it keep in a table and can be a proof when something
going wrong with the data.
 
Reply With Quote
 
 
 
 
Keith Wilby
Guest
Posts: n/a
 
      17th Apr 2008
"Irene" <(E-Mail Removed)> wrote in message
news:52FE4D1B-29F5-4D68-B128-(E-Mail Removed)...
>i have a system. how can i detect the user who has been change the data or
> update the data? i want it keep in a table and can be a proof when
> something
> going wrong with the data.


You can either use the CurrentUser function or you can grab the network ID
using this:

http://www.mvps.org/access/api/api0008.htm

Keith.
www.keithwilby.com

 
Reply With Quote
 
Irene
Guest
Posts: n/a
 
      17th Apr 2008
i have been trying this. but cant. i dont know y. what is API?

"Keith Wilby" wrote:

> "Irene" <(E-Mail Removed)> wrote in message
> news:52FE4D1B-29F5-4D68-B128-(E-Mail Removed)...
> >i have a system. how can i detect the user who has been change the data or
> > update the data? i want it keep in a table and can be a proof when
> > something
> > going wrong with the data.

>
> You can either use the CurrentUser function or you can grab the network ID
> using this:
>
> http://www.mvps.org/access/api/api0008.htm
>
> Keith.
> www.keithwilby.com
>
>

 
Reply With Quote
 
Keith Wilby
Guest
Posts: n/a
 
      17th Apr 2008
"Irene" <(E-Mail Removed)> wrote in message
news:77256773-3E96-4AF1-A611-(E-Mail Removed)...
>i have been trying this. but cant. i dont know y. what is API?
>


Paste the code into a module and save it. You can then call it from your
form's "Before Update" event to store the result in a table:

Me.txtUserName = fOSUserName

where "txtUserName" is the name of a text box bound to the field where you
want to store the name.

Keith.

 
Reply With Quote
 
Irene
Guest
Posts: n/a
 
      18th Apr 2008
hi keith,

thanks for ur help! but i stil have a question. is it need test on the
server? cos i'm copy the form and the table and put in my drive C to try, but
it didn't show anything. is it need put the table in the server, then the
form in the own pc? the result wil show the computer name or "admin" if he o
she is the admin for their own pc. sorry, because i'm new to this topic. hope
u stil can continue helping me. thanks!

"Keith Wilby" wrote:

> "Irene" <(E-Mail Removed)> wrote in message
> news:77256773-3E96-4AF1-A611-(E-Mail Removed)...
> >i have been trying this. but cant. i dont know y. what is API?
> >

>
> Paste the code into a module and save it. You can then call it from your
> form's "Before Update" event to store the result in a table:
>
> Me.txtUserName = fOSUserName
>
> where "txtUserName" is the name of a text box bound to the field where you
> want to store the name.
>
> Keith.
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
detect user Irene Microsoft Access Form Coding 11 27th May 2008 09:52 PM
detect the user Irene Microsoft Access 3 18th Apr 2008 08:38 PM
Detect in C# the name of the ASP.NET user. =?Utf-8?B?VmlsaGVsbQ==?= Microsoft ASP .NET 8 10th Aug 2007 11:21 AM
detect where the user goes?! =?Utf-8?B?RGFuaWVs?= Microsoft Access VBA Modules 3 7th Oct 2004 03:37 PM
Detect changes from user =?Utf-8?B?Qm9i?= Microsoft VB .NET 1 14th May 2004 03:08 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:29 PM.