How to change "Enter Parameter Va... ?" text at top of dialogue box

[mikenyby]

Hey y'all!

You know this box:

Does anybody know if there's a way to get the "Enter Parameter Va... ?" text banner at the top of the box to not appear? Or change the text there?

Best-
Mike

 

[theDBguy]

Hi. It's probably possible using some API. It might be easier to just use a Form though. Just a thought...

 

[GPGeorge]

Hey y'all!

You know this box:
View attachment 99907

Does anybody know if there's a way to get the "Enter Parameter Va... ?" text banner at the top of the box to not appear? Or change the text there?

Best-
Mike

Context is King. Where and when does this appear?

 

[mikenyby]

Context is King. Where and when does this appear?

I have a number of forms and reports opened by control buttons on the home screen of my databse. Each one of them has a field in the linked query with a [Enter xxx:] criteria. I'm just wondering if anyone has found a way to adjust the default design of the parameter value dialogue box that opens for any parameter query.

 

[GPGeorge]

I have a number of forms and reports opened by control buttons on the home screen of my databse. Each one of them has a field in the linked query with a [Enter xxx:] criteria. I'm just wondering if anyone has found a way to adjust the default design of the parameter value dialogue box that opens for any parameter query.

Thanks. Unfortunately, the answer is "no" that's not an option in the basic query designer, BUT with a qualification. If want something different, you could code it up in VBA and collect the parameter that way. Call that Function instead of using the default in the queries.

 

[mikenyby]

Thanks. Unfortunately, the answer is "no" that's not an option in the basic query designer, BUT with a qualification. If want something different, you could code it up in VBA and collect the parameter that way. Call that Function instead of using the default in the queries.

Thanks, that's pretty far beyond my current skillset and there's not much time left in my contract before I hand the database over to my employers, so I'll work on more functional things. Adjusting the box was really just for vanity's sake.

 

[GPGeorge]

Document it on the Checklist for "Phase Two" and make sure they keep your phone number.

 

[mikenyby]

Lol good plan!

 

[Pat Hartman]

Rather than having the query prompt for a value, add unbound controls to the form and have the user enter the criteria FIRST. That also gives you the opportunity to validate it and to provide defaults if that makes sense. And the additional benefit is that when you are opening a report, you won't get prompted a second time if you decide to print the report.