Thank you everyone, I am lucky to be with him. I have been around several yorkies before and I know they are amazing dogs, excellent problem solvers too.
My back is doing a bit better but fortunately we have a patio I can let him out on for now until I get better.