(Solved) Pissed off. Navigation Toolbar won't work

[ljh]

Hi,

I tried to use my filter and now the whole Navigation Toolbar (that's the toolbar where the auto-filter, form-filter, and Remove/Sort Filter are) is greyed out. So I can see the toolbar but I can't use it because it's greyed out. And I don't know how it happened.

Now when I try to open my database I keep getting a message box that says:
The data content could not be loaded. Column not found: Finigan in statement [SELECT "FROM" "Contacts Table" WHERE "Contacts Table" , "Salutation" LIKE "Finigan"]

If I click on the button that says 'More', it says:

Error. The data could not be loaded.

Error. SQL Statue: SOO22
Error Code: -28
Column not found: Finigan in statement [SELECT "FROM" "Contacts Table" WHERE "Contacts Table" , "Salutation" LIKE "Finigan"]

Information: The SQL command leading to this error is:
SELECT "FROM" "Contacts Table" WHERE "Contacts Table" , "Salutation" LIKE "Finigan"

I have no idea how to find the offending statement in Base. Where would this SQL command be? And how do I fix it? If I can fix the SQL command, will I get my Navigation Toolbar and Filter icons back again?

(Solved)

I opened up the database in Edit mode. I then opened the Forms Properties and clicked on Analyze SQL command. That's when the Filter statement showed up in the Filter box under Analyze SQL command. So I deleted the filter statement and the database now works.

Thanks RPG and Villeroy.

[RPG]

Hello

Study this tutorial

http://www.geocities.com/rbenitez22/OOo/index.html


I think you have played with the filter. You have insert a filter who have an empty result set.

remove filter or don't use filter. I don't mean delete toolbar.

On the toolbar there are two buttons
first from right : delete filter
third from right : apply filter

Romke

[ljh]

Thanks RPG,

I will read the tutorial.

The Delete Filter will not respond because it's greyed out (does nothing when you click on it). The Apply Filter also will not respond for the same reason.

[RPG]

Hello

On the form properties there is a field for
"Analyse SQL command" I think it must be YES

For your information and not important for your problem
I also get an the idea that it is not a toolbar but a control, what you mean.
The difference is a control is in a form and you can have more then one.
The toolbar is below the form there can be only one. The toolbar have more capabilities.


Romke

[Villeroy]

[ljh]

Thanks RPG and Villeroy,

At the moment I'm I'm shouting Whoohoo in my mind. It's come right. Your suggestions where to look worked.

I opened up the database in Edit mode. I then opened the Forms Properties and clicked on Analyze SQL command. That's when the Filter statement showed up in the Filter box under Analyze SQL command. So I deleted the filter statement and the database now works.

Now I know where to find the filter statements. Thanks guys.