docmd.runsql help

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.
 
S

sam

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

Regards

Sam
 
S

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
 
Top