How to prevent against this VBA issue?
The examples below is my code customers clicking a button:
Individual Sub Command35_Click()
Upon Error GoTo Err_Command35_Click
DoCmd.SetWarnings True
DoCmd.DoMenuItem acFormBar, acEditMenu, EIGHT,, acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, SIX,, acMenuVer70
Exit_Command35_Click:
DoCmd.RunCommand acCmdRecordsGoToPrevious
Quit Sub
Err_Command35_Click:
MsgBox Make a mistake.Description
Continue Exit_Command35_Click
End Sub
This is basically whenever they create an innovative record, this will probably delete the idea if this can be a mistake.It removes the record then moves back again one history.I never want the default with it making a new history of 0.While i create a fresh record, I assign the quantity they should.However, we have a bug whenever they try in order to delete the first record.It produces an limitless loop as there isn’t any previous history before this.Can somebody help me build a small defense against this particular possible problem
unbound the form from this table.Then a computer owner enters info onto the form.When the user clicks the button to save lots of, you accomplish your validation of course , if valid anyone write a great SQL affirmation to insert the images into this table and also if with valid a new message package appears revealing to them this record would not want to be unspent and the reason why.
Leave a Reply
You must be logged in to post a comment.