Bob Heygood
bheygood at abestsystems.com
Thu Aug 31 18:35:17 CDT 2006
Yeah. Tried to supply the !Forms.... to the query parameters box even. No luck.... Bob -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Rocky Smolin - Beach Access Software Sent: Thursday, August 31, 2006 4:13 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Query Parameter How do you run it from code? db.Execute? Rocky Bob Heygood wrote: > I have a query that I execute from code. > It has criteria and an alias that references a form control value. > This query works fine when run from the db window. > But complains that "Too few parameters..1 expected.", when run from my code. > > TIA > > Bob Heygood > > > -- Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com