Hale, Jim
Jim.Hale at FleetPride.com
Fri Aug 27 17:38:13 CDT 2004
Yes, that gives me a type mismatch Jim -----Original Message----- From: Jim Hewson [mailto:JHewson at karta.com] Sent: Friday, August 27, 2004 11:16 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Correct syntax for parameter query Have you tried: qdfTemp(7).Parameters(strParameters(4)) = "sales" OR "misc" -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Hale, Jim Sent: Friday, August 27, 2004 10:54 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Correct syntax for parameter query Thanks, but no joy. I think what I am attempting to do is not possible. The workaround is to reopen the recordset for each change in the parameter. Thanks anyway Jim Hale -----Original Message----- From: Stuart McLachlan [mailto:stuart at lexacorp.com.pg] Sent: Thursday, August 26, 2004 5:21 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Correct syntax for parameter query On 26 Aug 2004 at 14:06, Hale, Jim wrote: > qdfTemp(7).Parameters(strParameters(4)) = "sales" > qdfTemp(7).Parameters(strParameters(5)) = strPlGroup > > Set recset(7) = qdfTemp(7).OpenRecordset() > > This works fine. However, I need to change parameter(4) into something like > the following > qdfTemp(7).Parameters(strParameters(4)) = "sales or misc" Try "'sales' or 'query'" ie put the individual items in single quotes.-- Stuart -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com