How to replace a record in Microsoft Access 97 with VB 6.0
I create a program with vb 6.0 and i connected with ms access 97.
Now i don't know how to replace an existing record.
For example i have the field "A" and the record is "20" now i want to replace "20" with "15"
Software/Hardware used:
Software/Hardware used:
ASKED:
January 17, 2009 3:40 AM
UPDATED:
January 19, 2009 2:18 PM
Answer Wiki:
How are you connecting to the database (dao, ado, rdo, data environment, etc...) ?
You could do that using a SQL UPDATE statement., which would be something like this:
UPDATE <table_name> SET <field_name> = <new value>
WHERE <conditions>
Please provide more details, so we can provide more help.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
