-
Using DAO to update a record in VBA
I'm trying to use DAO to first add and then subsequently update a record with a count. I'm using rs.addnew and rs.update for the insert and rs.edit and rs.update to update the current record. The problem is that every time I try to update a new record is inserted with the decremented count. So if I update the record 6 times I have 6 records, with the count going from 6 to 1. How do I get DAO to just update the record instead of inserting records?
Similar Threads
-
By jim12345 in forum VB Classic
Replies: 1
Last Post: 04-15-2006, 01:28 PM
-
By JeePee in forum Database
Replies: 7
Last Post: 02-18-2005, 02:42 PM
-
By james in forum VB Classic
Replies: 2
Last Post: 07-02-2002, 05:59 AM
-
By Andrew McLellan in forum Java
Replies: 3
Last Post: 05-09-2001, 05:34 PM
-
By aterren in forum VB Classic
Replies: 2
Last Post: 09-14-2000, 04:31 AM
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Development Centers
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center
|