If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Recordset merge
I am merging from an Access 2007 Form/subforms to a bookmarked Word document.
I am able to use .MoveNext to merge the recordsets, but get an error if there are less records. The DAO Library is referenced, I've tried this code, but now only the first record is merged and the fields of the recordsets of the form are replaced with #Name? (Fortunately, rebooting Access returns the recordset fields to former state). Any suggestions? Dim db As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb Set rs = Forms("OGML").qryMineralOwnersub.Form.Recordset rs.MoveFirst InsertAtBookmarks objWord, objDoc, "Owners1", rs!MineralOwner If Not (rs.BOF And rs.EOF) Then GoTo Exit_here rs.MoveNext End If InsertAtBookmarks objWord, objDoc, "Owners2", rs!MineralOwner -- Lafayette, LA |
Thread Tools | |
Display Modes | |
|
|