I m试图通过VBA在Microsoft Access,2003年与Lotus Notes数据库连接。 我的法典如下:
Set nSession = CreatObject(“Notes.NotesSession”)
Set nDatabase = nSession.GetDatabase("CN=MT_N01/O=Org name”,“LossPreventionBrchPrVI.nsf”, False
我尝试了服务器名称的改动,但似乎没有工作。 在Lotus Notes中,它似乎是“Server:MT_N01/Org name”。 我只尝试了“MT_N01”和“MT_N01/Org等名称”,但“NoteDatabase”变量却保持空洞。
任何ti?
我在这里可能错了,但我认为,在使用之前,你应当把届会的初始化方法称作会议。
http://www.ibm.com/developerwork/lotus/library/domino-msnet/index.html”rel=“nofollow noreferer” http://www.ibm.com/developerworks/lotus/library/domino-msnet/index.html。
我认为,行为是正常的; VBA知道nDatabase是一个变量/目标,但不知道其内容。 至少这是我2003年在Excel尝试你的法典时所看到的。
如nDatabase.ReplicaID,应退还数据库的识别码。 如果数据基没有适当装载,你将出现错误。
有许多良好的链接张贴在以下网址:.NET和Lotus Notes Interop。
除非你还需要“职业说明”班级和儿童班级,以操纵《说明》用户界面,否则,你应使用“Lotus.NotesSession”类而不是“说明”。 注 根据@Sagultay的答复,请打电话nSession.Intialize()。
In C#, I know that I can overload the constructor for a class by specifying it in the body of the class: public class MyClass() { public MyClass(String s) { ... } } This overrides the default ...
I have an Access app where I use search functionality. I have a TextBox and a Search Button on the form, and it does a wildcard search of whatever the user enters in the TextBox, and displays the ...
I recently switched to Outlook 2007 and noticed that my VBA-macros won t work. I use the following code to open a new appointment-item (and fill it automatically). It worked perfect in Outlook 2003, ...
The following code works. the connection opens fine but recordset.recordCount always returns -1 when there is data in the table. ANd If I try to call any methods/properties on recordset it crashes ...
I m using Application run to call several macros in order like this. Sub Run_All_Macros() Application.Run ("Macro_1") Application.Run ("Macro_1") End Sub When I start Run_All_Macros, all the ...
I m using Microsoft Office 2003 and creating a bunch of template documents to standardize some tasks. I asked this on Superuser.com and got no response so I m thinking it s too program-y and hoping I ...
I have to deal with a few macros (not VBA) in an inherited Access application. In order to document them, I would like to print or list the actions in those macros, but I am very dissatisfied by ...
I need to ensure a Macro which works on Visio 2003 doesn t cause problems on lower versions of Visio: specifically because I m writing to a property which doesn t exist on lower versions of Visio. ...
