Need Access 2000/SQL help.

/usr/usr Member Posts: 1,768 ■■■□□□□□□□
I'm trying to do inline queries in Access 2000.
Private Sub Command145_Click()
Dim conDatabase As ADODB.Connection
Dim strSQL As String
Set conDatabase = CurrentProject.Connection
strSQL = "SELECT tblXD.[Pass/Fail] FROM tblXD"
conDatabase.Execute strSQL
conDatabase.Close
Set conDatabase = Nothing
End Sub

I'm selecting all units that passed and failed, in this instance. My question is, how do I get the results to display? Anywhere would be fine, I just need them in a text box, a variable, anything at all.
Sign In or Register to comment.