ACCESS FEED: Re: [MS_AccessPros] Date format input mask in query

Senin, 23 Mei 2011

Re: [MS_AccessPros] Date format input mask in query

Hi John,

> "use the Open event of the report to open the [parameter] form"

clever, thanks

Warm Regards,
Crystal

*
(: have an awesome day :)
*

--- On Mon, 5/23/11, S and M wrote:

> Thanks John!!
>

> ---John Viescas wrote:
> >
> > Steven-
> >
> > No can do. You can force the dialog box to
> accept only values that can be
> > interpreted as date/time by adding:
> >
> > PARAMETERS [Enter Reporting Date:] Date;
> >
> > .. to the front of the SQL in your query.
> >
> > If you want to control the format / input mask, use a
> parameter form and
> > reference it as:
> >
> > [Forms][frmEnterDate]![txtDate]
> >
> > You can use the Open event of the report to open the
> form. Put an OK button on
> > the form that just hides it so the report query can
> find the parameter.
> > (Me.Visible = False) In the Close event of the
> Report, close the parameter
> > form.
> >
> >
> > John Viescas, author
> > Microsoft Office Access 2010 Inside Out
> > Microsoft Office Access 2007 Inside Out
> > Building Microsoft Access Applications
> > Microsoft Office Access 2003 Inside Out
> > SQL Queries for Mere Mortals
> > http://www.viescas.com/
> > (Paris, France)
> >
> >
> >
> > -----Original Message-----
> > From: S and M
> > Sent:
> >
> > Hey everyone,
> >
> > I have a report based on a query that ask for a report
> date like this,...
> >
> > WHERE (((qryEventRevenueWithMemberName.RegDate)=[Enter
> Reporting Date:]));
> >
> > When the dialog box pops up to enter the date, it
> requires that you type in the
> > / marks. I would like this to automatically show
> the / marks just like it does
> > in date fields in forms when you set the input mask to
> short date.
> >
> > I set the input mask for the criteria in the query but
> that did not fix it.
> >
> > What am I missing?
> >
> > Thanks, Steven
> >
> > Access 2003 on XP
> >
> >
> >