Query in VB

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top