Hi,
im using vb6 and access 2007 on vista windows. my problem is when i save a record, the record is saved. when im going to save another one it'll save it but it will remove the previous one i saved.
this is the code im using for the
SAVE
vb
If Not IsNumeric(Text1.Text) Then
MsgBox "Crew ID must be numbers only", vbCritical
Text1.SetFocus
End If
Recstr = "select * from addcrew"
adoCrew.Open Recstr, ConConnect, adOpenDynamic, adLockPessimistic
With adoCrew
.AddNew
.Fields("crewid") = Text1.Text
.Fields("lastName") = Text2.Text
.Fields("firstName") = Text3.Text
.Fields("crewstatus") = Text4.Text
.Fields("phone") = Text7.Text
.Fields("email") = Text5.Text
.Fields("Comments") = Text6.Text
MsgBox ("Record saved successfully.")
End With
as you can see it's a simple couple of lines. is there anything im missing?
thank you in advance for any help
m.e.
This post has been edited by PsychoCoder: 2 Apr, 2008 - 08:06 AM
2 Apr, 2008 - 07:46 AM
| 