Date prompt input mask in query

Z

Zachry1

During query, i have a Between date parameter. The user gets prompted "Start
Date" then "End date" but neither of these take on the input mask, so the
use has to enter the slashed, ie. "01/01/06". How can I format this prompt
for the input mask?
The table and the field in the query both have the input mask.
 
D

Duane Hookom

Abandon parameter prompts in favor of controls on forms. This allows you to
use combo boxes, calendar forms, formats, input masks, validation,....
 
J

JetsetA320

Duane,
I am new to Access but doing pretty good with constructing queries. What
stumps me is that I am intrigued by your preference in avoiding parameter
queries and using controls within a form. I persevered and was finally
rewarded with being able to construct just that. Now I wanted to apply that
to bringing the results of the query instead of a datasheet view to a select
group of forms. That has worked with using the parameter queries before as I
based the form on that query, e.g. Bill Record - BY DATE. I asked for a
'START DATE' and an 'END DATE' which had two parameter pop-ups. But I guess
my question is, "Can a form with controls (as you state) act as a query to
resuits in a group of select forms as a result of that query?" I seem to be
missing something here. If you can point me in the right direction that'd be
great.

JetsetA320
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top