Solved

MS-Access Query

Posted on 2012-04-08
11
260 Views
Last Modified: 2012-05-14
Is it possible to set the field criteria of a  query to display a list to select from, when the query is called?
0
Comment
Question by:dibrandt
  • 4
  • 2
  • 2
  • +1
11 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 500 total points
ID: 37821697
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
 

Author Comment

by:dibrandt
ID: 37823621
Thanks,  
Not what I wanted to hear, but it's MS-Access!
0
 
LVL 9

Expert Comment

by:macarrillo1
ID: 37823964
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
How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37824769
<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
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37824782
0
 
LVL 75
ID: 37824806
Right ... of course, that list box in on a form ... the query does not make it popup at runtime ...

mx
0
 

Author Comment

by:dibrandt
ID: 37967944
I've requested that this question be deleted for the following reason:

Question was answered (sort of), points were awarded!
0
 
LVL 9

Expert Comment

by:macarrillo1
ID: 37961226
How did you resolve this problem?
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37967943
<Question was answered (sort of), points were awarded!>
Not that I know of, you are just requesting the the Q be deleted...?
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37967945
See my post before this one
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question