Can I change a value in table

  • Thread starter Thread starter ericsson
  • Start date Start date
E

ericsson

Hi
I´ve tryed to type a Sub in a Module, and it should change a value in
table.

In a open form, I change the value with the 'Me![Feld1] = newvalue' syntax.

Can I do the same in a table ? Wath´s the syntax?

Does anyone now a good Internetsite with examples regarding Access.

//Lasse
 
Execute an Update query statement.

1. Create a query into this table.
2. Change it to an Update query.
3. Drag Field1 into the grid.
4. Type the newvalue into the Update row.
5. Add any criteria you need to get the right row.
6. Switch to SQL View (View menu).

You can now see the string you need to create.
You code will then be:
strSQL = "UPDATE ...
dbEngine(0)(0).Execute strSQL, dbFailOnError
 
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

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Access Passing the value to a table 1
Access Macro Repeat Expression using value of a field in table 0
Update fields size or type of one table 1
Need to modify a module in order to stop variance in results 1
3163 Field is too small 2
Appending records to new table using field names as values 2
Access Dcount (multiple criteria) 3

Back
Top