N
nexus
How do I use the append query in VB codes??
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Ken Snell
Depends on what you want to do:
(1) You can execute a stored append query.
(2) You can open a stored append query.
(3) You can build your own SQL statement for an append query and then
execute the SQL statement.
(4) You can modify a stored query's SQL statement and then execute the
modified query.
(1) You can execute a stored append query.
(2) You can open a stored append query.
(3) You can build your own SQL statement for an append query and then
execute the SQL statement.
(4) You can modify a stored query's SQL statement and then execute the
modified query.
N
nexus
I want to execute a stored append query.
-----Original Message-----
Depends on what you want to do:
(1) You can execute a stored append query.
(2) You can open a stored append query.
(3) You can build your own SQL statement for an append query and then
execute the SQL statement.
(4) You can modify a stored query's SQL statement and then execute the
modified query.
--
Ken Snell
<MS ACCESS MVP>
.
K
Ken Snell
Here's some generic code to do that:
Dim dbs As DAO.Database
Set dbs = CurrentDb()
dbs.Execute "QueryName", dbFailOnError
dbs.Close
Set dbs = Nothing
Dim dbs As DAO.Database
Set dbs = CurrentDb()
dbs.Execute "QueryName", dbFailOnError
dbs.Close
Set dbs = Nothing
N
nexus
Thanks so much!
-----Original Message-----
Here's some generic code to do that:
Dim dbs As DAO.Database
Set dbs = CurrentDb()
dbs.Execute "QueryName", dbFailOnError
dbs.Close
Set dbs = Nothing
--
Ken Snell
<MS ACCESS MVP>
.