Bob Heygood
bheygood at abestsystems.com
Fri Sep 1 00:12:20 CDT 2006
Thanks Rocky -----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:55 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Query Parameter I usually make a public function in a module which return the value from the forms and call that function in the criteria line on the QBE grid. Don't forget the () in the call on the QBE grid. Rocky T Bob Heygood wrote: > 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 > > > -- 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