Searching Criteria

[abdullahsikandar]

Hi Guys,

Thanks in advance for helping me before, I need your help again guys.

I have a database with me with 5 columns in it with the name of Name, Age, Address, Phone number and Position. I need a searching criteria for them to make the reports.

I made the form on excel with the text boxes and label:

Name=[ ]
Age= [ ]
Address=[ ]
Phone Number= [ ]
Position= [ ]


What i am trying to do is that the user can write whatever he want to in this fields and search it. Once it comes with the result it will automatically export the the output data into the excel with the formatted fields.

Thanks in Advance please guys help me .

 

[xenou]

Hi,
A typical strategy here is to use LIKE.

Once the textboxes are filled in you have a command button that runs a query such as:

SELECT * FROM Table WHERE [Name] LIKE '*" & Me.txtName.Value & "*' AND [Age] LIKE '*" & Me.txtAge.Value & "*' AND ... etc. etc. etc.

The Like criteria allows for the textboxes to be blank (LIKE '**') or to be filled in (LIKE '*xyz*')

 

[Joe4]

Cross-posted: Database Access Search

You got an answer here, so why did you ask the question again somewhere else instead of following up on the response?

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule #10 here: Forum Rules).

This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered. For a more complete explanation on cross-posting, see here: Forum Rules).

You may want to do the same on the other site too.

 

[abdullahsikandar]

Cross-posted: Database Access Search

You got an answer here, so why did you ask the question again somewhere else instead of following up on the response?

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule #10 here: Forum Rules).

This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered. For a more complete explanation on cross-posting, see here: Forum Rules).

You may want to do the same on the other site too.

I am sorry for not posting the link here, Secondly i didn`t get an answer till today as i have posted this yesterday so that will be the reason i posted this on other forum.

 

[abdullahsikandar]

Form Searching ( Link of the same post).

 

[Joe4]

Secondly i didn`t get an answer till today as i have posted this yesterday so that will be the reason i posted this on other forum.

xenou's response to this question was 31 minutes prior to your post at AccessForums.net.