For a lot of the access reports that I generate, I have to integrate with Word documents. up to now I have achieved this by opening a new document based ono a template and then doing searc/replace for bookmarks within the template. eg:
If Dir$(sDir, vbDirectory) = "" Then MkDir sDir
Set oApp = CreateObject("word.application")
oApp.Visible = True
If Dir(sFilename) = "" Then
NewWP = 1
Set oApp = CreateObject("word.basic")
' Find and replace bookmarks
.editbookmark Name:="zwpnoz", Goto:=True
.editbookmark Name:="zwptitlez", Goto:=True
.editbookmark Name:="zprojtitlez", Goto:=True
.insert (Forms![sys master form]![Text182])
.editbookmark Name:="zwpmanagerz", Goto:=True
If IsNull(Me.WPManager) Then
I now have a report where some of the data will come from subrecords. I don't know how many there will be, but the Word template will only allow for four subrecords.
How do other people deal with this scenario?
If it wasn't for the need to use the Word template I would have resorted to a report/subreport.