DAO: Update a database record

[Lekster07]

Hi everyone!

Can anyone share a code on how to update a record in an MS Access database using DAO?

Say for example, I have an MS Access Database named friendsdob, with "ID"(autonum), "full_name", and "dob" as columns/fields. let's say there is a record in ID number 7, and i want to change/update the Name in the "full_name" field. What should be the appropriate code?

Thanks in advance!

 

[Lekster07]

Hi everyone!

Can anyone share a code on how to update a record in an MS Access database using DAO?

Say for example, I have an MS Access Database named friendsdob, with "ID"(autonum), "full_name", and "dob" as columns/fields. let's say there is a record in ID number 7, and i want to change/update the Name in the "full_name" field. What should be the appropriate code?

Thanks in advance!

By the way, I'm still using MS Excel to house the form that I'm gonna use because I'm still learning Visual Basic.