Automatic Computer Name Info

[andrewneal]

How would I get Access to autopopulate a table's text field with the user's computer name when they enter data into a form? The user shouldn't have to enter this...

 

[pbaldy]

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

 

[andrewneal]

How would I get it to populate the table? Would I put the fOScomputer as the default data in the text box?

 

[boblarson]

That should work since it is a function and I know the function can be set there as it works when I put Environ("computername") into the default of a text box.

 

[pbaldy]

As Bob said, it should (and Environ should also work for you). What I typically do is grab the info when the db starts and save it in a hidden textbox on a form that stays open. Then I just refer to the form control when I need the value throughout the db. My assumption is that doing it that way is more efficient, since you save repeated calls to the function. That is an untested assumption however.