Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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

    > >
    > >
    > >
     
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