G
Guest
Hi there, how do I set the value "smile" of a field Source in table tblTest1?
Duane Hookom said:Execute a sql statement:
Currentdb.Execute "UPDATE tblTest1 SET [Source]='smile'"
Every record in the table will contain smile in the field Source.
--
Duane Hookom
MS Access MVP
Ray Mead said:Hi there, how do I set the value "smile" of a field Source in table
tblTest1?
Ray Mead said:Thanks Duane, can I change the tblTest1 to a variable?
Duane Hookom said:Execute a sql statement:
Currentdb.Execute "UPDATE tblTest1 SET [Source]='smile'"
Every record in the table will contain smile in the field Source.
--
Duane Hookom
MS Access MVP
Ray Mead said:Hi there, how do I set the value "smile" of a field Source in table
tblTest1?