I really like the "Games Explorer" feature of RHP - http://www.redhotpawn.com/gamesexplorer/

I know how to access it using that link ^ but is it possible to access it from within the site, without opening a second tab or window?

Not yet, as far as I know, because it is still being tested. See the thread in the "Chess" forum.