Run query from date input on form

[The Joker via AccessMonster.com]

Hello all!

I have what I hope is a easy situation. I have a table that has information
that is entered daily with a field "Completed Date". I want to add a text
box to a form where a user can enter a date and hit a button that will run a
query for that specific completion date so I can have the query results
exported to Excel.

Would I use an unbound text box on the form? How would I set up the query to
take the date entered in the form?

Thank you very much!

- Joker

 

[Dale Fye]

Yes, an unbound textbox would be one way to do it.

Your query would look something like:

SELECT * FROM yourTable
WHERE [Completed Date] = #" & forms!formname.textboxname & "#"

You can use the Docmd.OutputTo method to export these results to Excel.

 

[XPS350]

Hello all!

I have what I hope is a easy situation.  I have a table that has information
that is entered daily with a field "Completed Date".  I want to add a text
box to a form where a user can enter a date and hit a button that will run a
query for that specific completion date so I can have the query results
exported to Excel.  

Would I use an unbound text box on the form?  How would I set up the query to
take the date entered in the form?

Thank you very much!

- Joker

In the design of the query (in the criteria section) you put something
like:
[forms]![YourForm]![SelectedDate]

You can indeed use an unbound text box. But you could also make an
unbound combox which you populate with all the unique dates from your
table. In that case you are sure to select a date that gives at least
one result.

Groeten,

Peter
http://access.xps350.com

 

[The Joker via AccessMonster.com]

Perfect! Thank you!!