Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Strange question maybe
- Thread starter Tom123456
- Start date
I don't really understand why you say..
I don´t want to use SQL because that are very many records that should be updated.
You can update all the records in the db with one SQL statement if you want.
eg.
"UPDATE tblTable SET fldOne = '" & Me.product1 & "'"
Would update every record in tblTable by setting fldOne to the value of Me.product1
There are two ways to write error-free programs; only the third one works.
I don´t want to use SQL because that are very many records that should be updated.
You can update all the records in the db with one SQL statement if you want.
eg.
"UPDATE tblTable SET fldOne = '" & Me.product1 & "'"
Would update every record in tblTable by setting fldOne to the value of Me.product1
There are two ways to write error-free programs; only the third one works.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
