VBA, Counting records returned by SQL Select statement

Counting records returned by SQL Select statement

Author	Message
Tony #1 / 4	Counting records returned by SQL Select statement Hi, How do I go about counting the number of records to be returned by my code: strSQl= "SELECT * FROM myTbl WHERE myDesc LIKE '" & strmyTextbox & "' & '*'" before either using me.RecordSource = strSQL or before requerying the form based on the results of the above line? TonyT
Fri, 26 Aug 2005 21:17:55 GMT

MV #2 / 4	Counting records returned by SQL Select statement I guess you could use the DCount function. SomeVariable = DCOUNT("","MyTbl","MyDesc Like '" & strMyTextbox & "'") Quote: > Hi, > How do I go about counting the number of records to be > returned by my code: > strSQl= "SELECT * FROM myTbl WHERE myDesc LIKE '" & > strmyTextbox & "' & '*'" > before either using > me.RecordSource = strSQL > or before requerying the form based on the results of the > above line? > TonyT
Fri, 26 Aug 2005 23:25:27 GMT

Tony #3 / 4	Counting records returned by SQL Select statement Yet again I miss the obvious :) thanx, TonyT Quote: >-----Original Message----- >I guess you could use the DCount function. >SomeVariable = DCOUNT("","MyTbl","MyDesc Like '" & strMyTextbox & "'") Quote: >> Hi, >> How do I go about counting the number of records to be >> returned by my code: >> strSQl= "SELECT * FROM myTbl WHERE myDesc LIKE '" & >> strmyTextbox & "' & '*'" >> before either using >> me.RecordSource = strSQL >> or before requerying the form based on the results of the >> above line? >> TonyT >.
Sat, 27 Aug 2005 00:03:24 GMT

Tim Ferguso #4 / 4	Counting records returned by SQL Select statement Quote: > Yet again I miss the obvious :) The alternative is to recast the query slightly: strSQl= "SELECT COUNT() FROM myTbl " & _ "WHERE myDesc LIKE '" & strmyTextbox & "' & ''" hth Tim F
Sat, 27 Aug 2005 04:19:28 GMT

Page 1 of 1

[ 4 post ]