2 replies
by johnhong
If this is an on-going process, you should consider write an OLE agent/script in Notes, or a VBA program in Access which can transfer the data from an Access table or query into the Notes documents. In Notes, make a form that looks like your Access report.
The following is an example of how to access Lotus Notes session from VBA. It's easier to test than in Notes.
On Error Resume Next
Set Obj = GetObject(Notes.NotesSession")
If Err Then _
Set Obj = CreateObject("Notes.NotesSession")
...
Set Ndb = Obj.GetDatabase(YourNotesServer, YourNotesPathandDBName)
Set NView = Ndb.GetView(YourView)
Set NDoc = NView.GetDocumentByKey(Key)
...
'Create new document
Set NDoc = Ndb.CreateDocument
Doc.Form = YourForm
by wedwards
This discussion is closed to new replies.
Trending Windows Forum posts
Sort by Trending