R
Rhea
I want to open a database query and then loop thru the records when I click
on a command button. This what I have so far:
Dim dbsSecurity As Database
Dim qdfMailboxBB As QueryDef
Dim rstMissingSecurity As Recordset
Dim rstBBMailbox As Recordset
Dim strTechcode As String
Dim strMissingSL As String
Set dbsSecurity = OpenDatabase("Security.mdb")
Set qdfMailboxBB = dbsSecurity.QueryDefs("MailboxBB")
Set rstBBMailbox = qdfMailboxBB.OpenRecordset
Does that open the query and put the records into the recordset? Is that
what I should be doing or is there an easier way? I need to go thru each
record the query returns and then add a record to another table based on the
contents of each record. Thanks!
on a command button. This what I have so far:
Dim dbsSecurity As Database
Dim qdfMailboxBB As QueryDef
Dim rstMissingSecurity As Recordset
Dim rstBBMailbox As Recordset
Dim strTechcode As String
Dim strMissingSL As String
Set dbsSecurity = OpenDatabase("Security.mdb")
Set qdfMailboxBB = dbsSecurity.QueryDefs("MailboxBB")
Set rstBBMailbox = qdfMailboxBB.OpenRecordset
Does that open the query and put the records into the recordset? Is that
what I should be doing or is there an easier way? I need to go thru each
record the query returns and then add a record to another table based on the
contents of each record. Thanks!