I've been working on a small "how to" series of painting and refinishing furniture. Here are the first two parts - Stripping and Staining and Finishing Wood. Here are the before and after photos.
You can do this. Don't let those old pieces bring you down. Give them new life. :)