Adding computer name to a form/table

[turks393]

Can the computer name be added to a hidden field in a form upon entry or exit of another field? For example... if you are entering data into bunch of fields, you are tabbing through once you enter or exit a date field the PC name gets entered into a hidden field and stored in the table. I am also looking for a time and date stamp to do the same thing.
Thanks!

 

[dhookom]

You can use code in the before update event of a form to put values into bound controls like:

Me.txtDateTime = Now

There are functions that you can use to retrieve the network login and the PC at

http://www.mvps.org/access/api/index.html.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[CautionMP]

turks393,
Yes, you can use [tt]environ$("COMPUTERNAME")[/tt] to capture the computer name.

Hope this helps,
CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)

 

[dhookom]

I wouldn't use the Environ variables since they are not reliable in all Windows operating systems and with all users. API calls are much more robust.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]