Great, you can help me out then I love techs, haha.

Sounds like, as Daiser said, you need to do the infamous EGR repair just like in the 98-02 Accord V6. It's in the FAQ. Unless you have experience with cars this is best left to a dealer.

PO420 has been discussed a lot, it's either the post cat O2 sensor or your cat itself. Most of the time it's the O2 sensor, easy enough to replace.

P1738 is the 2nd gear pressure switch, easy too.

If you think you can perform any of these repairs yourself, we can help you with how to do it with stuff from Honda since there isn't much Ody info around here.