Re: Adding User ID to tables

Well, it would probably be simpler if you included the code for BobbaLou to
paste.... <g>

I'm assuming you meant code similar to
http://www.mvps.org/access/api/api0008.htm at "The Access Web" (except that
you'd use =fOSUserName() with that code, not =GetUserID())


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


"Klatuu" <Klatuu@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:308A0DC5-56B9-42B6-970E-B1830E4333EF@xxxxxxxxxxxxxxxx
Paste the following code into a standard module by itself. DO NOT name
the
module the same as the funtion name. Access will choak if you do.
The create a text box (it can be hidden if you want) on the form and bind
it
to the field in the record source where you want to put the User ID. Then
make this the control source of the contro:
=GetUserID()

Simple as that.
--
Dave Hargis, Microsoft Access MVP


"BobbaLou" wrote:

I am setting up a database with User ID's (not a secure DB). The user
starts
Access and would login to the app. Eac entry made by the user would have
his
entries tagged with his ID (name). Any suggestions to tie these out?


.

Relevant Pages

  • RE: DateDiff function in expression
    ... paste the expression I posted directly into the text box for Control Source. ... Dave Hargis, Microsoft Access MVP ... into the white box to the right of the left box which I named 'Age'. ...
    (microsoft.public.access.forms)
  • RE: Tables and Forms
    ... Dave Hargis, Microsoft Access MVP ... record source of my form to go to the query. ... You will see the name of the table in the Record Source property. ...
    (microsoft.public.access.gettingstarted)
  • RE: Tables and Forms
    ... You will see the name of the table in the Record Source property. ... query for the table. ... Dave Hargis, Microsoft Access MVP ...
    (microsoft.public.access.gettingstarted)
  • RE: Tables and Forms
    ... Dave Hargis, Microsoft Access MVP ... I'm going to try to create the generic query. ... By creating a query and using it for my form's record source, ...
    (microsoft.public.access.gettingstarted)
  • RE: make a text box visible and non visible
    ... The field is in a domain named [Target Data] ... Dave Hargis, Microsoft Access MVP ... Im using dlooup under the control source to pull the information into the ...
    (microsoft.public.access.forms)