I want to use the current user as a test condition in a
module. CurrentUser will not work as we do not use user
level security (everyone is logged into the databse as
Admin). Is there a method by which I may grab a unique
identifier (i.e., window logon name, Novell logon name,
workstation network identifier, etc.)? Thanks for any
help. God bless.

"Chaplain Doug" <(E-Mail Removed)> wrote in message
news:0f3601c37243$0397a130$(E-Mail Removed)...
> I want to use the current user as a test condition in a
> module. CurrentUser will not work as we do not use user
> level security (everyone is logged into the databse as
> Admin). Is there a method by which I may grab a unique
> identifier (i.e., window logon name, Novell logon name,
> workstation network identifier, etc.)? Thanks for any
> help. God bless.

Sample code at this link will return the network logon name.

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

Thank you for the link. It did the trick!

> The following is what I use. It is from F. Scott Barker's
> Access 2002 Power Programming © 2002 by Sams Publishing

Do you know what the "©" means? It is a Copyright symbol, indicating that you
shouldn't be posting any part of the contents publicly. You may make reference
to the book - even to the page on which the code is located, but you are in
violation of the publisher's copyright by reprinting the code without their
permission.

--
Bruce M. Thompson, Microsoft Access MVP
(E-Mail Removed) (See the Access FAQ at http://www.mvps.org/access)
>> NO Email Please. Keep all communications
within the newsgroups so that all might benefit.<<

>-----Original Message-----
>Thank you for the link. It did the trick!
>.
>

How are you getting the form to pull from the module?
I create a macro to run the module and point to the macro
in the form, but nothing happens?
Can you give me an example of how to have that logon
posted to a text box?

Ignore that post. I figured it out. Brain dead today...
>-----Original Message-----
>
>>-----Original Message-----
>>Thank you for the link. It did the trick!
>>.
>>
>
>How are you getting the form to pull from the module?
>I create a macro to run the module and point to the macro
>in the form, but nothing happens?
>Can you give me an example of how to have that logon
>posted to a text box?
>.
>

"Bruce M. Thompson" <bthmpson@big_NOSPAM_foot.com> wrote in message
news:(E-Mail Removed)...
> > The following is what I use. It is from F. Scott Barker's
> > Access 2002 Power Programming © 2002 by Sams Publishing
>
> Do you know what the "©" means? It is a Copyright symbol, indicating that
you
> shouldn't be posting any part of the contents publicly. You may make
reference
> to the book - even to the page on which the code is located, but you are
in
> violation of the publisher's copyright by reprinting the code without
their
> permission.


I don't disagree with that. But it always seems weird when someone tries to
copyright what is really just a direct take from the win32 documentation!

It's a bit like saying:

' Code to loop 10 times.
' COPYRIGHT (C) TC 2003
for i = 1 to 10
next

TC

> I know EXACTLY what a copyright is. The code I posted
> isn't proprietary, it's also available at
> http://www.mvps.org/access/api/api0008.htm and
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;161394

That is true, and I confess that I didn't read throught the code to see that
there is nothing in that code that isn't in the public domain. I feel, however,
that you should have obtained one of the above-noted references, or simply
posted the code without any reference, instead of "quoting from the book".

> Does this mean that Microsoft, Dev Ashish, and Sams are
> the only ones with rights to this code?

Certainly not.

> I was citing a source and not profiting by it;
> furthermore, the book invites you to 'pull sample code
> right into your own applications' which is reproduction
> with implied consent and not direct written consent.

That is common with most publications of this type. Much of the code in such
publications, however, may have been written by the author and, if you buy the
book, you acquire any reproduction rights that are explicit/implicit in the
copyright or contents, generally for your own use, but not for republication.

> I appreciate what you are trying to do, but you should
> probably think before you write. And you really don't
> need to be condescending, either.

I'm not sure where you got the impression that I was being condescending. I was
certainly not assuming that you understood what a copyright represented, hence
the explanation, but I did not belittle you or attempt to raise myself above
you. I would have had no problem if you had simply posted the code (as it is in
the public domain) without the publication reference. If you are looking for an
apology, then here it is, for what it's worth.

:-)
--
Bruce M. Thompson, Microsoft Access MVP
(E-Mail Removed) (See the Access FAQ at http://www.mvps.org/access)
>> NO Email Please. Keep all communications
within the newsgroups so that all might benefit.<<

> I don't disagree with that. But it always seems weird when someone tries to
> copyright what is really just a direct take from the win32 documentation!

They weren't. See my reply to Mike.

--
Bruce M. Thompson, Microsoft Access MVP
(E-Mail Removed) (See the Access FAQ at http://www.mvps.org/access)
>> NO Email Please. Keep all communications
within the newsgroups so that all might benefit.<<