Pick Date

[Guest]

I have a report that asks for a date range that is set up in a query using
the between criteria. I would like to set it up so I can pick a date from a
calendar when asked to put the to and from dates. Any help would be
appreciated.
Richard

 

[Joan Wild]

See
http://www.lebans.com/monthcalendar.htm

 

[Guest]

Thanks for the reply. I am not sure I understand the directions in this
website. Seems complicated for what I want to do. I am not a programer.
thanks,

Richard

 

[Guest]

Hi Richard,

I have a sample that you are welcome to download:

http://home.comcast.net/~tutorme2/samples/customdialogbox.zip

This includes a Word document written by Michael Hernandez, author of
Database Design for Mere Mortals, along with a test database that I created.
I added Access MVP Allen Browne's popup calendar to this sample:

Popup Calendar
http://allenbrowne.com/ser-51.html

Work your way through the tutorial, using a database that you create from
scratch. Then see if you can apply what you have learned to your database.
Whether one opens a query (as in the example) or opens a report (I've
included this as well in my sample) is fairly trivial.

Happy Learning!


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

Thanks Tom. I will try this

Hi Richard,

I have a sample that you are welcome to download:

http://home.comcast.net/~tutorme2/samples/customdialogbox.zip

This includes a Word document written by Michael Hernandez, author of
Database Design for Mere Mortals, along with a test database that I created.
I added Access MVP Allen Browne's popup calendar to this sample:

Popup Calendar
http://allenbrowne.com/ser-51.html

Work your way through the tutorial, using a database that you create from
scratch. Then see if you can apply what you have learned to your database.
Whether one opens a query (as in the example) or opens a report (I've
included this as well in my sample) is fairly trivial.

Happy Learning!


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Arvin Meyer [MVP]]

Try:

http://www.datastrat.com/Download/Calendar2K.zip

It is an Access form which requires no code outside of Access, and has
worked in every version (with conversion) since Access 2.0

 

[Joan Wild]

The instructions that Jeff Conrad wrote for that webpage are very detailed.
If you follow them through, you'll be in business. He's very good at
explaining things.