Query in VB

L

LOP

I would like to write this query with input parameters in VB but not quite
sure which object use:
SELECT * FROM PRODUCT WHERE PRODUCT_NAME = [param1] AND PRODUCT_ID = [param2]
This query should return either zero or one record. I would like to know
whether it returns one or not. Thanks for any help.
 
N

Nikos Yannacopoulos

Try something like:

vName = InputBox("Pls enter product name")
vPrID = InputBox("Pls enter product ID")
vRecCount = DCount("*", "PRODUCT", "PRODUCT_NAME = '" & vName _
& "' AND PRODUCT_ID = " & vPrID )

where I have assumed PRODUCT_ID to be numeric; id text, then the
expression becomes:

vRecCount = DCount("*", "PRODUCT", "PRODUCT_NAME = '" & vName _
& "' AND PRODUCT_ID = '" & vPrID & "'")

HTH,
Nikos
 
Top