Welcome to SPN

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

Sign Up Now!

Prohibit record navigation

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

  1. John

    John
    Expand Collapse
    Guest

    Hi

    I need to block user from moving away from a record using any of
    First/Last/Prev/Next/New Record or any other way IF the record has not been
    saved, and displaying a message to the effect "Please finish editing". If
    however the user has explicitly saved the record using save from the access
    menu then allow to move from record. How do I achieve this via code?

    Thanks

    Regards
     
  2. Loading...

    Similar Threads Forum Date
    Islam Fatwa Prohibits Killing the "Believer Lice Growing in Blessed Beards" Interfaith Dialogues Sep 2, 2013
    Prohibitions and Prescriptions Questions and Answers Apr 15, 2013
    India Pakistan prohibits visiting Sikh pilgrims’ nagar kirtan Breaking News Nov 25, 2010
    Controversial Facebook Photos Result in Weapons Prohibitions Hard Talk May 1, 2010
    Sikh News Punjab prohibition on early sowing of paddy (The Hindu) Breaking News Mar 22, 2008

  3. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Wed, 14 Jun 2006 00:39:21 +0100, "John" <John@nospam.infovis.co.uk>
    wrote:

    >Hi
    >
    >I need to block user from moving away from a record using any of
    >First/Last/Prev/Next/New Record or any other way IF the record has not been
    >saved, and displaying a message to the effect "Please finish editing". If
    >however the user has explicitly saved the record using save from the access
    >menu then allow to move from record. How do I achieve this via code?


    Set Cancel to True in the Form's BeforeUpdate event until you're
    satisfied.

    John W. Vinson[MVP]
     
  4. John

    John
    Expand Collapse
    Guest

    Is there a way to distinguish between a) before update event due to explicit
    save action from access menu and b) before update by other reasons such as
    moving away from the record?

    Thanks

    Regards

    "John Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message
    news:crpu82lel42hqgv2sm8b83f3cluanck151@4ax.com...
    > On Wed, 14 Jun 2006 00:39:21 +0100, "John" <John@nospam.infovis.co.uk>
    > wrote:
    >
    >>Hi
    >>
    >>I need to block user from moving away from a record using any of
    >>First/Last/Prev/Next/New Record or any other way IF the record has not
    >>been
    >>saved, and displaying a message to the effect "Please finish editing". If
    >>however the user has explicitly saved the record using save from the
    >>access
    >>menu then allow to move from record. How do I achieve this via code?

    >
    > Set Cancel to True in the Form's BeforeUpdate event until you're
    > satisfied.
    >
    > John W. Vinson[MVP]
     
  5. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Wed, 14 Jun 2006 03:46:37 +0100, "John" <John@nospam.infovis.co.uk>
    wrote:

    >Is there a way to distinguish between a) before update event due to explicit
    >save action from access menu and b) before update by other reasons such as
    >moving away from the record?


    Not that I know of. The BeforeUpdate event fires upon any action which
    causes the record to be saved to disk - navigating off the record,
    closing the form, Records... Save, whatever. Why?

    John W. Vinson[MVP]
     

Share This Page