paul.hartland at fsmail.net
paul.hartland at fsmail.net
Mon Mar 21 05:51:29 CST 2005
it evaluates to strSQL = qryKPI_SickDays_By_Region_By Month3 '01/01/05', '31/01/05' which is inside Set rsKPIData = OpenDataConn.Execute(strSQL) Message date : Mar 21 2005, 11:42 AM >From : "Gustav Brock" To : accessd at databaseadvisors.com Copy to : Subject : Re: RE: [AccessD] Running Access Query With Parameters From VB6 Hi Paul It is the result of this expression we need: strQueries(intQuery) & " '" & dtKPIStart & "', '" & dtKPIFinish & "'" /gustav >>> paul.hartland at fsmail.net 03/21 12:26 pm >>> Just an error message like below: Run-time error '-2147217900 Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT' or 'UPDATE -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- Whatever you Wanadoo: http://www.wanadoo.co.uk/time/ This email has been checked for most known viruses - find out more at: http://www.wanadoo.co.uk/help/id/7098.htm