Search results

Rich Unbelieveable! So simple and it works! Thank you very much indeed. Kind regards Pete

Hello I am creating a simple database to keep track of washing machine parts I have a table and a form called ‘parts’. My primary I.D field is ‘part no’ I have second form called ‘search’ with a textbox (txtfilter) and a command button (cmdsearch). I want the textbox to accept the input of a...

Thanks for taking a look at the code. For some reason when I put the extra comma in I get a run-time error 2501 and the message "the openform action was cancelled" When I remove the extra comma the form will open again but only the first record. I have had this code working on past projects...

Hello I need some help with a form I have created to search a table. I have created a search form with a text box and command button that search a table called "parts" . It then displays the results in a listbox. If a result is selected it opens a form called “parts” and should display the...

Thanks fizzio. It works!

Hmmmmm. I made thoses changes but now when i click on a result in the listbox there is no action at all, not even an error message.

Nothing! I can't even find a Form_Open event action on the parts form properties.

Hello I have created a form that accepts input via a text box( txtfilter) and command button (cmdsearch). The inputed term is used to search all fields in my table (parts) and the results of the search are displayed in a list box (lstresults) When a result in the list box is clicked on it...

Thanks mile - That's it. Would you like to come and live on top of my computer and fix all my database problems? Cheers again. Regards Pete

Thanks mile. I inserted the code verbatim in place of my original code (was that correct?) and now the button does not work,I.E. pressing it results in no action. If I re-insert the original code it will search just the agency field again.

Hello I have created a button on a form that searches one field in a table. If I wanted to search across all fields in the table and not just agency, how could I change this line to do so? Or is there a simpler term that will search the entire table. .RowSource = "Select * FROM tapes WHERE...

I think I'm going for the mile here:-) One more thing. If i wanted to search across all fields in the table and not just agency, how could I change this line to do so? .RowSource = "Select * FROM tapes WHERE [agency] Like '*" & Me.txtfilter & "*';" For instance if I wanted to add the fields...

That worked perfectly.You really are quite a star. Thanks for all your help.

Success! Thanks Mile and Pat. Another question.......Doh Currently to obtain a result form text entered into the text box it has to be entered exactly as it appears in the agency field. What terms should I use to make it a bit more wild? I.E if I want to find "television productions" I could...

Pat Hartman - Where should the additional commas go? Mile - Thanks for your constructive input Abhi- Thanks but that code didn't make any difference!

Hi There. I am new and very inexperienced so please forgive any daft terminology. Using access 2002 on XP. I need some help with a form I have created to search a table. I have created a search form with a text box and command button that search a table called "tapes" and a field called...

Hi There. I am new and very inexperienced so please forgive any daft terminology. Using access 2002 on XP. I have created a form with a text box that searches a table called "tapes" and a field called "agency", then displays the results in a list box. If I then click on a result it opens up...