Search results

Hi, I am using a form that contains combo boxes and text boxes to carry out a search, this all works fine but I would also like to have a Reset button to clear the contents of the form. I have tried the Reset option in RunCommand in Macros but this doesn't work. The fields within the table are...

That's got it sorted! Thanks dgm... Now I just need to know how I can use this within a search capacity. What I have so far is a text box that I can use as a search box, I enter keywords into the text box then press the cmd button, this then opens a form that runs a query and displays all the...

Thanks for your help. For some reason I have two fields in the query? When I created the combo box using the wizard I only specified the subject field but the query contains the subject and the UID? When I remove the UID from the query and go back to the combo box there are no entries. Is...

Hi, I've created a database and it's being used to store FAQ's that people can search. The way the search currently works is like this. I have one table with fields like subject, category, name, question and answer and one other field called 'keyword' in the keyword field I enter all the...

Hi, I have a form that displays my Question & Answer fields from my FAQ table. I have made a macro to copy the selected text from either the question or answer field in the table and then output it to a txt file. I have assigned this macro to a command button but when I click it I get the...