InputBox with calendar

[Silvio]

Hello everyone, I am using an InputBox to prompt the user to enter a date, is
there a way to show the calendar picker so the user can pick a date instead
of type one in (Access 2007)? This date will not be stored anywhere in the
database; it is used to create an Oultook 2007 calendar note from the
database directly. Or, is there a way to have the calendar to pop up directly
and past the selection into my inputbox?

Thank you,
Silvio

 

[Al Campagna]

Silvio,
Not using the InputBox function, but... you could create a custom pop-up
form, with a date picker, or calendar control.
For example... enter a date for a report filter, or a query criteria,
etc...
In both examples, leave the pop-up form open while the report or query
runs.
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."