Parameter Query

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

Does anyone know if the message box header ("Enter Parameter Value") can be
changed when creating a parameter query?

Thanks,
Tom
 
Hi,


Not directly.

You can open a form, with the look you want, any form, and wait there
until a text-edit box is not filled. That text edit box would supply the
parameter to the query that you will launch THEN, at that moment (through
VBA code). You would be able to use the syntax Forms!FormName!ControlName
for the parameter. So, basically, to run the query, you won't instruct your
client to click-open the query... but to click-open ... the form! (or
better, do it through your code from a menu or otherwise...). You see, for
the client, the END EFFECT will be the same, just you, you know that the
form did open before the query started, or after the query started... but
the client doesn't care, really, about what started first ...



Hoping it may help,
Vanderghast, Access MVP
 
Michael:

Thanks for the feeedback... I got the idea but I'm not sure if I really
understand as to how it should be done...

- what do you mean by "and wait there until the text-edit box is not
filled"?

do you have any more pointers as to how I could create this procedure...
form, query, etc.?

Thanks,
Tom
 
Hi,

Clearly, your code have to wait that the edit text box is filled before
launching the query. One way to do that is to supply two buttons, OK,
Cancel. On Cancel, you close the form and that's it. On a click on OK, you
do not close the form, but instead, you launch the query. That assumes you
have some proficiency using VBA code, but you can get most of the job done
with button wizards, I assume. Just start a new form, be sure the wizard
wand is active, and add the two buttons, one to close the form, one to open
a query.


Hoping it may help,
Vanderghast, Access MVP
 
Thanks, that works great!!!

Tom



Michel Walsh said:
Hi,

Clearly, your code have to wait that the edit text box is filled before
launching the query. One way to do that is to supply two buttons, OK,
Cancel. On Cancel, you close the form and that's it. On a click on OK, you
do not close the form, but instead, you launch the query. That assumes you
have some proficiency using VBA code, but you can get most of the job done
with button wizards, I assume. Just start a new form, be sure the wizard
wand is active, and add the two buttons, one to close the form, one to open
a query.


Hoping it may help,
Vanderghast, Access MVP
Click to expand...
 
Back
Top