'i have an error on access database no value given for one or more parameters

   'sql = "select * from tblProduct Order by ProductID"
       Sql = "SELECT tblProduct.PID, tblProduct.ProductID, tblProduct.ProductName, tblProduct.SubcategoryID, tblProduct.Description, tblProduct.CostPrice, tblProduct.SellingPrice, tblProduct.Discount, tblProduct.VAT, tblProduct.OpeningStock, tblProduct.Pic FROM tbSubcategory INNER JOIN tblProduct ON tbSubcategory.SubcategoryID = tblProduct.SubcategoryID"
        .CursorType = adOpenDynamic
        .CursorLocation = adUseClient
        .LockType = adLockOptimistic
        .Open Sql, cn, , adCmdText

vba ms-access

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'i have an error on access database no value given for one or more parameters

Sources

Related Questions