ACC2003: Want to filter from a form and then export the results

Hi everyone,

I need to be able to modify the search criteria of a query, I figure this is
best done through a form? How would I be able to search for all records
between #start_date# and #end_date# then export those results to a XLS file?

Is there an easier way to do this? I have to make it user friendly and don't
want the end user to modify the query directly. And it has to be idiot proof.
I've been playing around with for a bit, but I'm taking the wrong approach
and searching the web I find lots of answer, but way about my ability and
comprehension. So please, pretend like you're talking to a 4 year old, I
won't take offence.

I'd like to thank any and all of the knowledgable ppl here who may or may
not respond to this.

Cheers,

Hi Mike,

Here is an example that I believe does everything you indicated:

http://home.comcast.net/~tutorme2/sa...mdialogbox.zip


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/ex...tributors.html
__________________________________________

"Mike" wrote:

Hi everyone,

I need to be able to modify the search criteria of a query, I figure this is
best done through a form? How would I be able to search for all records
between #start_date# and #end_date# then export those results to a XLS file?

Is there an easier way to do this? I have to make it user friendly and don't
want the end user to modify the query directly. And it has to be idiot proof.
I've been playing around with for a bit, but I'm taking the wrong approach
and searching the web I find lots of answer, but way about my ability and
comprehension. So please, pretend like you're talking to a 4 year old, I
won't take offence.

I'd like to thank any and all of the knowledgable ppl here who may or may
not respond to this.

Cheers,