Parameter Blues..

[Metrazal]

I have a situation where I have created a query and I want to prompt the user for specific criteria. Therefore in the criteria field I type [Enter Item Number:] When I run the query I get a prompt and I input 12345 in the input box and press ok. Unfortunately, I get no results from my querry. However, if I type = "12345" in the criteria field and run the query, I get the returns I expect. Any help in resolving this issue would be appreciated.


Thanks,



MET

[ranman256]

Try converting it to string by surrounding the param....CSTR( [Enter Item Number:])

[Metrazal]

Try converting it to string by surrounding the param....CSTR( [Enter Item Number:])

Darn. I was hoping your suggestion would work but no cigar. Same Results. Thanks for the suggestion in any case.


MET

[ranman256]

That is odd because you dont have to enter quotes around a param to get results. I do it all the time.
Unless your values ACTUALLY have the quotes in the table.

[Metrazal]

Actually, you can type =12345 in the criteria and get the desired results also. I included the quotes because Access auto inserts the quotes if you do not include them. Again, thanks for the reply.

MET

[Metrazal]

Actually, you can type =12345 in the criteria and get the desired results also. I included the quotes because Access auto inserts the quotes if you do not include them. Again, thanks for the reply.

MET

Still no luck. Can I build an event in a form to have a user input this criteria? Using [Enter Info] parameter just does not seem to work.


Thanks,

MET

[pbaldy]

Most of us would use a form to gather the user input anyway; you have a lot more control over the process that way. Instead of [Enter...] in the criteria, you'd have:

Forms!FormName.TextboxName

[June7]

Agree with pbaldy.

I NEVER use dynamic input popup prompts.

Review http://www.datapigtechnologies.com/f...tomfilter.html

But I don't use dynamic parameter queries. I use:

DoCmd.OpenForm "form name", , , "Item='" & Me.textboxName & "'"

Regardless, it does seem odd that your popup prompt doesn't work.

[hapm]

Would be nice to see the SQL of the query, to see how the parameter is used.

[rpeare]

try using cstr([Fieldname]) on the field you're searching then putting in the criteria cstr([Enter the String]) (or whatever you want your prompt to be, this would force both the field and the search string to be strings in case one or the other is not.

[Metrazal]

Thanks to everyone for their input. To resolve this issue I added a wild-card to the parameter. Like [ENTER ITEM NUMBER:] & "*" My data must have had some hidden spaces in it but not sure why it worked when I manually input the criteria without wildcards. Anyway, once again thanks for the suggestions.

[rpeare]

if you trim the field you're entering the dynamic criteria for you should be fine too..

create a field based on the field you're searching and do something like TestValue: trim([Fieldname])

Then in your criteria

[Enter Item Number] should work just fine.