DateTime picker as input

[mfaisal.ce]

Dears,

I want the user to input date by datetime picker .... kindly guide me how i can do that,

example

input("Enter Date Here")

When i use the above code, prompt comes for getting the value but i need datetime picker, like a normal textbox in runtime mode...

regards,

 

[theDBguy]

You can use a popup calendar.

 

[mfaisal.ce]

You can use a popup calendar.

plz guide, how

 

[arnelgp]

there is already a built-in datepicker in access.

 

[mfaisal.ce]

this is code, how i can use

DoCmd.OpenReport ReportName:="RPTSheet_Daily", View:=acViewPreview, wherecondition:="[Dated]=#" & Format(InputBox("Enter Date"), "yyyy-mm-dd") & "#"

Where i can use datetime picker......

 

[MajP]

Date Pickers, Calendar Controls, and Calendar resources

There has been some recent interest in a replacement for the MS calendar control that existed prior to 2010. I have been collecting date pickers, calendar controls, and calendars for a long time and thought it would be a good idea to have one thread with lots of good examples. Some of these...

www.access-programmers.co.uk

 

[arnelgp]

yes, you can use form in the Open event of your report.
on the demo, open the report.