G
Guest
My Access VBA Manual (Smith and Sussman) suggests that a shortcut to writing
SQL strings for a novice is to use the qbe grid to design the required query
and then copy/pasting from SQL view into a vba procedure to create something
like strSQL = "pasted bit" followed by qdf.SQL = strSQL ( having 'dimmed' and
'set' qdf etc as required and having sorted out line breaks, quotes etc in
the pasted text.
However this rarely works and produces error messages about syntax and/or
missing bits, even though it compiles successfully. My Question is - is there
a good source of information about the differences in syntax rules between
the SQL in " SQLview" and SQL used in vba procedures? I am using Access 2003
with DAO.
SQL strings for a novice is to use the qbe grid to design the required query
and then copy/pasting from SQL view into a vba procedure to create something
like strSQL = "pasted bit" followed by qdf.SQL = strSQL ( having 'dimmed' and
'set' qdf etc as required and having sorted out line breaks, quotes etc in
the pasted text.
However this rarely works and produces error messages about syntax and/or
missing bits, even though it compiles successfully. My Question is - is there
a good source of information about the differences in syntax rules between
the SQL in " SQLview" and SQL used in vba procedures? I am using Access 2003
with DAO.