I wanted to create a link from a page to an Excel spreadsheet in a shared server.
As the file path may change I created a keyword document in the database with the file path (prefixed with file://). I then created a page with a link hotspot on it and used the @DBLookup function to look for the keyword document with the filepath.
However, if I moused over the link hotspot in the client, it kept bringing up the dreaded nlnotes.exe error and Lotus Notes would crash.
To get round this I created an Action Hotspot on the page and used @Command ([Execute] ; @DbLookup.......) instead of the link hotspot. This opens the link no problem.
This may help for linking in to other objects. This is not a problem in Notes 6 with the attachment editing.
Instead of @DBLookup use @Command ([execute] @dblookoup...)
Do you have comments on this tip? Let us know.
This tip was submitted to the SearchDomino.com tip exchange by member Chris Smith. Please let others know how useful it is via the rating scale below. Do you have a useful Notes/Domino tip or code to share? Submit it to our monthly tip contest and you could win a prize and a spot in our Hall of Fame.
