استخدم هذا الكود مع اى فورم
هذا للاضافة
Dim db As DAO.Database
Dim rst As DAO.Recordset
Set db = CurrentDb
Set rst = db.OpenRecordset("tabr", dbOpenDynaset)
With rst
.AddNew
![id] =
![nom] =
![sand] =
![datee] =
![resever] =
![rasee] =
![faree] =
![onde] =
![oytde] =
![indo] =
![outdo] =
![daleel] =
![notes] =
![years] =
.Update
.Close
End With
Set rst = Nothing
db.Close
Set db = Nothing
عطل ما تريد تعطيله
وفعل ما تريد ترحيله
------------------------------------------
هذا للتعديل
Dim db As DAO.Database
Dim rst As DAO.Recordset
Set db = CurrentDb
Set rst = db.OpenRecordset("tabr", dbOpenDynaset)
With rst
.FindFirst Criteria:=
If Not .NoMatch Then
.Edit
![id] =
![nom] =
![sand] =
![datee] =
![resever] =
![rasee] =
![faree] =
![onde] =
![oytde] =
![indo] =
![outdo] =
![daleel] =
![notes] =
![years] =
.Update
End If
.Close
End With
Set rst = Nothing
db.Close
Set db = Nothing
اتمني هذا ما تريده