PC Review Forums Newsgroups Microsoft Access Microsoft Access VBA Modules date format for a query field at run time

Reply

date format for a query field at run time

 
Thread Tools Rate Thread
Old 10-11-2003, 09:20 PM   #1
roger
Guest
 
Posts: n/a
Default date format for a query field at run time


Hello friends:
How would I enter a format of eg. 03/02/2003 for a prompt
which come up for a query..at run time. This is to see to
it that the user enters the format above only for entering
the dates and nothing else.
  Reply With Quote
Old 10-11-2003, 10:16 PM   #2
Dev Ashish
Guest
 
Posts: n/a
Default Re: date format for a query field at run time

"roger" <anonymous@discussions.microsoft.com> wrote in news:022701c3a7c8
$0cbcbf60$a401280a@phx.gbl:

> How would I enter a format of eg. 03/02/2003 for a prompt
> which come up for a query..at run time. This is to see to
> it that the user enters the format above only for entering
> the dates and nothing else.


I don't think you can enforce that as a parameter. Try using a form with
the date control which the query then references.

-- Dev
  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off