Parameters and their dialog boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm hoping someone can help me. In a query I've created, I've succeeded in
prompting the user to put start and end dates, however when I run the query
there is nothing in the dialog box which helps the user enter the correct
format of a date. For example, if I enter 120103 (for December 1 2003) the
query does not accept it. Instead I find that I have to type in "12/01/2003"
which is cumbersome. Is it possible then for the dialog box to show
--/--/---- where the dashes are the areas the user would fill in?
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

No.

Use a form instead. Instead of a parameter of [Enter date] use a
reference to a TextBox on the form. Set up the TextBox's Input Mask
property to accept dates.

Ref to a form's control:

PARAMETERS Forms!frmCriteria!txtQueryDate DateTime;
SELECT ...
FROM ...
WHERE date_column = Forms!frmCriteria!txtQueryDate


--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQYgq/4echKqOuFEgEQITQQCgjr1zp2LYxW0/BUfgBEdncCsa2uMAnj2+
b0GuBZtHMJZQvT/zg6HUdWYs
=u8WH
-----END PGP SIGNATURE-----
 
Back
Top