Solved

What does "Enter Parameter Value" mean?

Posted on 2007-04-03
17
471 Views
Last Modified: 2013-11-28
I have a tblOrganization from which I'm making labels.  I have made a macro for each label group.  This is such a simple question, don't scoff, but when I use the macro I get a box "Enter Parameter Value". what do I put in the box?
0
Comment
Question by:Cheryl60
  • 8
  • 5
  • 3
  • +1
17 Comments
 
LVL 9

Expert Comment

by:TheSloath
ID: 18847713
Hi again

What is the name of the parameter it is asking for?

If it is an unexpected request, it usually means there is a typo in the query or your where clause in the Macro maybe...
0
 

Author Comment

by:Cheryl60
ID: 18847880
Oh, I'm glad it's you.
hummmmm President.  Does that mean all that I have to do is type in President?  That worked (**)  
Why does it need to ask and can I ask it not to do that?
Cheryl
0
 
LVL 9

Expert Comment

by:TheSloath
ID: 18847899
That means you have entered the word 'President' somewhere as if it is a field name.

Have you forgotten to put quote marks around the word President in your where clause in the macro?
0
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 

Author Comment

by:Cheryl60
ID: 18847977
Quote marks!!   What quote marks?
I went back in and added those quote marks.  It didn't seem to make any difference and when I let it print, it printed all of the differnt member, not just the Presidents.
0
 

Author Comment

by:Cheryl60
ID: 18848150
I guess the question about Parameter Value has been answered except, Can you turn that box off?



0
 
LVL 9

Expert Comment

by:TheSloath
ID: 18849047
Copy and Paste the Where Clause into here please - so I can see it
0
 
LVL 57
ID: 18850139
Cheryl,

<<I guess the question about Parameter Value has been answered except, Can you turn that box off?>>

  Yes and no.  You get the box because somewhere you used a value that Access can't resolve; in other words, it doesn't know what value to use.

  For example, if you refer to a control in a form from a query:
 
  =Forms![myForm]![myControl]

  and that form is not open or 'myControl' doesn't exist on the form, you'll get prompted for a parameter value with the dialog box.  

  So you turn "off" the dialog by fixing the problem that exists.

HTH
JimD
0
 

Author Comment

by:Cheryl60
ID: 18852610
Mr. Sloath,

This is the copy and paste   ["President"]
0
 

Author Comment

by:Cheryl60
ID: 18852682
Jim,

That was a good explantion and it makes sense.  I recently read an article about null values which is like a parallel problem for Access but easier to solve.  What might be the missing information in such a short program?  Perhaps the quotes that Mr. Sloath is helping me with.

Cheryl
0
 
LVL 57
ID: 18852914
Cheryl,

<<That was a good explantion and it makes sense.  I recently read an article about null values which is like a parallel problem for Access but easier to solve.  What might be the missing information in such a short program?  Perhaps the quotes that Mr. Sloath is helping me with.>>

  No, Access could handle a Null, which is the absence of a value.

  What I should have said before is:

"You get the box because somewhere you used a reference that Access can't resolve; in other words, it doesn't know what value to use."

  It's the reference you used somewhere that is the problem.  Your are telling Access to look somewhere and what you told it to look at it cannot find.

  This is usually a mis-spelled field or control name, something that doesn't exist, or a form or report that is not open.

  If your references were correct, it could locate the reference and use it, get the value NULL, and it would use that to carry out the operation without prompting you with the dialog box for the parameter.

JimD
0
 

Author Comment

by:Cheryl60
ID: 18853133
Jim,
Then a null value and the missing information which brings up the 'Enter Parameter Value' aren't simlar?  I just remember seeing a message that a null value wasn't acceptable.
Thanks for your help, Cheryl
0
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 25 total points
ID: 18853769
<<Then a null value and the missing information which brings up the 'Enter Parameter Value' aren't simlar? >>

  Corrent.  A null is defined as the absense of a value.  But in a sense, it is still a "value" and Access won't have any problems dealing with it.

  To make that a bit clearer, if you click OK in the parameter value dialog without entering anything, you just handed Access a null value, and it's happy with that.

<<I just remember seeing a message that a null value wasn't acceptable.>>

  In some cases it may be not be, but here it is not what is causing the problem.

JimD
0
 
LVL 9

Assisted Solution

by:TheSloath
TheSloath earned 25 total points
ID: 18853814
Loose the square brackets, i.e.:

"President" not ["President"]
0
 

Author Comment

by:Cheryl60
ID: 18855836
The 'Enter Perameter Value' box didn't pop up and it printed, that was good, but it printed all of the roles.

I can't think of how it would have been given the information it needs to filter them.  
So far I have: one table,tblOrganization with a fied for Roles, a macro for each Role.
What could I be missing?

Cheryl
0
 

Author Comment

by:Cheryl60
ID: 18860966
Good Day Mr. Sloath,

Is it OK to finish this question by getting the label report to print by roles, or should I close this one out and ask a new question?

Cheryl
0
 
LVL 9

Expert Comment

by:TheSloath
ID: 18875046
Just ask a question
0
 
LVL 35

Expert Comment

by:ShineOn
ID: 20656668
To TheSloath:

"Loose" (pronounced "luce" with a sibilant, or soft, "c") is the opposite of "tight" or "restrain."

I think you meant to say "Lose" (pronounced "luze") as in the opposite of "find" or "obtain."

- The Grammar Police... ;)
0

Featured Post

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
StrPtr doesn't compile in MS Access 2013 64 bit 3 45
Check a field in Access on a Timer 1 28
MS Access Weekly query 11 42
Union & Crosstab qrys 101! 6 53
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Familiarize people with the process of utilizing SQL Server stored procedures 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 Micr…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

685 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