Updatefields in once

[hwakern]

I want to replace my balance available fields on every employee at the end of every month with the field total allowance.please help me
i'm using Access and ado.
my table name coupon deduction and with fields
employee id, total allowance, balance available, total use

from hwa kern

[jonaxse]

Im assuming you know how to connect ADO to an ODBC data source with a datasource name of 'Sample'.


Dim dbConn as New AdoDB.Connection

dbConn.Open "Data Source=Sample"

dbConn.Execute "UPDATE Employees SET Allowance=50"

=================
if a condition is present;
dbConn.Execute "UPDATE Employees SET Allowance=50 WHERE ID='dirtbag'"

=================
There yah go... that should do the trick. Pretty easy isnt it??

Jonn