It's easy! Check out this step-by-step guide for asking an anonymous question on Experts Exchange.
counter = 0 limit = 5 Dim cConnection Set cConnection = CreateObject("ADODB.Connection") //setting variables here for connection string, username, password. cConnection.Open DBConString,DBUser,DBPass SQLstmt = "SELECT field1, field2 from Table1 WHERE Field1 IS NULL" Set RS = cConnection.Execute(SQLstmt) while (not RS.EOF) AND (counter < limit) msgbox("Field1: " & RS.Fields.Item("field1").value) //do other stuff counter = counter + 1 RS.Movenext() wend
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.