Dialogue box header

[Guest]

Hi,

I have a made query with the following criteria in the date field of the Table
<=[End Date]
now when I execute I get box with a header titled "Enter Parameter Value"
for the end date. My question is that how can I modify this box header, some
thing which is useful to the users - like "PLEASE ENTER THE CLOSING DATE" or
some thing similar.
Thanks in advance
Anver

 

[Guest]

Dear
Please be more simple - where to put that square brackets? in the query date
field? or where?

please advise

Rgds

Put what you want your users to see in the square brackets.

HTH
--
-Larry-
--

Hi,

I have a made query with the following criteria in the date field of the Table
<=[End Date]
now when I execute I get box with a header titled "Enter Parameter Value"
for the end date. My question is that how can I modify this box header, some
thing which is useful to the users - like "PLEASE ENTER THE CLOSING DATE" or
some thing similar.
Thanks in advance
Anver

 

[Larry Daugherty]

Put what you want your users to see in the square brackets.

HTH

 

[Joan Wild]

You currently have <=[EndDate] as the criteria. Change it to

<=[Please Enter the Closing Date]



--
Joan Wild
Microsoft Access MVP

Dear
Please be more simple - where to put that square brackets? in the
query date field? or where?

please advise

Rgds

Put what you want your users to see in the square brackets.

HTH
--
-Larry-
--

Hi,

I have a made query with the following criteria in the date field of the Table
<=[End Date]
now when I execute I get box with a header titled "Enter Parameter
Value" for the end date. My question is that how can I modify this
box header, some
thing which is useful to the users - like "PLEASE ENTER THE CLOSING
DATE" or some thing similar.
Thanks in advance
Anver

 

[Larry Daugherty]

From MS Access Help: I"n the Criteria cell for each field you want to
use as a parameter, type a prompt enclosed in square brackets.
Microsoft Access will display this prompt when the query is run. The
text of the prompt must be different from the field name, although it
can include the field name."

HTH
--
-Larry-
--

Dear
Please be more simple - where to put that square brackets? in the query date
field? or where?

please advise

Rgds

Put what you want your users to see in the square brackets.

HTH
--
-Larry-
--

Hi,

I have a made query with the following criteria in the date

field of
the Table

<=[End Date]
now when I execute I get box with a header titled "Enter

Parameter
Value"

for the end date. My question is that how can I modify this box header, some
thing which is useful to the users - like "PLEASE ENTER THE

CLOSING
DATE" or

some thing similar.
Thanks in advance
Anver

 

[Guest]

Dear,

After entering that I got the following:-

Enter Parameter Value
Please Enter the closing Date
Here I am talking about the main header as - Enter Parameter Value - How to
modify this ?
I mean I don't want the "Enter Parameter Value" header instead some thing
user friendly.

Please Help

You currently have <=[EndDate] as the criteria. Change it to

<=[Please Enter the Closing Date]



--
Joan Wild
Microsoft Access MVP

Dear
Please be more simple - where to put that square brackets? in the
query date field? or where?

please advise

Rgds

Put what you want your users to see in the square brackets.

HTH
--
-Larry-
--

Hi,

I have a made query with the following criteria in the date field of
the Table
<=[End Date]
now when I execute I get box with a header titled "Enter Parameter
Value" for the end date. My question is that how can I modify this
box
header, some
thing which is useful to the users - like "PLEASE ENTER THE CLOSING
DATE" or some thing similar.
Thanks in advance
Anver

 

[Joan Wild]

You can't change that. If you want more control over the displayed prompt,
then create an unbound form to capture the criteria.

You can change the caption property of the form to whatever you like.

Add a textbox to the form to enter the date, and a command button to open
the query (or form/report that uses that query).

Change the criteria on your query to refer to the form
Forms!frmName!txtSomething
frmName would be the name of the form and txtSomething the name of the
textbox.



--
Joan Wild
Microsoft Access MVP

Dear,

After entering that I got the following:-

Enter Parameter Value
Please Enter the closing Date
Here I am talking about the main header as - Enter Parameter Value -
How to modify this ?
I mean I don't want the "Enter Parameter Value" header instead some
thing user friendly.

Please Help

You currently have <=[EndDate] as the criteria. Change it to

<=[Please Enter the Closing Date]



--
Joan Wild
Microsoft Access MVP

Dear
Please be more simple - where to put that square brackets? in the
query date field? or where?

please advise

Rgds


:

Put what you want your users to see in the square brackets.

HTH
--
-Larry-
--

Hi,

I have a made query with the following criteria in the date field
of the Table <=[End Date]
now when I execute I get box with a header titled "Enter Parameter
Value" for the end date. My question is that how can I modify this
box
header, some
thing which is useful to the users - like "PLEASE ENTER THE
CLOSING DATE" or some thing similar.
Thanks in advance
Anver