Regarding the P0171 - lean mixture bank 1, I've always suspected the culprit might be inadequate fuel pressure. Even after I had the fuel pump replaced, as well as the fuel pressure regulator, the fuel pressure at the fuel rail reads about 48, whereas I read that the needed fuel pressure should be between 52 and 59. So I really don't know what to do about that one....
Regarding the transmission, I may have to have a shop put a scanner on it.
Thanks again for the help.