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