G Guest Jul 26, 2007 #1 Having Build a query using the Query design, how can I run this query within VB. Does anybody know the syntax to do this
Having Build a query using the Query design, how can I run this query within VB. Does anybody know the syntax to do this
G Guest Jul 26, 2007 #2 Hi docmd.OpenQuery("QueryName") {Look up in help to check other parameters} hth Andy Hull
G Guest Jul 26, 2007 #3 Is it a select query Docmd.OpenQuery "QueryName" ******************** Or action query - Delete, Edit , Append CurrentDb.Execute ("QueryName") , dbFailOnError
Is it a select query Docmd.OpenQuery "QueryName" ******************** Or action query - Delete, Edit , Append CurrentDb.Execute ("QueryName") , dbFailOnError
