wrong number of arguments
[Originally posted by Johm]
wrong number of arguments used with query expression run time error 3075
I want to simplify the following sql:
stSQL = " SELECT customers.Customerid, customers.CompanyName,customers.afid ,customers.address, " & _
" customers.employee,customers.city,customers.works,customers.works1,customers.home,customer s.mobi," & _
by making something like that:
strSQL˙ = " SELECT customers(Customerid,CompanyName,afid ,address,employee,city,works,works1,home,mobi,taxid,pass,bulstat)
But then i receive the message wrong number of arguments run time error 3075.
May i ask for help?
Re:wrong number of arguments
[Originally posted by m.posseth]
this should work :-)
strSQL˙ = "SELECT Customerid, CompanyName, afid, address, employee, " & _
"city, works, works1, home, mobi, taxid, pass, bulstat FROM customers;"
complete naming customers.Customerid etc etc ,should alway`s be used when joining tables in a sql query to avoid name conflicts ,,, so you could even state that the previously used way is the better way !! of doing things :-)
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center