"Enter Parameter Value" not wide enough

G

Gina K

When I try to open a particular report I'm getting the "Enter Parameter
Value" box. However, the box is not wide enough for me to see exactly what
parameter it's asking for. I tried to drag the box to a bigger size, but I
can't seem to. Is there any way to enlarge this box so I can see exactly
what I'm being prompted to enter (and find where my mistake lies)?

Thank you.
 
S

Scottgem (MVP)

If you didn't plan on using a parameter, that means that Access can't
find some value in your query. What does the part of the box you can
read say?
 
O

Ofer Cohen

You can create a form with three obects

1. Lable that describe the parameter the user need to input
2. A text box where the user select the parameter
3. A button that open the report with a filter using the parameter from the
text box

Dim MyCriteria As String
MyCriteria = "[FieldNameInTable] = " & Me.[TextBoxInForm]
Docmd.OpenReport "ReportName" , , , MyCriteria

Note: If the criteria is on a text field use
MyCriteria = "[FieldNameInTable] = '" & Me.[TextBoxInForm] & "'"
 
O

Ofer Cohen

Sorry, I didn't undestand your question, please ignore my post.


--
Good Luck
BS"D


Ofer Cohen said:
You can create a form with three obects

1. Lable that describe the parameter the user need to input
2. A text box where the user select the parameter
3. A button that open the report with a filter using the parameter from the
text box

Dim MyCriteria As String
MyCriteria = "[FieldNameInTable] = " & Me.[TextBoxInForm]
Docmd.OpenReport "ReportName" , , , MyCriteria

Note: If the criteria is on a text field use
MyCriteria = "[FieldNameInTable] = '" & Me.[TextBoxInForm] & "'"
--
Good Luck
BS"D


Gina K said:
When I try to open a particular report I'm getting the "Enter Parameter
Value" box. However, the box is not wide enough for me to see exactly what
parameter it's asking for. I tried to drag the box to a bigger size, but I
can't seem to. Is there any way to enlarge this box so I can see exactly
what I'm being prompted to enter (and find where my mistake lies)?

Thank you.
Click to expand...
Click to expand...
 
O

Ofer Cohen

In the report check first if the error is in the report control source or
with the report itself

1. Run the report control source separatly, if you get the error check which
filed is in the query but not in the table

2. Check the reprot text boxes, it could be that one of the fields in the
table that the report is bounded to was deleted but it wasn't removed from
the report.

3. If the error caused somewhere in the code in the report, you can press
Ctrl+Break to see where the error is

--
Good Luck
BS"D


:
 
J

julie

When I try to open a particular report I'm getting the "Enter Parameter
Value" box. However, the box is not wide enough for me to see exactly what
parameter it's asking for. I tried to drag the box to a bigger size, but I
can't seem to. Is there any way to enlarge this box so I can see exactly
what I'm being prompted to enter (and find where my mistake lies)?

Thank you.
Click to expand...

hmm... curious
 
Top