Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 269
  • Last Modified:

MS-Access Query

Is it possible to set the field criteria of a  query to display a list to select from, when the query is called?
0
dibrandt
Asked:
dibrandt
  • 4
  • 2
  • 2
  • +1
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Well, not really ... if you mean to prompt some kind of list, and the user picks an item.  You would need to do that on a Form, when the user makes a selection from a List or Combo box, then run the Query ... and the criteria in the query references the Form's list or combo box.

mx
0
 
dibrandtAuthor Commented:
Thanks,  
Not what I wanted to hear, but it's MS-Access!
0
 
macarrillo1Commented:
Depending on how many options they have, you could alter your prompt.

Instead of

[Please Enter a Value:]

You could have a prompt like:

[Please Enter a valid value: (Option1, Option2, Option3, etc)]

In some older versions of MS Access you could even use ^J (control J) for a new line. So the above could be displayed on two or more lines:

Please Enter a Valid Value:
(Option1, Option2, Option2, etc)

I don't know if this functionality has been retained in the current versions of Access.  You might want to give it a try.
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
Jeffrey CoachmanMIS LiasonCommented:
<Is it possible to set the field criteria of a  query to display a list to select from, when the query is called?>
You can use a Multiselect Listbox...
http://access.mvps.org/access/forms/frm0007.htm
(http://access.mvps.org/access/reports/rpt0005.htm)
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Right ... of course, that list box in on a form ... the query does not make it popup at runtime ...

mx
0
 
dibrandtAuthor Commented:
I've requested that this question be deleted for the following reason:

Question was answered (sort of), points were awarded!
0
 
macarrillo1Commented:
How did you resolve this problem?
0
 
Jeffrey CoachmanMIS LiasonCommented:
<Question was answered (sort of), points were awarded!>
Not that I know of, you are just requesting the the Q be deleted...?
0
 
Jeffrey CoachmanMIS LiasonCommented:
See my post before this one
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 4
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now