docmd.runsql help

  • Thread starter Thread starter Mike Labosh
  • Start date Start date
M

Mike Labosh

What is the best way to run
a select statment to produce a view.
Example link if possible
Click to expand...

If you are creating a view in SQL Server from an ADP Project, you put the
create view statement in a string and then DoCmd.RunSQL the string (I think)

If you are trying to programmatically create an Access query, you need to
create a DAO.QueryDef object, set its SQL property, and then append it to
the QueryDefs Collection of your DAO.Database.
 
What is the best way to run
a select statment to produce a view.
Example link if possible

Regards

Sam
 
The docmd.sql does not work with a select statment
you can do a select into, add delete and update

I will try DAO.QueryDef

Thanking you

Sam
peace
 
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

DELETE FROM a table WHERE... 1
DoCmd.RunSQL "INSERT INTO (append) 4
DoCmd.RunSQL VBA Coding 2
Append Access Data to SQL Server Table 12
DoCmd.RunSQL 9
VBA DoCmd.RunSQL 2
CreateQueryDef Problem 2
Design advice SQL or QueryDef 2

Back
Top