Search results

dee, any working day, i.e., monday to friday, when added with 7 will always have 5 working days between them... am I missing something? henry

dee any day of the week when added with 7 will have 5 working days between them... what's the problem? hehehe henry

yes, the false part for each iif is missing... and when the code first iif evaluates to false (which is missing), the if exits and returns nothing.

THANK YOU SO MUCH JHILLBH... With a few edits the code worked welll.... many many thanks...

thanks for the reply llkhoutx.... however, what i need is how to activate / call up from a form, via a command button, a hyperlink that is embedded in a hyperlink field of a record in, say, table "A", that is not the database default of the form, say table "B", but the record in table "A" is...

Please share code for this: The hyperlink to a word.doc file is embedded as field of record in a table. I would like to be able to call up or activate that hypelink from a form with the end of opening the word.doc file. thanks in advance...