update record pragrammatically

  • Thread starter Thread starter Eric W.
  • Start date Start date
E

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
 
easiest way to use update query - add new query, change type to update
query, specify what field to update to what value, add criteria
 
check out the QueryDefs Collection stright out of
MSAccess help, you can programitically build a sql to
update the record of choice.
 
I need to be able to update records in my databse. Can

anyone provide an example of this? Any help is greatly

appreciated. Thanks!
 
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
 
Back
Top