a form that can be used as a search facility

[michellerobinso]

please excuse the ignorance, im am i novice in the process on learning this.

i have a project that requires to create a customer service log of all the queries that come in.

i would like to create a form that would enable me to search for the following

query number
date
account name
account reference

then i would like it to list all the return so you can select the entry to open it or either go to that record.

any help is greatly greatly appriciated.

thank you for your time

 

[rsbutterfly16]

have you created a table to use as a source for the search query?

 

[Oldsoftboss]

To create a search facility, try using the search facility.

http://www.access-programmers.co.uk/forums/showthread.php?t=97434&highlight=search

Download the Sample Search Form I posted. This can be adapted to search as many fields as you require.

Dave

 

[michellerobinso]

thank you very much for your help

the sample search facility got me right on track.

 

[yvonnejayne]

Sample Search Form

To create a search facility, try using the search facility.

http://www.access-programmers.co.uk/forums/showthread.php?t=97434&highlight=search

Download the Sample Search Form I posted. This can be adapted to search as many fields as you require.

Dave

Hi Dave,

I've applied your concept and code to querying a table that acts as a dictionary of medical terms, including medication names. The database is shared among a group of hospital transcriptionists.

What I like best about this form is that the user can search for any bit of information from any of the search fields. That works great for transcriptionists, who (for example) may not be able to hear the first part of a word that a doctor has dictated, but they can hear the last part of the word. (An ordinary dictionary won't help you find words that end with "-ophthalmos" or that include "-amino-".) We now have a place to store and share any new terms that we encounter in the course of work.

Thank you for your succinct coding. God, I wrote pages of rubbish, with a form and subform, trying to do something similar! When I saw what you managed to do with just a few lines of code and a simple form with a listbox, I said, "I'm wasting my time, I can't possibly do better." I pitched everything I had written and used your technique.

Thanks a million.

 

[Oldsoftboss]

Hi yvonnejayne

2 laws of programming:
1.. Copy what someone else has already done.
2.. When all else fails, read the help file.

The code you give me credit for comes from the first rule of programming, so I cant take all the credit, only for making it available here.

Dave