Hi! I, too, am going through a sort of tough transitional period w/ my husband (father to my 6.5 month old).
I've found that what he needs the most is reassurance that he's doing a wonderful job, he needs to know that I trust him no matter what, and he needs time to figure out how to calm the baby in his own way.
He has his moments where he says he's just 'not good at this,' and that he's mourning his loss of freedom. (He's almost 39 and this is his first baby, so I'm very understanding of his feelings). But I've found that with lots of love & trust, he figures things out very well, and has turned into a very good daddy. Another thing that we remind ourselves about is that it won't be this tough forever. This baby's going to grow quickly, and will soon be a little more independant.
Good luck & take care...