Search results

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...

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...

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...

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...

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...