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......

 

[Uncle Gizmo]

If you want a separate pop-up form which operates as a datepicker, have a look at my web site here where I provide a free and paid for version, pays your money and takes your choice... Something like that!

Nifty Date Picker

Nifty Date Picker - Nifty Access

Nifty Date Picker -Updated This page is about the new "Nifty Date Picker" which supersedes the old original "Nifty Date Picker". If you're looking for the original "Nifty Date Picker", just click THIS LINK and you will be taken to the webpage. The new "Nifty Date Picker" has some Nifty New...

www.niftyaccess.com

 

[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.

 

[Pat Hartman]

Is there some reason you can't use a control on a form? We can't tell by the context of the question what you are trying to do. For example, if you are running a report, add a control to the form to capture the date. In the click event of the run report button, make sure the control contains a date, then run the report or set focus to the control and prompt the user to try again.