Search results

Hello, did you get a chance to look at this?? Thank you

Hi, Thanks for the reply. Sorry for providing incorrect info. I have changed things slightly. back to testing again using query only now to make sure it is definately working. I suppose my aim is to have a form where I can do count on multiple fields(eg number is shirts, number is shirts is...

Hi, Thanks for the reply. attached query.

Would be great if anybody has any ideas?? Has the post been written inefficiently??

Hi, I have a table created of clothing ranges and it contains the following columns count, clothing type, colour, size, manfacturer etc. What I need is to create a form so a report can be run to check the various counts for based on user input, they can select eg jumpers, size and colour adn...

Thank you for the reply. I also need a msg box when a record is entered but not found on the database. I have tried elseif statements, however my code dosent work very efficiently. What would the best method be?

Hi John, User will enter a Registration number in an unbound textbox,click on a search command button which is setup to open the record that matched the detail entered in the text button. The first bit of code will ask returns a msg when no data is entered. The next will retrieve the record...

Hi John, Sorry I wrote that sentence wrong. When I had the if clause in, at all times the message record not found appeared What I would like to happen is when the user searches the database, If the record is not found a message appears saying so. :)

Thanks for the reply John, This is my simple bit of code so far, tried entering your suggestion but had some errors. When I enter an if statement when the record is not found I only get the record not found message. If you could advise any improvements that would be great. Thank you:)...

hi, I have a form set up to open a page on a specific record. the user can enter the index and if the detail if correct can open the record, I would like to have a message box appear if the record is not found. Can you advise? Many Thanks