queries to sort be dates input into the form, access 2007

Hello,

I am looking for assistance with access 2007. I am trying to create a form that is called from a command butto on a different form. The form called should have 4 key options. A from date box that has the calender attached, a to date box with calender, a button to retrieve results based in the date range and an export to excel form option.

If you have any information on how I can accomplish or learn how to do that I could REALLY use the help. Please submit anything you have on here, email me at ********* or contact me on Skype.

Thank you,
Leslye

Leslye,
I have removed your email address from the post. It is not a good idea to publicly post your email address. Spammers love that. People who want to reach you, can do so through PM.

As to your issues, what have you tried to do in building the form and creating the button to open the form?

You can use the wizard to insert a button to open a new form. You do have to have the form built first.

Have you tried building the form you require? What issues have you encountered. We are here to help you, but not do your work for you. Learning is best achieved through first hand experience. Let us help you, but give a starting point on what you have done. If this seems a little harsh, I apologize. It is not meant that way, but to help you learn.

Do you need a tutorial on building forms?
Look here -----> http://office.microsoft.com/en-us/ac...001027863.aspx
Alan

Here are two good sources for tutorials. I would start with the first one and then look to the second one for reference. If you have not read the third article, I would do that first to understand the set up of a database. Post back with specific questions.

1. http://www.accessmvp.com/strive4peace/

2. http://www.databasedev.co.uk/general.html

3. http://www.deeptraining.com/litwin/d...aseDesign.aspx

other good resources include:

http://allenbrowne.com/tips.html

http://www.datapigtechnologies.com/AccessMain.htm

http://www.rogersaccesslibrary.com/TableOfContents3.asp

http://www.btabdevelopment.com/ts/

http://www.w3schools.com/sql/default.asp

http://inpics.net/tutorials/access2003/basics.html

This should get you started. Good luck and as I said earlier. We are here to help. Post back with specific questions.