Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

update access field using vb

Status
Not open for further replies.
jono261970

jono261970

Programmer
Jun 28, 2002
182
0
0
GB
hello,

I am using the following code to update a field in access. My aim is to actually overwrite the existing data and not append.Could somebody help me with this?


rs1.AddNew

rs1!year7 = Text3.Text
rs1.Update

thanks in advance

jono


A good fortune may forbode a bad luck, which may in turn disguise a good fortune.
 
Sort by date Sort by votes
Assuming that you are using DAO, change
Code: 
   rs1.AddNew
To
Code: 
   rs1.Edit

If you are using ADO then eliminate the AddNew.
 
Upvote 0 Downvote
thank you so much golom.

jono


A good fortune may forbode a bad luck, which may in turn disguise a good fortune.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
UPDATE DAO RECORDSET 1
Replies
11
Views
123
strongm
strongm
2009luca
  • Locked
  • Question
graph with access database - im on vb6 2
Replies
10
Views
188
strongm
strongm
sal21
  • Locked
  • Question
ARRANGE this Access coe to vb6
Replies
4
Views
80
strongm
strongm
Niki_S
  • Locked
  • Question
How to read an excel file using VB 6?
Replies
17
Views
181
strongm
strongm
Niki_S
  • Locked
  • Question
How to insert excel sheet into sql server using vb 6?
Replies
6
Views
98
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top