Keep getting error from code
in [Forms]
|
Prev: Using Findfirst recordset to search memo field type
Next: I want to transfer data from a filtered datasheet to a spreadsheet.
From: ruralguy via AccessMonster.com on 5 Apr 2010 18:27 Try: If Me.Dirty Then Me.UnDo DoCmd.GoToRecord , , acLast Afrosheen wrote: >Yes I am. >I really appreciate your help. I'm trying to get out of the New Record. > >>What we're all trying to say is you can not use DoCmd.GoToRecord , , >>acPrevious when you are sitting on a new record that is not saved whether it >[quoted text clipped - 5 lines] >>>>> >>>>> Thanks in advance. -- RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro Please post back to this forum so all may benefit. Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201004/1
From: Afrosheen via AccessMonster.com on 6 Apr 2010 07:13 Thank you. That will work. Where the error is occurring is on the OnCurrant, so I put up an error flag: If Err.Number <> 2108 Then Err.Description = Err.Description & " In Procedure " & "Form_Current of VBA Document Form_frmEmployee_Tab" Call LogError(Err.Number, Err.Description, "Form_Current") End If Thanks again for your help. Some day when I grow up Access smart I'll be able to help others out. ruralguy wrote: >Try: >If Me.Dirty Then Me.UnDo >DoCmd.GoToRecord , , acLast > >>Yes I am. >>I really appreciate your help. I'm trying to get out of the New Record. >[quoted text clipped - 4 lines] >>>>>> >>>>>> Thanks in advance. > -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201004/1
From: ruralguy via AccessMonster.com on 6 Apr 2010 07:42
Glad we could help. Afrosheen wrote: >Thank you. That will work. Where the error is occurring is on the OnCurrant, >so I put up an error flag: >If Err.Number <> 2108 Then > Err.Description = Err.Description & " In Procedure " & "Form_Current >of VBA Document Form_frmEmployee_Tab" > Call LogError(Err.Number, Err.Description, "Form_Current") >End If > >Thanks again for your help. Some day when I grow up Access smart I'll be able >to help others out. > >>Try: >>If Me.Dirty Then Me.UnDo >[quoted text clipped - 5 lines] >>>>>>> >>>>>>> Thanks in advance. -- RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro Please post back to this forum so all may benefit. Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201004/1 |