iNPUT BOX IN QUERY

[shaz123]

I have an InputBox date box created in a query, How would i change the title of the input box from "Enter parameter value" to "Works order Import selection". iS IT POSSIBLE

 

[Len Boorman]

I think that if I understand you correctly look at the query itself and you will see the words "Enter parameter value". Change them

L

 

[nikkypickles]

Failing that try typing [Works order Import selection] in the criteria of the field in which you want to search.

 

[Brianwarnock]

This is a spin off from another thread, shaz wants to change the system title of the parameter box, not just name his parameter field, I presume that quite reasonably he wants a short field name but a fuller explanation in the title, how does he achieve this?

Brian

 

[Len Boorman]

Okay Think I am with this one now

The way that I set up a prompt for a parameter is to actually put in the criteria line of the query (In Design view) [Please enter whatever]. This will issue aprompt when the query runs.

The other way is to set the parameter within the query itself.

With the query in design view highlight the column you think contains the parameter, mouse right click and select parameters. Aha I hear you say.

Dialogue box thingy appears listing parameters and theit type ... so think it is here you can actually cahnge the texty bit

Len

 

[shaz123]

Thanxs for the reply people, i just read them, guna try it out.

 

[shaz123]

I dnt think ive explained my self very well,
I have typed this in the query "Between [Please Enter Document Date From yyyymmdd] And [Please Enter Document Too Date yyyymmdd]". this then brings up two input boxes, whic is what i want.
However of you look at the word document loaded, were it says enter "parameter value" at the top of the input box, i would like to change that text to "Works Order LBS Import date Selcetion".

Can it be done