network name

[ted medin]

How do i find out the name of the pc from within a vba pgm? TIA

 

[Jay Freedman]

How do i find out the name of the pc from within a vba pgm? TIA

Try this statement:

Environ("ComputerName")

 

[Jay Freedman]

Try this statement:

Environ("ComputerName")

Erm... of course, that isn't a statement, it's an expression that
returns a string. You can assign it to a string variable

Dim MyComputer As String
MyComputer = Environ("ComputerName")

or you can display it

MsgBox Environ("ComputerName")

 

[ted medin]

Erm... of course, that isn't a statement, it's an expression that
returns a string. You can assign it to a string variable

Dim MyComputer As String
MyComputer = Environ("ComputerName")

or you can display it

MsgBox Environ("ComputerName")

One further problem: xp os gave me the correct name BUT me os gave me ""
Anyone got any ideas? TIA

 

[Jay Freedman]

One further problem: xp os gave me the correct name BUT me os gave me ""
Anyone got any ideas? TIA

The obvious but unhelpful answer is "ME isn't an OS, it's a P.O.S."


This approach, using the Win32 API function GetComputerName, should
work everywhere: http://www.mvps.org/access/api/api0009.htm

 

[ted medin]

How do i find out the name of the pc from within a vba pgm? TIA

Erm... of course, that isn't a statement, it's an expression that
returns a string. You can assign it to a string variable

Dim MyComputer As String
MyComputer = Environ("ComputerName")

or you can display it

MsgBox Environ("ComputerName")

Works fine in xp but NOT me. I get "" from me & win98. HELP! TIA.

 

[cm medin]

This approach, using the Win32 API function GetComputerName, should
work everywhere: http://www.mvps.org/access/api/api0009.htm

Well that looks like a solution BUT unable to copy the code & paste. So what
am i missing? TIA