wrote in message
ups.com...
Your persistance is admirable Karl, :)

Did you try my suggestion to use view lookups? Was that faster?

No, I'm not that familiar with Notes and assumed that views would
probably present a problem either because I don't have design access
or, if that's not an issue, that they would only be created locally.

I know you don't know too much about Lotus Notes, but you keep saying that
you don't have design access to the database. That is probably irrelevant.
You should be able to use existing views for your lookups. You write the
code in eithe ranother Notes database (where you have design access) or in
VB/VBA, Delphi or some other tool that support COM. You then code against
the Notes database, using the code I posted... Not hard at all.

The tool needs to work for a number of different people in different
locations - which presently it does. The only issue is that it seems a
little slow (takes about 45 mins to retrieve 10,000 documents) but like
I say this isn't a major issue. The user has the option of setting the
application to run at a specified time so they can have it run while
they're at lunch or at home.

Write it as a small VB application and distribute it to the users. Or write
it as a Notes application and have it replicate out to the different
servers, that would be better and make maintenance/changes/updates easier in
the future. Obviously you have a Notes infrastructure, take advantage of
that...

I guess the only person that really gets bugged by it is me when I have
to test it.

Thanks again for your help Karl,

You are welcome.

/Karl