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

Senin, 23 Mei 2011

RE: [MS_AccessPros] Date format input mask in query

Crystal-

Yeah. Unlike Forms, Reports don't load the Record Source until *after* the Open
event finishes. It lets you do "magic" stuff like this.

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: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Crystal
Sent: Monday, May 23, 2011 6:28 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: 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
> >
> >
> >

------------------------------------

Yahoo! Groups Links