Hi,

I was wondering how i could use the current login in a textbox. I know the
currentuser() gives me e.g. 'Admin' if no security is set up.

But how can i get the login and/or hostname from windows (or if logged in
through novell)?

Greetings,

J

Jason,

Not sure if this will work under Novell, but as far as Windows goes:

Environ("UserName")

will return the Windows login name.

It can be argued that environment variables are fairly easy to change,
so some advise to use an API call instead, in order to retrieve the
Windows login name. The counter-argument is that hardly any user will
know how to do that, even if they know it's being used, but if you want
to go by the book you can find the code in:

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

HTH,
Nikos

Jason wrote:
> Hi,
>
> I was wondering how i could use the current login in a textbox. I know the
> currentuser() gives me e.g. 'Admin' if no security is set up.
>
> But how can i get the login and/or hostname from windows (or if logged in
> through novell)?
>
> Greetings,
>
> J
>
>

Hi Nikos,

Thanks for tip. I agree that normal users don't know how to change it. Do
you also know to get the hostname?

Greetings,

J
"Nikos Yannacopoulos" <(E-Mail Removed)> schreef in bericht
news:(E-Mail Removed)...
> Jason,
>
> Not sure if this will work under Novell, but as far as Windows goes:
>
> Environ("UserName")
>
> will return the Windows login name.
>
> It can be argued that environment variables are fairly easy to change, so
> some advise to use an API call instead, in order to retrieve the Windows
> login name. The counter-argument is that hardly any user will know how to
> do that, even if they know it's being used, but if you want to go by the
> book you can find the code in:
>
> http://www.mvps.org/access/api/api0008.htm
>
> HTH,
> Nikos
>
> Jason wrote:
>> Hi,
>>
>> I was wondering how i could use the current login in a textbox. I know
>> the currentuser() gives me e.g. 'Admin' if no security is set up.
>>
>> But how can i get the login and/or hostname from windows (or if logged in
>> through novell)?
>>
>> Greetings,
>>
>> J

Jason,

Not sure what you mean by hostname... logon server maybe? If yes, use
Environ("LOGONSERVER"). For more on the possible Environ arguments, look at:

http://blogs.officezealot.com/charle...2/10/3574.aspx

HTH,
Nikos

Jason wrote:
> Hi Nikos,
>
> Thanks for tip. I agree that normal users don't know how to change it. Do
> you also know to get the hostname?
>
> Greetings,
>
> J
> "Nikos Yannacopoulos" <(E-Mail Removed)> schreef in bericht
> news:(E-Mail Removed)...
>
>>Jason,
>>
>>Not sure if this will work under Novell, but as far as Windows goes:
>>
>>Environ("UserName")
>>
>>will return the Windows login name.
>>
>>It can be argued that environment variables are fairly easy to change, so
>>some advise to use an API call instead, in order to retrieve the Windows
>>login name. The counter-argument is that hardly any user will know how to
>>do that, even if they know it's being used, but if you want to go by the
>>book you can find the code in:
>>
>>http://www.mvps.org/access/api/api0008.htm
>>
>>HTH,
>>Nikos
>>
>>Jason wrote:
>>
>>>Hi,
>>>
>>>I was wondering how i could use the current login in a textbox. I know
>>>the currentuser() gives me e.g. 'Admin' if no security is set up.
>>>
>>>But how can i get the login and/or hostname from windows (or if logged in
>>>through novell)?
>>>
>>>Greetings,
>>>
>>>J
>
>
>

Recognize, though, that not all of the environment variables listed in that
article necessarily exist on all machines. I stopped comparing after about 5
in the list weren't present on my machine.

Recognize, too, that it's trivial to reset any environment variable
(although doing so may cause problems on the machine)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Nikos Yannacopoulos" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Jason,
>
> Not sure what you mean by hostname... logon server maybe? If yes, use
> Environ("LOGONSERVER"). For more on the possible Environ arguments, look
> at:
>
> http://blogs.officezealot.com/charle...2/10/3574.aspx
>
> HTH,
> Nikos
>
> Jason wrote:
>> Hi Nikos,
>>
>> Thanks for tip. I agree that normal users don't know how to change it. Do
>> you also know to get the hostname?
>>
>> Greetings,
>>
>> J
>> "Nikos Yannacopoulos" <(E-Mail Removed)> schreef in bericht
>> news:(E-Mail Removed)...
>>
>>>Jason,
>>>
>>>Not sure if this will work under Novell, but as far as Windows goes:
>>>
>>>Environ("UserName")
>>>
>>>will return the Windows login name.
>>>
>>>It can be argued that environment variables are fairly easy to change, so
>>>some advise to use an API call instead, in order to retrieve the Windows
>>>login name. The counter-argument is that hardly any user will know how to
>>>do that, even if they know it's being used, but if you want to go by the
>>>book you can find the code in:
>>>
>>>http://www.mvps.org/access/api/api0008.htm
>>>
>>>HTH,
>>>Nikos
>>>
>>>Jason wrote:
>>>
>>>>Hi,
>>>>
>>>>I was wondering how i could use the current login in a textbox. I know
>>>>the currentuser() gives me e.g. 'Admin' if no security is set up.
>>>>
>>>>But how can i get the login and/or hostname from windows (or if logged
>>>>in through novell)?
>>>>
>>>>Greetings,
>>>>
>>>>J
>>
>>

Doug,

First point is fair. Second one as well, but I've already warned Jason
about it! I have to admit I don't know how to change an environment
variable, so I trust my users )whom I know) won't either. Speaking of
it, how is it done?

Thanks,
Nikos

Douglas J. Steele wrote:
> Recognize, though, that not all of the environment variables listed in that
> article necessarily exist on all machines. I stopped comparing after about 5
> in the list weren't present on my machine.
>
> Recognize, too, that it's trivial to reset any environment variable
> (although doing so may cause problems on the machine)
>

Yes - how is it done? Any way of knowing that's it's been done and use
the API call if it has?

It can be as simple as opening a command prompt and issuing a Set command:

Set UserName=Phoney

There are also API calls that let you set environment variables.

If you're going to try and detect whether it's been done and use the API it
is has, why not just use the API everytime?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Barry-Jon" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Yes - how is it done? Any way of knowing that's it's been done and use
> the API call if it has?
>

Answered elsewhere in this thread.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Nikos Yannacopoulos" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Doug,
>
> First point is fair. Second one as well, but I've already warned Jason
> about it! I have to admit I don't know how to change an environment
> variable, so I trust my users )whom I know) won't either. Speaking of it,
> how is it done?
>
> Thanks,
> Nikos
>
> Douglas J. Steele wrote:
>> Recognize, though, that not all of the environment variables listed in
>> that article necessarily exist on all machines. I stopped comparing after
>> about 5 in the list weren't present on my machine.
>>
>> Recognize, too, that it's trivial to reset any environment variable
>> (although doing so may cause problems on the machine)
>>

Thanks Doug!

Douglas J. Steele wrote:
> It can be as simple as opening a command prompt and issuing a Set command:
>
> Set UserName=Phoney
>
> There are also API calls that let you set environment variables.
>
> If you're going to try and detect whether it's been done and use the API it
> is has, why not just use the API everytime?
>