Search results for query: *

Hi can anybody help me with this? I need to run a query to get a distinct value that can be in either 1, 2, 3 or all of 4 columns in one table. Can I get them listed in 1 combo box? thanks a mil for any help [glasses] Callcentreman

Thanks for the help! I hadn't figured out the deletion part so a star for your efforts! :o)

the formulas you need to use are concatenate e.g.=concatenate("a"+ A1)in cell B1 and then =INDIRECT(B1) in the output cell. good luck [bluegreedy]

Bindi, It might just be a bug in Word, because I had a user with the same issue. I am positive that all formulas and settings were correct, but it just didn't work and kept comming up with #n/a. when we replicated the vlookup in a new sheet, it worked grand. yet when we copied the sheets within...

For all you interested in my final script: @Command([MailForward]); @Command([EditGotoField];"To:") ; @Command([EditInsertText];"the.Other@mail.address"); @Command([MailSend]); @Command([FileCloseWindow]) [2thumbsup][swords]

Ok maybe I need to give a bit more detail to explain why I need this. In my company a lot of users mail my personal inbox with suggestions which *SHOULD* have been sent to a dedicated mail-in db. It's difficult to educate 8000 users ;) and instead of me manually forwarding these memos to this...

Hi all, I'm looking for a few lines of code to create a smart icon which will automatically forward the selected mail to another mail-address; no need to keep a copy for myself. Help is very much appreciated. thanx, Callcentreman

Thanks. Obviously my search was less successfull ;)

Hi all, Is there some Lotus script or @command I can run from a button to create a (new) local replica of a newly added db? All tips welcome!

Hi I'm looking for a way to pause script in a button from running while a large database is being detached and unzipped. Only afterwards the script may go to step 2. Who has any suggestions?