I was just about to post that thread too. I've never had a wheel come off on me either. That must have been a crazy ride. I would have got the thing towed to IPS if the lugs weren't staying though.
PPG Yellow should be an easy color to get for the base. Since the red is in the clear it shouldn't be hard the blend in.
Glad you guys got another car for now. A honda trans shouldn't be more then $300. That's if you do the labor yourself though.