Hello,
I’m trying to make a vb app which needs to pull data from a notes view first of all. I have succeeded in doing this with excel before and have adapted the code a little to try and get it working in my VB app:
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim db As Object
Dim NotesSession As Object
Dim view As Object
Dim pipeDoc As Object
Dim entry As Object
NotesSession = CreateObject("Lotus.NotesSession")
Call NotesSession.Initialize()
Db = NotesSession.GetDatabase("removed", "removed", False)
If Not Db Is Nothing Then
Dim pipeNo As String
Dim row As Integer
row = 4
view = Db.getview("removed")
If view Is Nothing Then
MsgBox("View is nothing...")
End If
pipeNo = "E118733"
While Not (pipeNo = "")
entry = view.getEntryByKey(pipeNo, True)
If Not (entry Is Nothing) Then
pipeDoc = entry.document
Test.Text = pipeDoc.getItemValue("AnticoDecision")(0)
End If
End While
Else
MsgBox("Failed to get handle")
End If
MsgBox("Done")
End Sub
End Class
I’m gettign on error here:
NotesSession = CreateObject(“Lotus.NotesSession”)
Stating that it connot create the active X component… any ideas? Shouldn’t I needed a notes dll to enable the connection?
Thanks,
Richard