Hi,

I was assign to develop an Admin Forms database for my office. It consists
of 20 or more form. Our HR personel adviced us not to allow browsing staff
information. Is there a way to capture login name of the current user from
AD? I want to bing this login name to the name of staff sothat staff who
uses the form can only select their own name (I want to restirct this
because if user can browse other staff name he/she can see the remaining
balance of the medical allowance, education of the other.).

TIA

SF

On Jul 23, 7:09*pm, "SF" <x...@yahoo.com> wrote:
> Hi,
>
> I was assign to develop an Admin Forms database for my office. It consists
> of 20 or more form. Our HR personel adviced us not to allow browsing staff
> information. Is there a way to capture login name of the current user from
> AD? I want to bing this login name to the name of staff sothat staff who
> uses the form can only select their own name (I want to restirct this
> because if user can browse other staff name he/she can see the remaining
> balance of the medical allowance, education of the other.).
>
> TIA
>
> SF

this does it. You can filter the form in the open event to filter for
the user's NT Login ID.
http://www.mvps.org/access/api/api0008.htm

The code here will get the user's windows name:

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

But you can't prevent users from browsing what's in the tables unless you add
security features. Put the data in SQL Server tables, where you can
administer security. The express version is free.

Chris
Microsoft MVP


SF wrote:
>Hi,
>
>I was assign to develop an Admin Forms database for my office. It consists
>of 20 or more form. Our HR personel adviced us not to allow browsing staff
>information. Is there a way to capture login name of the current user from
>AD? I want to bing this login name to the name of staff sothat staff who
>uses the form can only select their own name (I want to restirct this
>because if user can browse other staff name he/she can see the remaining
>balance of the medical allowance, education of the other.).
>
>TIA
>
>SF

--
Message posted via http://www.accessmonster.com

If security is that important then you need to move to SQL database. But if
your on a budget use access as a index to other files. Store file names and
keep the data outside of access in individual password protected documents.
But to answer your question
http://www.mvps.org/access/api/api0008.htm
will get you the logon name.
"SF" <xyz@yahoo.com> wrote in message
news:OTVGlIS7IHA.1592@TK2MSFTNGP04.phx.gbl...
> Hi,
>
> I was assign to develop an Admin Forms database for my office. It consists
> of 20 or more form. Our HR personel adviced us not to allow browsing staff
> information. Is there a way to capture login name of the current user from
> AD? I want to bing this login name to the name of staff sothat staff who
> uses the form can only select their own name (I want to restirct this
> because if user can browse other staff name he/she can see the remaining
> balance of the medical allowance, education of the other.).
>
> TIA
>
> SF
>

Hi Chris,

Thank you for your advice.

My FE is connected to SQLServer 2005 back end. I modify my table to add a
column 'Owner' and assigh SUSER_SNAME() as default value. I found that
SUSER_SNAME() return Domain\Username which does not match value provided by
fOSUserName() which return only username.

How to store only username in the Owner column?

SF


"Chris O'C via AccessMonster.com" <u29189@uwe> wrote in message
news:8799efd28c263@uwe...
> The code here will get the user's windows name:
>
> http://www.mvps.org/access/api/api0008.htm
>
> But you can't prevent users from browsing what's in the tables unless you
> add
> security features. Put the data in SQL Server tables, where you can
> administer security. The express version is free.
>
> Chris
> Microsoft MVP
>
>
> SF wrote:
>>Hi,
>>
>>I was assign to develop an Admin Forms database for my office. It consists
>>of 20 or more form. Our HR personel adviced us not to allow browsing staff
>>information. Is there a way to capture login name of the current user from
>>AD? I want to bing this login name to the name of staff sothat staff who
>>uses the form can only select their own name (I want to restirct this
>>because if user can browse other staff name he/she can see the remaining
>>balance of the medical allowance, education of the other.).
>>
>>TIA
>>
>>SF
>
> --
> Message posted via http://www.accessmonster.com
>

Technically, domain\username is correct, since Regents\JohnSmith and Staff\
JohnSmith may not be the same user. But I think you don't want to see the
domain name in your table because everyone is on the same domain, so it's
redundant.

You have several alternatives. You could write a select query that uses vba
to only show the username, even though the domain name is stored in the table
with the username. This is probably the easiest.

If you want to keep SUSER_SNAME() as the default value, you could write a
trigger in Transact sql to fix it after the row is created. You could write
a stored procedure in Sql Server or a query in Access to update the column so
it removes the domain name in a specific row or in every row. You could
write a vba procedure in Access to update the column.

Or you could skip having SUSER_SNAME() as the default value. Write a vba
procedure that inserts the value of fOSUserName when the record is created.
Probably the form's after insert event would be best.

Chris
Microsoft MVP


SF wrote:
>Hi Chris,
>
>Thank you for your advice.
>
>My FE is connected to SQLServer 2005 back end. I modify my table to add a
>column 'Owner' and assigh SUSER_SNAME() as default value. I found that
>SUSER_SNAME() return Domain\Username which does not match value provided by
>fOSUserName() which return only username.
>
>How to store only username in the Owner column?
>
>SF
>
>> The code here will get the user's windows name:
>>
>[quoted text clipped - 21 lines]
>>>
>>>SF

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200807/1

Thank you. I will try my best.

SF

"Chris O'C via AccessMonster.com" <u29189@uwe> wrote in message
news:879b0773705ce@uwe...
> Technically, domain\username is correct, since Regents\JohnSmith and
> Staff\
> JohnSmith may not be the same user. But I think you don't want to see the
> domain name in your table because everyone is on the same domain, so it's
> redundant.
>
> You have several alternatives. You could write a select query that uses
> vba
> to only show the username, even though the domain name is stored in the
> table
> with the username. This is probably the easiest.
>
> If you want to keep SUSER_SNAME() as the default value, you could write a
> trigger in Transact sql to fix it after the row is created. You could
> write
> a stored procedure in Sql Server or a query in Access to update the column
> so
> it removes the domain name in a specific row or in every row. You could
> write a vba procedure in Access to update the column.
>
> Or you could skip having SUSER_SNAME() as the default value. Write a vba
> procedure that inserts the value of fOSUserName when the record is
> created.
> Probably the form's after insert event would be best.
>
> Chris
> Microsoft MVP
>
>
> SF wrote:
>>Hi Chris,
>>
>>Thank you for your advice.
>>
>>My FE is connected to SQLServer 2005 back end. I modify my table to add a
>>column 'Owner' and assigh SUSER_SNAME() as default value. I found that
>>SUSER_SNAME() return Domain\Username which does not match value provided
>>by
>>fOSUserName() which return only username.
>>
>>How to store only username in the Owner column?
>>
>>SF
>>
>>> The code here will get the user's windows name:
>>>
>>[quoted text clipped - 21 lines]
>>>>
>>>>SF
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/For...ccess/200807/1
>