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

Senin, 23 Mei 2011

RE: [MS_AccessPros] Date format input mask in query

Steven-

I forgot to mention that you need to open the form as a Dialog.
WindowMode:=acDialog That halts your code in the Open event until the form
closes or hides itself.

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 S and M
Sent: Monday, May 23, 2011 8:25 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Date format input mask in query

John,

I created the form, put in the hide button and referenced it in the query. If I
open the form and put in a date before I open the query, works perfect!!!

Only problem is, when the form opens it does not wait for the input or the hide
button to be clicked before it continues,...so I get the parameter dialog
anyway.

How do I make it wait for the button to be clicked?

Thanks, Steven

--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> 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: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of S and M
> Sent: Monday, May 23, 2011 4:53 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Date format input mask in query
>
> 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
>

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

Yahoo! Groups Links