setvalue

  • Thread starter Thread starter Guest
  • Start date Start date
Execute a sql statement:
Currentdb.Execute "UPDATE tblTest1 SET [Source]='smile'"
Every record in the table will contain smile in the field Source.
 
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?
 
Check your later thread.

--
Duane Hookom
MS Access MVP


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?
 
Back
Top