Thanks for your time,
I used your code, however, It still has bug, so far, I can debug all
the way down to --strPN = rs("PersonnnelNumber").Value & ""
Then it raise error again, saying "run time error 3265" Item cannot be
found in the collection corresponding to the requested name or ordinal
do you have any idea,
thanks in advance