Results 1 to 6 of 6
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Proper Way To Cancel a Transaction? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

    I have a form that I start transactions with by selecting the correct patient record from an unbound combo box.

    Following is the combo

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Proper Way To Cancel a Transaction? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

    What the heck does <font color=blue><code>DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70</code></font color=blue> translate into? I hate the Access 95 code the wizards write!
    Charlotte

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Proper Way To Cancel a Transaction? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

    I belive it

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Proper Way To Cancel a Transaction? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

    Your routine is in the beforeupdate event of a control. All you can do there is cancel the update for that control and undo the current record, you can't delete a record that hasn't been saved yet. You could comment out those A95 commands and add a Cancel = True and a Me.Undo to the code for the vbCancel branch, which should cancel the control update AND the record update.
    Charlotte

  5. #5
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Proper Way To Cancel a Transaction? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

    Hi Charlotte

    Thanks for the help

    John

    PS: Nice article in Inside Microsoft Access

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Proper Way To Cancel a Transaction? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

    Thanks.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •