How to read the Computer Name in System Properties from Access?

[Guest]

Within Microsoft Access (97) I want to be able to read the 'Computer Name' in
basic coding of the computer that is currently being used. The 'Computer
Name' tab is listed under the 'System Properties' window but I do not know
how to reference it. Thanks.

 

[Dave Patrick]

Try using;

environ$("computername")

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
| Within Microsoft Access (97) I want to be able to read the 'Computer Name'
in
| basic coding of the computer that is currently being used. The 'Computer
| Name' tab is listed under the 'System Properties' window but I do not know
| how to reference it. Thanks.

 

[Guest]

Brilliant - thanks Dave

 

[Dave Patrick]

You're welcome.

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
| Brilliant - thanks Dave
|
| "Pootle" wrote:
|
| > Within Microsoft Access (97) I want to be able to read the 'Computer
Name' in
| > basic coding of the computer that is currently being used. The 'Computer
| > Name' tab is listed under the 'System Properties' window but I do not
know
| > how to reference it. Thanks.

 

[Douglas J. Steele]

Be aware, though, that environment variables are trivial to reset. If you
want to be absolutely sure that you're getting the correct value, you really
should use the GetComputerName API. See
http://www.mvps.org/access/api/api0009.htm at "The Access Web" for a
complete example.