setvalue

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there, how do I set the value "smile" of a field Source in table tblTest1?
 
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?
Click to expand...
Click to expand...
 
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?
Click to expand...
Click to expand...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update all records in VBA 1
TEXT data type length? 5
Run a macro and pause before running second macro 1
Set a value in VB 4
Plain vanilla orders database: Unit price question (because there aretwo unit price fields) 2
setting the argument in SETVALUE Action of macro 6
SetValue in Access 2007 2
Why is Smiling a Donation? 1

Back
Top