What can cause painful tingling in right hand that comes and goes. some days it worse than others? also tingling in right foot?

Neuropathy: It is most likely a neuropathy which can cause your symptoms and can be caused by many medical conditions and you should consult you family doctor and have it checked.

Carpal tunnel : Carpal tunnel syndrome is characterized by hand pain and recurrent numbness or "pins and needle" sensations in the thumb, index, middle finger and the lateral aspect of the ring finger. It may be triggered by repetitive use, like driving or keyboard typing. Diabetes or obesity increases risk of onset. Wearing a wrist cock- up splint is very effective. Surgery reserved for severe cases.