How to change existing table record value by VBA and How to add new
in [Tables]
|
Prev: How to change existing table record value by VBA and How to add new record in existing table by VBA
Next: Use Schedule Task to run Updates, but bypass User-Level Securi
From: XPS35 on 18 May 2010 04:20 K wrote: > > Hi all, I got table in my database with name "tbldata" and i have two > fields in that table with the name "Ticket_No" and "Amount". In > "Ticket_No" filed column i have value "SD001" and in same row of > "Amount" column i have figure "50". With VBA how can i lookup for > value "SD001" in "Ticket_No" field and change figure "50" to "30" > which is appearing in same row of "Amount" column field. My other > question is that how can i add new record in same table with VBA. I > want to put new value "VR004" in "Ticket_No" field column and new > figure "20" in same row of "Amount" column. I'll be very greatful if > any friend can help me with simple vba code on this. The code for the update is: DoCmd.RunSQL "Update tbldata SET Amount=30 WHERE Ticket_No='SD001'" And for adding a rcord: DoCmd.RunSQL "INSERT INTO tbldata(Ticket_No,Amount) VALUES('VR004',20)" -- Groeten, Peter http://access.xps350.com |