The suggestion of the Kodak Dx-7590 does not appear to me to be a good choice. The specifications for close focus is 60cm (2 feet) and macro closest focus of 12cm (2.5 inches).

Your Pentax S5i has better specifications than that.

Here is a link to a comparison of specifications for four camras:

http://www.dpreview.com/reviews/compare_post.asp?method=sidebyside&cameras=kodak_dx7590%2Cnikon_cp7900%2Cpentax_optios5i%2Csony_dsct9&show=all

Look down the list of specifications until you get to:
Normal Focus Range
Macro Focus Range

You can click the yellow question mark (?) beside those titles to get an explaination.

I added the Nikon 7900 because it has better specifications than your Pentax S5i.

.......

You can probably find a camera store that will let you try the Nikon 7900, to see if fits your other needs too.

...
..
.