Search results for query: *

I had the wrong update statement. I appreciate the suggestion. Thanks again.

I would like to update the pricing of the products in my products table from the excel sheet provided by the manufacturer. I want to change only the prices that are different. here is what i have so far. UPDATE PRODUCTS SET products.price = vendor.price WHERE products.partnumber =...

Well, I did everything you said and I am getting the following error message... Microsoft Access can't find the macro 'Dim strfilter As string Dim strsql as string strfilter=buildcriteria("short_desc",7,"*",& Replace(Me.' Any thoughts as to why I am getting this message?

I am back. I must be overlooking the easiest thing! It almost seems as if I am not getting the procedure to work. I must not have it set up correctly. I am getting search results the same reults. So, here is what I have... Table Name: master_products From Name: 'Product Search Results'...

Thanks again for the response. I will try it. Your help is greatly appreciated. And I do me greatly. :-) Tim

gol4, I simply cannot get this thing to work at all. I have tried for mostof the day and continually fail! Anymore help would be appreciated!!!! Thanks

Thank you. I appreciate the time and help that you put in to helping me....!

close, but, not exactly. I want a user to type in a couple of words describing a product into a textbox and have the database return the products that have those keywords somewhere in the short-description field. For instance, If the user types in one key word (stainless), then all the...

I am a new to access, how do I pass "the or statement and the wild cards" in the string?

Thanks for the quick response. I will look into this. Tim

I would like to search a table using filtering like the "autofilter" in Excel. Can this be set up to work in Access? Thanks in advance Tim

I have a product table and I would like to search for multiple keywords in one field. (short description) I am having trouble getting a result back from a query that has more than one word placed in the search text box. The only time I get a result back is when the two keywords are in the...