Can you access the security user signons using a query?

5 Aug 2006 4:13 PM

Bunky

I have an application that the user must enter their specific code into every
record they touch. Is there a way for me to program the application to look
at the security data and pull that information into a regular form?

5 Aug 2006 7:22 PM

jacksonmacd

The CurrentUser() function will return the name of the Access login
that is currently active. In your editing form, you can use the
BeforeUpdate event to capture the value of CurrentUser(), and stuff it
into a field of your choosing.

On Sat, 5 Aug 2006 09:13:01 -0700, Bunky
<Bu***@discussions.microsoft.com> wrote:

>I have an application that the user must enter their specific code into every
>record they touch. Is there a way for me to program the application to look
>at the security data and pull that information into a regular form?

--
jackmacMACdon***@telusTELUS.net
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security

5 Aug 2006 8:03 PM

Bunky

Thanks a bunch! I'll try it!!!

Show quoteHide quote

"jacksonmacd" wrote:

>
> The CurrentUser() function will return the name of the Access login
> that is currently active. In your editing form, you can use the
> BeforeUpdate event to capture the value of CurrentUser(), and stuff it
> into a field of your choosing.
>
>
>
> On Sat, 5 Aug 2006 09:13:01 -0700, Bunky
> <Bu***@discussions.microsoft.com> wrote:
>
> >I have an application that the user must enter their specific code into every
> >record they touch. Is there a way for me to program the application to look
> >at the security data and pull that information into a regular form?
>
> --
> jackmacMACdon***@telusTELUS.net
> remove uppercase letters for true email
> http://www.geocities.com/jacksonmacd/ for info on MS Access security
>