update record pragrammatically

[Eric W.]

I need to be able to update records in my databse. Can
anyone provide an example of this? Any help is greatly
appreciated. Thanks!

Eric W.
Madison, WI

 

[Alex Dybenko]

easiest way to use update query - add new query, change type to update
query, specify what field to update to what value, add criteria

 

[Brentt]

check out the QueryDefs Collection stright out of
MSAccess help, you can programitically build a sql to
update the record of choice.

 

[endian77]

I need to be able to update records in my databse. Can

anyone provide an example of this? Any help is greatly

appreciated. Thanks!

 

[Adam]

One of the easiest ways is to define a query that does the updates you want,
especially if you have large numbers of records to update. You can then run
the query using the DoCmd.OpenQuery method.

Alternatively, you can update records directly from code. The way you do
this is different depending on whether you use DAO or ADO. If you don't know
about these technologies, have a look at
http://msdn.microsoft.com/library/default.asp?url=/nhp/Default.asp?contentid=28001860

You should also find some code samples there to help you do what you want if
you don't want to use the query method.

HTH

Adam