[AccessD] Automating parameterized action queries.....

Sad Der accessd666 at yahoo.com
Tue Mar 8 07:05:09 CST 2005


yes, the global variables need to be filled. If the
user runs the query manually (thus by double clicking
it in the database container) the global var isn't
filled.

Thnx anyway.

--- "A.D.Tejpal" <adtp at touchtelindia.net> wrote:
> Sander,
> 
>     Any objection to using global variables ?
> 
> A.D.Tejpal
> --------------
> 
>   ----- Original Message ----- 
>   From: Sad Der 
>   To: Acces User Group 
>   Sent: Tuesday, March 08, 2005 13:45
>   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 



More information about the AccessD mailing list