Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Move Access record to Lotus Notes

Posted on 1999-01-22
3
171 Views
Last Modified: 2013-12-25
I need to write a Vb program that will move a record from an Access database to a Lotus Notes Database. I can get the data out of Access but need to now how to place into a Lotus Notes database.
0
Comment
Question by:jfreisen
3 Comments
 
LVL 12

Expert Comment

by:mark2150
ID: 1499374
Write it in Lotus Script instead of VB. Lotus should be able to read Access.

m

0
 
LVL 2

Accepted Solution

by:
cjwik earned 50 total points
ID: 1499375
Lotus has a odbc driver that you can install into odbc. Then you can use odbc as your gateway, this is a easy and slow way to solve it. There are some "pumps" out there that can move data back and forth, fast and easy. TenFour has one.
0
 
LVL 1

Expert Comment

by:ronaldvr
ID: 1499376
I Agree about the Lotusscript answer, however Notes is also registered as an OLE service.
This is from the Notes help database:
Using Notes classes in Visual Basic

Visual Basic programmers can access Notes objects through the Notes.NotesUIWorkspace and Notes.Session OLE automation objects. Notes must be installed on the same machine as the Visual Basic program. NotesUIWorkspace and NotesSession head hierarchies that give you access to all the Notes classes.
In Visual Basic, you cannot create new Notes objects as in LotusScript. You must apply CreateObject to Notes.NotesUIWorkspace or Notes.Session and work down through the hierarchies using the available methods. For example, if you want to open a Notes database in the back-end, use CreateObject to create a Notes.Session OLE automation object, then use the GetDatabase method of NotesSession to set a reference variable of type Object.
In Visual Basic, declare the reference variables for all Notes objects as type Object. When you finish using a Notes object, set the reference variable to Nothing to free the memory it uses.
Use dot notation, just as in LotusScript, to access an object's properties and methods.
Constants must be specified by actual numeric value rather than name. In LotusScript, you can get the value by displaying it. For example:
Messagebox ACLLEVEL_AUTHOR,, "ACLLEVEL_AUTHOR"

Example Code:
Examples: Using Notes classes in VisualBasic

1. This example represents two command buttons on a Visual Basic form. The first button writes a new document in an existing Notes database by creating a NotesSession object through OLE and creating NotesDatabase and NotesDocument objects through Notes methods. The second button frees the memory used by the Notes object before unloading the Visual Basic form.
Private Sub Command1_Click()
     Dim session As Object
     Dim db As Object
     Dim doc As Object
     Set session = CreateObject("Notes.NotesSession")
     Set db = session.GetDatabase("", "test4.nsf")
     Set doc = db.CreateDocument()
     doc.Form = "Main Topic"
     doc.Subject = Form1.Text3.Text
     doc.Body = Form1.Text2.Text
     Call doc.Save(True, False)
End Sub
Private Sub Command2_Click()
     Set doc = Nothing
     Set db = Nothing
     Set session = Nothing
     Unload Form1
End Sub
2. This example represents a command button on a Visual Basic form. The button launches Notes if it is not already running, then opens test4.nsf in the local data directory.
Private Sub Command3_Click()
     Dim ws As Object
     Set ws = CreateObject("Notes.NotesUIWorkspace")
     Call ws.OpenDatabase("", "test4.nsf")
End Sub

0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
how to open Waze.com/livemap from address saved in DB? 26 207
Spell Check in VB6 13 126
How to hault or freeze parent form when a 2d form is open in vb6 3 39
Problem to line 23 53
Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question