PC Review


Reply
Thread Tools Rate Thread

Code to open Notes database and find a specific doc

 
 
=?Utf-8?B?UmF5TWlsbHM=?=
Guest
Posts: n/a
 
      29th Jun 2007
Briefly stated..code to open Notes database and find a specific doc...cant
iterate through all there are 166,000 of them
my code as is below.... ndoc comes back as a long i believe a Notesentry
key...so where do i go from here ???

' set up variables ...
Dim Domdb As NotesDatabase 'database contaiing
names/groups
Dim nsdc As NotesDocumentCollection 'doc collection returned
from query
Dim ndoc As NotesDocument 'notes doc
Dim ndoc1 As NotesDocument 'notes doc
Dim varColNames As Variant 'for col val and column
name arrays
Dim varColVals As Variant

' open a session ...
Set Session = CreateObject("Lotus.NotesSession")
Call Session.Initialize

' get the database we are looking at from drop down ...
strmisc = Trim(Me.cbDatabaseList.Value)

Set Domdb = Session.GetDatabase(Me.txtNamesServer, Me.txtNamesFile)

' check if open
If (Not Domdb.IsOpen) Then
strmisc = "The names database: used to identfy indiviual in groups could not
be opened"
MsgBox strmisc, vbInformation, "Error Opening names Database"
End If

' look up the first group ...
Set nsdc = Domdb.FTSearch("GAD-WP Admin", 0)
Set ndoc = nsdc.GetFirstDocument

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help with this code to find specific record efandango Microsoft Access Form Coding 9 4th May 2009 04:06 AM
Macro to find specific row on database/worksheet Ingo Microsoft Excel Programming 3 24th Apr 2008 11:07 AM
open Lotus Notes (.nsf) file & read the database in C# .net =?Utf-8?B?U293bXlh?= Microsoft C# .NET 0 19th Oct 2007 10:12 AM
how can i find a specific date of a database =?Utf-8?B?cmVuZWFiZXNtZXI=?= Microsoft Excel Misc 16 16th Aug 2005 11:45 PM
Find Specific Record in database Table via VB code =?Utf-8?B?Uk5VU1pAT0tEUFM=?= Microsoft Access Form Coding 7 1st Jun 2005 02:36 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:17 AM.