Parameter query

  • Thread starter Thread starter Ray
  • Start date Start date
R

Ray

Is there a way of creating a pull down menu of specific
paramaters (ie names)that are already in the adta base so
that you do not have to type in the query string you want
all the time?

thanks in advance

ray
 
Not using the built-in parameter dialog box, but you can do it with a custom
form. For example, the following query assumes that the MDB contains a form,
"frmTest", with the required data in a combo box, "cboTest" ...

SELECT * FROM SomeTable WHERE SomeTable = Forms!frmTest!cboTest

The form must be open when the query is run.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
CAn you send me a small example?
-----Original Message-----
Not using the built-in parameter dialog box, but you can do it with a custom
form. For example, the following query assumes that the MDB contains a form,
"frmTest", with the required data in a combo box, "cboTest" ...

SELECT * FROM SomeTable WHERE SomeTable = Forms!frmTest! cboTest

The form must be open when the query is run.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E- mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e- mail, you'll find
a useable e-mail address at the URL above.





.
Click to expand...
 
Microsoft have an article on this, with step-by-step instructions, at the
following URL ...

http://office.microsoft.com/assista...ID=HA011170771033&CTT=4&Origin=CH011232671033

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
Back
Top