Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!
Dim rsTmp As ADODB.Recordset Dim varBkMrk As Variant Dim strCompSQL As String Dim IOD As Long 5 On Error GoTo ErrorHandler 10 varBkMrk = DS.Recordset.Bookmark 15 Set rsTmp = DS.Recordset.Clone 20 rsTmp.Bookmark = varBkMrk 30 strCompSQL = "SELECT * FROM MyView" 35 Set DS.Recordset = OpenSQLRecordset(strCompSQL) 'Function that returns a temp Recordset 40 DS.Recordset.Bookmark = varBkMrk
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.