-
Hi all! I know this is probably too easy for
some of you but im not too sure how to do this.
If i open a recordset with a SQL statement does access
create a temporary table to hold the information?
And how do i get the information that i an extracting
to a picture box on a form?
Private Sub cmdDriverQuery_Click()
Dim strSQL As String
strSQL = "SELECT * FROM [Driver Information]"
Set rs = db.OpenRecordset(strSQL)
frmDriverQuery.Show
frmDriverQuery.picDriverQuery.Print ???
End Sub
Thanks all.
-
The query will return a result and it will be held by a recordset variable. You can extract a data by using rs!field_name.