Member Avatar for jaasaria

i have a problem about my database when i press sa save comand button it goes something like that...

run time error -2147467259
operation must use an updateable quary..


i cant detect the true error...
help help


the code in my save are corect check this...
Sub saverecord()
rsemployee.AddNew
rsemployee.Fields("EmployeeID") = txt1.Text
rsemployee.Fields("EmployeeName") = txt2.Text
rsemployee.Fields("EmployeePosition") = txt3.Text
rsemployee.Fields("Address") = txt4.Text
rsemployee.Fields("Age") = txt5.Text
rsemployee.Fields("Gender") = txt6.Text
rsemployee.Fields("PhoneNo") = txt7.Text
rsemployee.Update

End Sub


plsssssssssssssss help

  • 3 Contributors
  • 3 Replies
  • 111 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by choudhuryshouvi
Member Avatar for ryan_vietnow

try replacing rsemployee.Update with
rsemployee.Save

Member Avatar for choudhuryshouvi

hi Jaasaria,
thanks for ur reply.
if u got ur answer then plz mark this thread as solved.

bye

regards
Shouvik

commented: thxxxxx for helping me.. +1
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.