products query help

[KenshiroUK]

Would appreciate some help on this, I have created a table with products listing and would like to run a query prompting user to type in name which would display that info into a table. I've set up a parameter table however theres results being displayed

 

[pr2-eugin]

Two ways, A form which has a Text/Combo box that feeds as the Query Criteria.. something like..

SELECT * FROM yourTable WHERE fieldName = " & [Forms]![yourForm]![controlName] & "

Or, you can use Query Parameter.. Something like..

PARAMETERS EnterSearchValue Text;
SELECT * FROM yourTable WHERE fieldName = " & EnterSearchValue & "

 

[KenshiroUK]

that didn't help but played around with it and got product id to work, but wanna get it to prompt user to enter a name and displays. what would the parameters to be to search for products closer to name?

 

[pr2-eugin]

Could you show me your code so far??

 

[KenshiroUK]

SELECT [Inventory table].Title, [Inventory table].SKU, [Inventory table].[standard-product-id], [Inventory table].[product-id-type], [Inventory table].product_type, [Inventory table].brand, [Inventory table].manufacturer, [Inventory table].description, [Inventory table].Count, [Inventory table].[item-price], [Inventory table].SKU, [Inventory table].SKU, [Inventory table].SKU
FROM [Inventory table]
WHERE ((([Inventory table].SKU) Like [Please enter SKU product code:]));

 

[KenshiroUK]

it works with SKU but a name it doesnt like not sure because it wants it specific, don't know how to set key words instead been long time since used Access

 

[pr2-eugin]

As the description is a String.. Try..

WHERE ((([Inventory table].SKU) Like '"& [Please enter SKU product code:] & "'));

 

[KenshiroUK]

As the description is a String.. Try..

WHERE ((([Inventory table].SKU) Like '"& [Please enter SKU product code:] & "'));

no no, the SKU code works fine and populates the table with the correct data, I want to setup the same kind of code but in product title to prompt a user to enter product title and display details if that makes sense.

 

[pr2-eugin]

Could you give a couple of examples??

 

[KenshiroUK]

Could you give a couple of examples??

product names?

 

[pr2-eugin]

Some data in the table, what do you expect to see as output, but what you are actually getting..

 

[KenshiroUK]

Some data in the table, what do you expect to see as output, but what you are actually getting..

Title, SKU, standard-product-id, product-id-type, product_type

with a product title of Atelier Interactive Carbon Black Series 1 250ml Jar

to Ziggy Art 6 Well Plastic Palette being the last