Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Use the Form to input parameters of a Query
Message
De
13/07/2001 10:29:52
 
 
À
11/07/2001 13:01:47
Information générale
Forum:
Microsoft Office
Catégorie:
Access
Divers
Thread ID:
00529246
Message ID:
00530239
Vues:
15
>My Form's datasource is a Query, this Query need to input a parameter.
>Can I place a input text box on the Form header, use that input to assign to the Query parameter?
>-Jasper

I have used the following for specifying the parameters of a query, although I am not sure how it would work with the query being the form's datasource:

Set dbExtract = CurrentDb

Set qdfExtract = dbExtract.QueryDefs("qryAggregate")
qdfExtract.PARAMETERS("Parm1") = "Value"
qdfExtract.PARAMETERS("Order") = 29
etc..
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform