PC Review


Reply
Thread Tools Rate Thread

date format for a query field at run time

 
 
roger
Guest
Posts: n/a
 
      10th Nov 2003
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
 
 
 
 
Dev Ashish
Guest
Posts: n/a
 
      10th Nov 2003
"roger" <(E-Mail Removed)> wrote in news:022701c3a7c8
$0cbcbf60$(E-Mail Removed):

> 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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
The same Date / Time field contains time in different format after import from text file Evgeniy Microsoft Access 4 20th Jun 2008 03:04 PM
Access query on date/TIme field for date then there is no time? =?Utf-8?B?QmFuaw==?= Microsoft Access Queries 12 23rd Feb 2006 11:02 PM
RE: Access query on date/TIme field for date then there is no time? =?Utf-8?B?S0FSTCBERVdFWQ==?= Microsoft Access Queries 0 4th Feb 2006 12:48 PM
Export Outlook date field as date/time format to Access database =?Utf-8?B?QmVja3k=?= Microsoft Outlook Discussion 0 2nd Dec 2004 03:49 PM
Simply querying date/time field for particular date with parameter query Brian Microsoft Access Queries 2 22nd Jan 2004 07:18 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:07 AM.