How do I make the script run through the database and write down the records of rs("book_title"),rs("chapter"),rs("verse"),rs("text_data") in a MSFlexGrid?
Private Sub MSFlexGrid1_Click()
'Private Sub Form_Load()
'the format string just lets you define a format for how
'your flexgrid...
How can I put a cancel/close commands to stop the running of the messagebox? (the records are thousands of records long).
While rs.EOF <> True
MsgBox (rs("book_title") & " " & rs("chapter") & ":" & rs("verse") & " " & rs("text_data"))
rs.MoveNext
Wend
Or do you...
If I use the late binding then I don't need to use MDAC reference?
Set cn = CreateObject("ADODB.Connection")
Is this the correct way of presenting it (do I have to use sub and end sub)?
Dim connectionString As String
Dim query As String
Dim cn
Dim cmd
Dim rs
Set...
