PC Review
Forums
Newsgroups
Microsoft Access
Microsoft Access VBA Modules
date format for a query field at run time
Forums
Newsgroups
Microsoft Access
Microsoft Access VBA Modules
date format for a query field at run time
![]() |
date format for a query field at run time |
|
|
Thread Tools | Rate Thread |
|
|
#1 |
|
Guest
Posts: n/a
|
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. |
|
|
|
#2 |
|
Guest
Posts: n/a
|
"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 |
|
![]() |
|
| Thread Tools | |
| Rate This Thread | |
|
|

Main Page 

