K Ken Snell Jul 12, 2004 #2 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.
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.
N nexus Jul 12, 2004 #3 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> . Click to expand...
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> . Click to expand...
K Ken Snell Jul 12, 2004 #4 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
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
N nexus Jul 12, 2004 #5 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> . Click to expand...
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> . Click to expand...
