Welcome to SPN

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

Sign Up Now!

Last Updated by Who?

Discussion in 'Information Technology' started by Matt W., Nov 12, 2005.

Tags:
  1. Matt W.

    Matt W.
    Expand Collapse
    Guest

    I have a field that has the date when the data in the form was last updated,
    but what i wanted to know is who updated it if the database is on a shared
    network. Any help is appreciated
     
  2. Loading...

    Similar Threads Forum Date
    Last Blog Blogs Oct 14, 2016
    That Pesky Last 1% Blogs Oct 12, 2016
    Self Songs Of The Last 10 Years Blogs Oct 2, 2016
    Difficult Areas Of Turban And How To Remedy It ? Is A Plastic Cup For Your Ears The Answer Health & Nutrition Jun 4, 2016
    Alone At Last Blogs May 1, 2016

  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    There's no way of doing that automatically in a table. The only way would be
    to use a form, and put logic in the form's BeforeUpdate event to add that
    information to the table.

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


    "Matt W." <MattW@discussions.microsoft.com> wrote in message
    news:C349E905-146E-4AD1-92C3-39B407F792DF@microsoft.com...
    > I have a field that has the date when the data in the form was last

    updated,
    > but what i wanted to know is who updated it if the database is on a shared
    > network. Any help is appreciated
     
  4. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Matt W. wrote:
    >I have a field that has the date when the data in the form was last
    > updated, but what i wanted to know is who updated it if the database
    > is on a shared network. Any help is appreciated


    Is it split? Are you using user level security?


    --
    Joseph Meehan

    Dia duit
     
  5. Matt W.

    Matt W.
    Expand Collapse
    Guest

    I have seen it done before i just wasn't sure how it was done. Must be like
    you said using logic in the event

    "Douglas J Steele" wrote:

    > There's no way of doing that automatically in a table. The only way would be
    > to use a form, and put logic in the form's BeforeUpdate event to add that
    > information to the table.
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "Matt W." <MattW@discussions.microsoft.com> wrote in message
    > news:C349E905-146E-4AD1-92C3-39B407F792DF@microsoft.com...
    > > I have a field that has the date when the data in the form was last

    > updated,
    > > but what i wanted to know is who updated it if the database is on a shared
    > > network. Any help is appreciated

    >
    >
    >
     
  6. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    Assuming you've got the user's ID, it's a one-liner in code:

    Me.LastUpdatedBy = "UserId"

    It's knowing where to put that one line that matters... <g>

    The above assumes that you've got a field in the recordset named
    LastUpdatedBy, whether or not it's a textbox on the form.

    If you don't know how to get the user's ID, see
    http://www.mvps.org/access/api/api0008.htm at "The Access Web" for how to
    get the network ID, or use the CurrentUser function if you've implemented
    Access User-Level Security (i.e.: if the users have to log into the
    application)

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


    "Matt W." <MattW@discussions.microsoft.com> wrote in message
    news:F5D08C2C-0941-4FA9-949B-A62E20F682C8@microsoft.com...
    > I have seen it done before i just wasn't sure how it was done. Must be

    like
    > you said using logic in the event
    >
    > "Douglas J Steele" wrote:
    >
    > > There's no way of doing that automatically in a table. The only way

    would be
    > > to use a form, and put logic in the form's BeforeUpdate event to add

    that
    > > information to the table.
    > >
    > > --
    > > Doug Steele, Microsoft Access MVP
    > > http://I.Am/DougSteele
    > > (no e-mails, please!)
    > >
    > >
    > > "Matt W." <MattW@discussions.microsoft.com> wrote in message
    > > news:C349E905-146E-4AD1-92C3-39B407F792DF@microsoft.com...
    > > > I have a field that has the date when the data in the form was last

    > > updated,
    > > > but what i wanted to know is who updated it if the database is on a

    shared
    > > > network. Any help is appreciated

    > >
    > >
    > >
     

Share This Page