Data Entry Paramaters - Enter 1st Date etc

[baconroll]

I have a query where users have to enter a start date and an end date. I want
them to be forced to enter the date in the international format i.e.
05-Oct-05 and not 05/10/05. I have selected the field properties in the
query column and created an input mask but when I run the query the mask
doesn't appear in the enter paramater value box? Any suggestions would be
greatly appreciated.

 

[Tom Wickerath]

Hi Bacon,

Create a form with textboxs for entering your dates. Apply the input masks
to the textboxes on the form. Add a command button to the form to run your
query. The query will include a criteria on the looks to these textboxes for
the date that the user entered.

=[Forms]![YourFormName]![TextBoxName]

You might even want to add calendar functionality, so that your user can
click and point to select the date. Allen Browne offers a great calendar for
this purpose:

Popup Calendar
http://allenbrowne.com/ser-51.html

Stephen Lebans also has some calendar available on his web site:
www.lebans.com


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

I have a query where users have to enter a start date and an end date. I want
them to be forced to enter the date in the international format i.e.
05-Oct-05 and not 05/10/05. I have selected the field properties in the
query column and created an input mask but when I run the query the mask
doesn't appear in the enter paramater value box? Any suggestions would be
greatly appreciated.

 

[baconroll]

Thank you Tom

This is very helpful.

 

[Tom Wickerath]

You're welcome. Since you found my answer helpful, please consider returning
to that message and marking it as an answer.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

Thank you Tom

This is very helpful.

 

[Van T. Dinh]

Just a small correction here: "05-Oct-05" is definitely not the
"international" format. Only English-speaking countries use Oct or October.