Date and Time picker control

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mirna - 20 Jul 2003 21:55 GMT

Hello,

Can I add more than one Microsoft Date and Time picker
controll at the same form

Accutualy I have a beginning date and End date on a Event
Form

Thanks

Reply to this Message

Carl Harris - 01 Aug 2003 17:42 GMT

>-----Original Message-----
>Hello,
[quoted text clipped - 8 lines]
>.
>Yes,

simply use them where you want, they are all named
differently when they are inserted. You can then run
queries, etc using the field names to pass the parameters
across (in the query e.g below the fields of the
DateTimePickers are called "dmstartdate" and "dmenddate"
respectively)

(e.g WHERE (((Payments.OrderDate) Between Format([Forms]!
[Databasereporting]![dmstartdate],"dd/mm/yyyy") And Format
([Forms]![Databasereporting]![dmenddate],"dd/mm/yyyy")))

Reply to this Message