Thanks! We'll email you
when relevant content is
added and updated.
I have a doucment which when composed creates a drop down dynamically taking values from a column in a view from another database.
I also have another button next to this field which when clicked should take the value selected from the drop down and search another databse view for a document to match this value and then open it. But it doesnt work ..
Sub Click(Source As Button)
Dim session As New NotesSession
Dim workspace As notesuiworkspace
Dim db As NotesDatabase
Dim view As NotesView
Dim uidoc As notesuidocument
Dim doc As NotesDocument
Dim product As String
Set db = New NotesDatabase( "server", "prductlist.nsf" )
Messagebox db.IsOpen (it returns falsoe here )
Set view = db.GetView( "prodbydesign" )
Messagebox view.Name ( Again error saying that database is not open)
Set uidoc = workspace.CurrentDocument
product = uidoc.FieldGetText( "odesref" )
Set doc = view.GetDocumentByKey(product)
I NASICALLY JUST NEED THIS DOCUMENT TO OPEN WHEN USERS NEED TO SEE THE DOCUMENT..I DONT MIND OPENING IT IN EDIT MODE BUT WOULD PREFER TO OPEN IT IN NON-EDIT MODE
January 15, 2007 11:41 AM
January 16, 2007 4:41 PM