Search results

I am using a table for the products arent I? I've got a products table, and if you just use the Order Query without the search form the product is displayed as the actuall product and not just a number.

Yeah I managed to get the search working, however if you scroll right on the search form you should see the product field, this field is the problem as instead of displaying the product it just displays the product ID. Do you get me?

Ok, cheers, I've added a few examples and to perform a search you just click on "Perform Search" on the orders form which comes up when you load the DB. I will have to wait till monday to change the object/ field names as I dont have the most recent version of the DB on my home computer. The...

Ok, cheers the DB is on this post, thanks for replying I don't have a clue how to fix it. :)

Hi John please can you help me and Teady91 on your thread: http://www.access-programmers.co.uk/forums/showthread.php?t=188663 Cheers.

Re: Dynamically search multiple fields Hi Is there any way to get this working with tables that contain relationships? for example I have an orders table with a relationship with the products table, however when the search results appear, the product ID is displayed and not the actual...

Lol. I did have a look at some Dynamic Queries however its all code, and im not that familiar with code. I found a sample peice from Microsoft's help website but I couldn't figure out how to change it to my situation. Yes in order for me to perform the search I have to click the search button...

Hi cheers for the reply. I've managed to get the OR's working on a single query, however once I add the Like and Is Null statements the query still wont work unless a value is entered into the Contact Name field which has the like and null statements: WHERE (((Orders.[Job...

Hi everyone I've currently got a UNION Query in order to enable large searches, however I now require that the Name fields have "Like" statements to enable the user to search for all names similar to what they have entered. I've tried various instructions from various forums, however for some...