The secret is to set the white balance correctly for the type of light you are using. If you are using a point-and-click camera, shooting indoors you want to set it to the little lightbulb icon (or something similar). This will get rid of the orange hue that is caused by your incandecent bulbs.
Another option is to take your photo outdoors in daylight but you might get a slight bluish cast (nothing near as bad as you get indoors though).
Another options is to buy the GE 6500k "daylight" balanced florecent bulbs. I saw the small ones on sale at Walmart the other day for $2 for a 2pack which is really good because the larger ones are around $9 each. You can get a bunch of small ones or just use a longer shutter speed if your camera allows (on a tripod of course).
If you use daylight balanced bulbs make sure all other lights are turned off before snapping the pictures. You REALLY don't want to try and deal with mixed lighting temperatures. Also when you take a picture indoors using standard bulbs, make sure your window shades are down or you'll get mixed light and confused the camera.
when i do any macro photos (lego, other miniatures, jewelery, etc) I always use the daylight balanced 100watt equivalent florecents.
hope this helps.