Linking to Lotus Notes Files

[swaybright]

Hi All,

Our company primarily uses Lotus Notes as storage for our data. I am building a MS Access database that brings portions of data from several of these depositories and evaluates the data.
I want the user to be able to quickly access the raw data (located in Lotus Notes) if he/she desires. Ideally, I want to place a command button that will open a specific record in a specific LN database.

Does anyone have any ideas/experience in coding this?

Shane

 

[lespaul]

First off, Notes doesn't have records, it has documents. Second, what do you mean by 'access the raw data'? Do you want to show the form that shows the document or do you want to access the document and show the values of the fields?


Leslie
landrews@metrocourt.state.nm.us

There are 10 types of people in the world -
those who understand binary
and
those who don't!

 

[swaybright]

Leslie,

Thanks for the reply. I know nothing about Lotus Notes, so any help is appreciated.

We have a database that contains technical reports. From those tech reports, I have gleaned information for the access database, but not all data. I want a user to be able to click over the the tech report without having to research Lotus Notes. The reports are generally pdf files.

Also we have a second DB that contains technical service information. This is entered/viewed in a field format (I guess; when a user clicks an edit button, they can change values in select locations). I called this a record for lack of a better description. I want to link to this view in a single click as described above.

I hope that helps.
Shane

 

[lespaul]

I'm still not clear on what you want to do (sorry it's the end of a long day and my brain is fried!).

The database with technical reports, is this the Notes Database you are trying to connect to and this is where the pdf files are? Are you trying to open the pdf from an Access form?

Sorry for my denseness this afternoon.

Leslie

 

[swaybright]

I apologize for being unclear.

in tech reports db I want to connect and open the specific pdf (one and only one) this pdf is contained within a document(?; what I originally called a record; it is some location is cyberspace)

in service request db I want to connect and open a specific document(?)

I communicate well about Lotus because I don't know how it is constructed.

Shane

 

[swaybright]

Let me rephrase that:

I DON'T communicate well about Lotus because I don't know how it is constructed

Shane

 

[swaybright]

OK,
I think I have a better feeling of what I want.
Using the technical reports example:
1. Open database technical reports
2. Go to view "by title"
3. Search for title "X" (value recorded in access)

Using the service request example:
1. Open database service request
2. open folder "archived"
3. go to view "by TSR number"
4. search for "N"(value recorded in access)
5. if no hits then
6. open folder "R&D"
7. go to view "by period"
8. search for "N" (value recorded in access)

Those are the actions I actually use to find the info in Lotus Notes.
Maybe that helps (or maybe makes things even more murky).

Shane

 

[lespaul]

From a Notes person's perspective, that helps! Now, I have a better idea of what you're looking for. Now once you find a matching document, what do you want to do with it?

leslie

 

[lespaul]

Here's a thread you may find helpful Thread245-363482

It's for sending an email through LotusNotes from Access, but an email is just another document (and the inbox is a view, so is the calendar), but it shows how to connect.

 

[swaybright]

I just got back to my computer. I will check out the thread you sent, thanks! I have put in a send email code, but I just copied it from Ben Ohara's post thread181-310363 .
Once I find a matching document, I just want to view it. Like putting a hyperlink on a form--click and view.

Shane

 

[swaybright]

Leslie,
how do I call a specific database??

Function OpenTechReport(strTitle as string)
Dim doc As Object 'Lotus NOtes Document
Dim ws As Object 'Lotus Notes Workspace
Dim oSess As Object 'Lotus Notes Session
Dim oDB As Object 'Lotus Notes Database
Dim X As Integer 'Counter
'use on error resume next so that the user never will get an error
'only the dialog "You have new mail" Lotus Notes can stop this macro
'Check to see is Lotus Notes is open
If fIsAppRunning = False Then
MsgBox "Lotus Notes is not running" & Chr$(10) & "Make sure Lotus Notes is running and you have logged on."
Exit Function
End If

On Error Resume Next

Set oSess = CreateObject("Notes.NotesSession&quot
Set oDB = oSess.GETDATABASE("", "&quot
Call oDB.name of database???


End Function

 

[lespaul]

If you open your Lotus Notes, go to
File - Database - open

Change to the correct server, find the database name you want to open and click it ONCE, on the bottom it says file name: something.nsf

The "something.nsf" is name of the database you want to open.

That should get you started. From there you'll want to set the view, search the view and then open the matching document.

Glad your making progress!
Leslie