How do I turn on the navigation pane?

[CanvasShoes]

Some of you may have clicked on this thread thinking...Oh, this is SOOO easy. But wait! Don't write that check yet. So, I've been to the Access options and clicked on the "show navigation pane" etc. No go. I tried F11, no such luck. Tried ctrl F (sorry you can't do a find from this part of the database it tells me).

I have a database with a supposed "switchboard" that isn't really a switchboard (at least when I click "manage switchboard" I get an error message that says something like "you need a switchboard first).

I didn't design this database, I just have to use it. And it was already cranky and silly in Access 2003, but in 2007? It's REALLY getting me cranky. Sigh.

All I really want to do is figure out why the idiot that designed the darn thing created one teensy little block in one of the pages in one of the reports (which I can't find or GET to without the damned navigation pane) that has an incorrect equation of some sort in it.

It's supposed to return a specific letter code for any value between 0- <2, another letter code for 2 to >100 and a last letter code for greater than 100. For some stupid reason it's returning the middle letter code for a value that is LESS than 2, not 2 or greater as it's supposed to.

I would fix it if could find it, but I can't find it unless I can get to a window that will show me the reports, etc.

Thanks in advance. And yes, you can laugh at me if it does turn out to be something really simple!

 

[HiTechCoach]

Try holding down the shift key when you open the database.

 

[gemma-the-husky]

is the value negative, or even exactly 0 or 2 or 100

iit may have been miscoded to something like this

if value >0 and <2 then return 1
else if value > 100 then return 3
else return 2

it will then return 2 for negative values, or values exactly 0,2 or 100

 

[CanvasShoes]

Try holding down the shift key when you open the database.

Ahhhh, THANK YOU!! That was easy (you may now laugh at my silly end user self )

Gemma, I'm not sure if that's what they did or not. I do need the formula to be pretty much equal to this for example:

"any value lower than 2 gives me an A for one specific "cell" in my report.
"any value between 2 and 100 gives me a value of B and so on".

I'm still trying to find the formula that they've got attached to the "cell" in my main report. If worse comes to worst, I have figured out a way to simply type in the correct letter code. But I'm a little AR, and I haaaate doing that. For the timebeing I may have to do that, but I would like to figure out how to work my way around this ridiculously over-designed database at some point. (I'm reasonably okay at designing my own, but these folks have got hidden this and that and so on, if we could, we'd jettison it and start over, but it's a client thing).

Thanks!