Search results for query: *

We are upgrading to Windows XP from Windows NT. This means Access 97 will be replaced with Access 2002. As we currently have many many many Access 97 databases scattered around the department, what problems can I expect when we convert them all to the new version? I know I can read the MSDN...

more than 255 fields? wow! what not "normalize" the data some that each field and its value equals one record in a two field table?

why not put the 90th percentile caculation in a select query then create a second query (based on the first select) with the totals?

...network drives but not if I do a search in the C: hard drive? With Application.FileSearch .LookIn = "C:\TEMP" .FileName = "*.mdb" If .Execute() > 0 Then MsgBox "There were " & .FoundFiles.Count & _ " file(s) found.&quot...

Hi Jeff I am having exactly the same problem, did you ever resolve it? Thanks, Klopper

This may help: http://www-10.lotus.com/ldd/notesua.nsf/0b345eb9d127270b8525665d006bc355/6932e4fc0ea17542852569d9005bd01d?OpenDocument&Highlight=0,COM

True, thanks. I have also discovered that my Domino reference object was missing and the ActiveX component was not registered. A case of RTFM... This was very useful...

OK, I have working - it was a case of RTFM! :-) The Helpfile at the link below gives instructions about how to register the required Domino ActiveX component. In this case, go to the DOS command prompt and change directory to C:\Program Files\Notes then type "regsvr32 nlsxbe.dll&quot...

Definitely Notes Release 5.08 and I have Lotus Domino Object set to the domobj.tlb file. I wonder if has something to do with my registered ActiveX components..how do I find out which Lotus / Domino are required? Your patience and help is much appreciated.

The error is first line of OpenSess routine: Set COMSess = New Domino.NotesSession

Good point Richie! I am now getting error 429 (ActiveX component cannot be created) which apparently could be related to the windows registry, ocx's and dlls or my workstation admin rights... all a bit beyond me and I'm afraid I am losing the will to carry on... :-( Are you aware of any other...

Hi Paul How do I do this registering you suggest? thanks Klopper

Hi I wish to automate the detachment of email attachments from ny Notes (Version 5.08) to a given path. I am using Access 97 VBA to access the Domino COM on NT. The code below errors ("Object variable or with variable not set") at the indicated line. Any ideas anyone? Many thanks...

Got your spreadsheet Richie, but get same problem: "Run-time error 91, Object variable or With block variable not set." I think the is the Domino.NotesSession and Domino.NotesDatabase variable are not set in the code and I am not sure hwo to do this. I only have Notes R5 installed...

Got your spreadsheet Richie, but get same problem: "Run-time error 91, Object variable or With block variable not set." I think the is the Domino.NotesSession and Domino.NotesDatabase variable are not set in the code and I am not sure hwo to do this. I only have Notes R5 installed...

scking, do stored procedures in access exist?

That'll great xb70@bigfoot.com

Ok I have found and selected domobj.tlb! But this line of code: Set View = odb.GetView("($Inbox)") give me a "variable not defined" error what is odb? and how is it set?

Thanks for the suggestions Mortan, Richie. Richiem, I have some VBA skills but not much COM / OLE so bear with me: Your suggested code looks perfect! I am using Access or Excel 97 and Notes R5; I cannot see the Domino reference, so coudl you advise where I can download the required .tlb file...

Just for the record: I had an Access 97 db with a hugely complex query which pulled data from various spreadsheets and a back end Access 97 database. With many many calculated fields, it would take about 15 minutes to export the query to Excel using Docmd.Transferspreadsheet. From the...