Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1. Guest ji, please consider donating today!   Become a Supporter    ::   Make a Contribution   
    Monthly (Recurring) Target: $300 :: Achieved: $95

Track the Username when a record is changed HELP!!

Discussion in 'Information Technology' started by ScubaDee, Jul 28, 2006.

  1. ScubaDee

    ScubaDee
    Expand Collapse
    Guest

    On the before update event procedure of the form I have written the following:

    Private Sub Form_BeforeUpdate(Cancel As Integer)
    Me.[EditDateTime] = Now()
    Me.[Edit_USERID] = CurrentUser()

    End Sub

    The problem is the USERNAME is ALWAYS "Admin", this occurs on my PC at home
    and on the network and it is driving me CRAZY!!

    The Options in Access are correct and have my name as the User Name.

    Can someone please help me out here??
     
  2. Loading...


  3. G. Vaught

    G. Vaught
    Expand Collapse
    Guest

    Admin is the default for Access if no user level security has been set.
    Until you set this then you won't be able to do what you want.
    "ScubaDee" <ScubaDee@discussions.microsoft.com> wrote in message
    news:229CBB34-5194-49D3-85FD-5EECE404D413@microsoft.com...
    > On the before update event procedure of the form I have written the
    > following:
    >
    > Private Sub Form_BeforeUpdate(Cancel As Integer)
    > Me.[EditDateTime] = Now()
    > Me.[Edit_USERID] = CurrentUser()
    >
    > End Sub
    >
    > The problem is the USERNAME is ALWAYS "Admin", this occurs on my PC at
    > home
    > and on the network and it is driving me CRAZY!!
    >
    > The Options in Access are correct and have my name as the User Name.
    >
    > Can someone please help me out here??
     
  4. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    Perhaps you would do better by grabbing and using the Windows username:

    http://www.mvps.org/access/api/api0008.htm
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "ScubaDee" <ScubaDee@discussions.microsoft.com> wrote in message
    news:229CBB34-5194-49D3-85FD-5EECE404D413@microsoft.com...
    > On the before update event procedure of the form I have written the

    following:
    >
    > Private Sub Form_BeforeUpdate(Cancel As Integer)
    > Me.[EditDateTime] = Now()
    > Me.[Edit_USERID] = CurrentUser()
    >
    > End Sub
    >
    > The problem is the USERNAME is ALWAYS "Admin", this occurs on my PC at

    home
    > and on the network and it is driving me CRAZY!!
    >
    > The Options in Access are correct and have my name as the User Name.
    >
    > Can someone please help me out here??
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page