not sure if this is possible

[nomojo]

I am working on a volunteer database for a local non-profit. They have many programs and would like to filter the names they see so that only the volunteers that fit their profile (job, availablility, interests, etc) are shown. Is there a way for me to provide a form that gives them the options they would need, and then have access create a query based on those inputs? If not, do you have any ideas on how to achieve the filtering function while maintain simplicity on the user end?

 

[Beetle]

You might find this link helpful. If you have questions about the implementation of a method like the one on Allen's site you can post back here, but we'll need more information about the specifics of your database in order to help you.

 

[DSquared65]

If I understand the question correctly, the simple answer is to create a form with all the optional fields, then use the OR criteria statements in the query using the inputs from the form.

 

[CBrighton]

You might find this link helpful. If you have questions about the implementation of a method like the one on Allen's site you can post back here, but we'll need more information about the specifics of your database in order to help you.

I use code like this, combined with comboboxes to select the output (reports, exports, etc), to allow the user filter their choice of reports dynamically with none of the risks associated with users creating their own queries.

Very useful code, it lets you filter on as many fields as you want and as long as it checks for null first (which the exmaple code does) it ignores the fields which have not been used as criteria.

 

[nomojo]

Thanks Beetle. It took me some time to get the full gist of the search code, but once i did it became easy enough to modify to fit my needs. The client is happy, thanks much. I do have one question, its not a big deal, just for some piece of mind. In the filter code example for the text box, it says i can use = or like, with like finding that string anywhere. Is there a way to ensure that if i was to type an L in the last name field, it only returned results that began with an L?

 

[Beetle]

That would look something like;

[LastName] Like "L*"

 

[nomojo]

I phrased my question poorly. I am referring to if the user types an "L" or any other letter for that matter, into the last name field, all the results that back will begin with that letter.

 

[Beetle]

I need more specifics about what you're doing.

Do you have an unbound text box on a form where the user enters a letter and you want to filter the form's Record Source for records where the LastName begins with that letter?

Something else?

My ESP only works on the third Tuesday of even numbered months.

 

[nomojo]

That is almost exactly what i have. I have an unbound text box where the user can input the name of the volunteer they are looking for, or because i am using "like" any part of the name they are looking for. I am trying to make it so they could just put in a letter, such as "L" and only the names that begin with "L" are returned, rather than now, when all names with an "L" in them are returned.

 

[Beetle]

So in that case the criteria would be;

[LastName] Like [Forms]![YourForm]![YourTextBox] & "*"