Bobby Heid
bheid at appdevgrp.com
Tue Mar 8 08:26:21 CST 2005
Why not have two sets of queries, one set that looks to a form (this one is called programmatically), and one set that queries the user for the parameters? Bobby -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Sad Der Sent: Tuesday, March 08, 2005 8:10 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Automating parameterized action queries..... You are correct. However the queries are not executed via from several forms but they are executed: 1- via one form 2- a user manually clicks it in the database container. The process is as follows: 1 - the reports (xls files) are stored in the database 2 - the queries that create the report are also stored in the database 3 - the user selects a report 4 - the necessary queries are executed one by one However, several times a week a manager requests a part of the report that is slightly different from the original. A user then must have the change to quickly adjust the query and run it manually. HTH Sander --- Bobby Heid <bheid at appdevgrp.com> wrote: > If you are not wanting to encode a particular form > field because the query > is called from several forms, might I suggest that > you create a new hidden > form that contains fields for all of the fields that > are used as parameters. > Then the queries can access these fields. > > You would need to set the fields on the form before > the queries were > executed. > > Bobby > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On > Behalf Of Sad Der > Sent: Tuesday, March 08, 2005 3:15 AM > To: Acces User Group > Subject: [AccessD] Automating parameterized action queries..... > > > Hi group, > > my story of the queries continues. I need to run a > set > of action queries. This works fine. > > Several queries have parameters. So that means the > user has to watch the screen for a parameter to > pop-up. Is it possible to add some parameter fields > in > the form to fill the required parameters...WITHOUT > changing the query it self? > > So I have a parameters in my query: > [Enter version:] > [Enter startdate:] > > And I do not want to change these to: forms!frmReport!txtVersion > forms!frmReport!txtStartDate > > TIA > > Sander > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com