aplevel101
01-12-2004, 12:03 PM
hi, i have this problem and it is very annoying. when someone puts a special character into a textbox on a form (see attatchement) there is a runtime error.
here is my code:
Private Sub Command1_Click()
Data1.Recordset.AddNew
End Sub
Private Sub Command2_Click()
With Data1.Recordset
If MsgBox("Delete Record?", vbYesNo) = vbYes Then
.Delete
.MovePrevious
Else: MsgBox ("Record Not Deleted")
End If
End With
End Sub
Private Sub Form_Load()
Data1.DatabaseName = App.Path & "\MagicManagerDatabases.mdb"
Data1.RecordSource = "Tricks and Routines"
End Sub
here is my code:
Private Sub Command1_Click()
Data1.Recordset.AddNew
End Sub
Private Sub Command2_Click()
With Data1.Recordset
If MsgBox("Delete Record?", vbYesNo) = vbYes Then
.Delete
.MovePrevious
Else: MsgBox ("Record Not Deleted")
End If
End With
End Sub
Private Sub Form_Load()
Data1.DatabaseName = App.Path & "\MagicManagerDatabases.mdb"
Data1.RecordSource = "Tricks and Routines"
End Sub