Welcome to SPN

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

Sign Up Now!

Notifying a user when changing data.

Discussion in 'Information Technology' started by Andrey, Oct 28, 2005.

  1. Andrey

    Andrey
    Expand Collapse
    Guest

    Is it possible to notify a user that they are about to change data in a
    specific record/control permanently, in order to prevent them from possibly
    losing information that they should not have changed.

    I'm only aware of the edit undo last change in Access to revert to what was
    there previously in a control, but after that it seems data is changed
    permanently.

    Is it possible (in a simple manner) to achieve the above. Help much
    appreciated.
    Thank-you.
     
  2. Loading...

    Similar Threads Forum Date
    After FIR, Social Media Users Wary of Offensive Jokes on Sardars Information Technology Oct 2, 2013
    USA US govt secretly collecting data on millions of Verizon users: Report Breaking News Jun 6, 2013
    using spiritual name as a username Questions and Answers Aug 23, 2012
    Audience of 3 Million Users Receiving Anti-Sikh Messages Hard Talk Sep 17, 2010
    General How can I change my username ? Hard Talk Sep 4, 2010

  3. MA

    MA
    Expand Collapse
    Guest

    Andrey wrote:
    > Is it possible to notify a user that they are about to change data in
    > a specific record/control permanently, in order to prevent them from
    > possibly losing information that they should not have changed.
    >
    > I'm only aware of the edit undo last change in Access to revert to
    > what was there previously in a control, but after that it seems data
    > is changed permanently.
    >
    > Is it possible (in a simple manner) to achieve the above. Help much
    > appreciated.
    > Thank-you.

    You have to create a clone table where you archive the old record
    On form_beforeupdate if the record is stil edit and not a newone you can
    save all the oldvalue of the field

    --
    _ _
    Ciao
    MAssimiliano Amendola www.accessgroup.it
    Cisa - Conferenza Italiana per Sviluppatori Access
    Info: www.donkarl.com/it
     
  4. Rick B

    Rick B
    Expand Collapse
    Guest

    Just put code in the Form's BEFORE UPDATE event that asks the user if they
    wish to continue or abort. Then either end the sub, or cancel the update.

    --
    Rick B



    "Andrey" <Andrey@discussions.microsoft.com> wrote in message
    news:8516A7C6-4062-49C3-B9F0-391616A661A7@microsoft.com...
    > Is it possible to notify a user that they are about to change data in a
    > specific record/control permanently, in order to prevent them from
    > possibly
    > losing information that they should not have changed.
    >
    > I'm only aware of the edit undo last change in Access to revert to what
    > was
    > there previously in a control, but after that it seems data is changed
    > permanently.
    >
    > Is it possible (in a simple manner) to achieve the above. Help much
    > appreciated.
    > Thank-you.
    >
     

Share This Page