More ways to Update a field in a table

[FuzMic]

Hi members

Looking at the number of ways to update a field in a table; I had use the following 3 ways:

1. If there is a form opened bounded to the underlying table, i just assign a new value to the field, then on Form.Update, the change is reflected in the table.

2. I could .execute an Update query string wherein a particular record from a table is selected with a criteria and then update the target field.

3. I could .open an ODBC.recordset selecting again that particular record from a table using a criteria and then assign the !field and do .update.

The question: Is there another method to do the same, some sort of function like the Aggregate functions DSum, etc.

Cheers!

 

[Galaxiom]

DoCmd.RunSQL "query string"

Recordsets are ADO or DAO.
DAO uses the Update command but it is automatic in ADO.

If the table was connected to Excel the cell could be changed using code.

If the table was based on a text file it could be changed as a text object.

You could write a function that looked a bit like a domain function at least on the outside.

 

[FuzMic]

Thanks Galaxiom

I was actually referring to ADODB.recordset and using it most of the time; not ODBC.

 

[Galaxiom]

Microsoft loves A and D
ADODB, DAO, ODBC, ADP, DAP
No doubt there are others