Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by toddB
-
How to change the way recordset is opening ? (from .execute to .open)
you can pass parameters to a stored procedure.<br><br>sSQL = "NameStoreProcedure '" & sParameter1 & "'"<br><br>or if it is a number just pass it without the single quotes.<br><br>try printing out the sSQL before you open and try running it in your Database and see if you get... -
How to open recordset properly ? (use .Execute method)
it all depends on how you open the recordset on whether you will get recordcount and other properties.<br><br><br>sSQL = What ever your stored procedure is called<br><br>rs.Open sSql, Conn object, (adOpenDynamic, adOpenStatic, adOpenForwardOnly, adOpenKeyset, adOpenUnspecified)<br><br>it...
