Create an append query in visual basic

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

Guest

I'm just starting out in Access and want to change all records in a field
from "Yes" to "No" using vb and not use an append query. Then I can use a
button on my form to print the report based on the query and before returning
to the form reset the field.
 
I assume you are looking for update query and not Append query.
You can run both using VBA

Docmd.OpenQuery "QueryName"
will run the query that update all the fields from Yes to No

Or
Docmd.RunSql "UPDATE TableName SET FieldName = False WHERE FieldName =True"

=====================================================
You might want to set the warnings to false before running the update sql,
so the user wont be prompt with a message saying how many records will be
updated

Docmd.SetWarning False
' Run here the query or SQL
Docmd.SetWarning True
 
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

Append Query 3
Append Messages 1
Apply Sequence Number in Append Query 2
return primary key for record after append query 3
Data Defnition Query 1
Combining PDF files within visual basic 2
Create append/delete query into a table that has multi-valued fiel 2
How to write an append query on a recordset 1

Back
Top