filter sort error - crash!

  • Thread starter Russ via AccessMonster.com
  • Start date
R

Russ via AccessMonster.com

Whenever I use toolbar under Record - Remove filter sort Access 2003 crashes!
Any fixs?
 
A

Allen Browne

We might need some more info to help you identify the problem here.

By "crash", I assume you mean "... shut down by Windows, sorry for the
inconvenience."

Does this happen with any form? Or with a particular form?

Is the RecordSource of this form a table? a query? a SQL statement?

What is in the form's Filter property before you attempt to remove the
filter? To find out, while the form is open and filtered, press Ctrl+G to
open the Immediate Window, and enter:
? Forms![Form1].Filter
replacing Form1 with the name of your form.

The problem could be one of the generic problems that occurs in Access, or
it could be a specific bug related to this form. The steps below could help
if it's one of the generic problems:

1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

2. Compact the database to get rid of this junk:
Tools | Database Utilities | Compact/Repair

3. Close Access. Make a backup copy of the file. Decompile the database by
entering something like this at the command prompt while Access is not
running. It is all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

4. Open Access (holding down the Shift key if you have any startup code),
and compact again.

5. Open a code window.
Choose References from the Tools menu.
Uncheck any references you do not need.
For a list of the ones you typically need in your version of Access, see:
http://allenbrowne.com/ser-38.html

6. Still in the code window, choose Compile from the Debug menu.
Fix any errors, and repeat until it compiles okay.

At this point, you should have a database where the name-autocorrect errors
are gone, the indexes are repaired, inconsistencies between the text- and
compiled-versions of the code are fixed, reference ambiguities are resolved,
and the code syntax is compilable.

If it is still a problem, the next step would be to get Access to rebuild
the database for you. Follow the steps for the first symptom in this
article:
Recovering from Corruption
at:
http://allenbrowne.com/ser-47.html
 
R

Russ via AccessMonster.com

Allen, thanks for the great response. I will go through each step and try
these and will post results.

fyi...
By "crash", I assume you mean "... shut down by Windows, sorry for the
inconvenience." Yes, this is what happens.
Does this happen with any form? Or with a particular form? Yes.
Is the RecordSource of this form a table? a query? a SQL statement? mostly queries.
Click to expand...

Allen said:
We might need some more info to help you identify the problem here.

By "crash", I assume you mean "... shut down by Windows, sorry for the
inconvenience."

Does this happen with any form? Or with a particular form?

Is the RecordSource of this form a table? a query? a SQL statement?

What is in the form's Filter property before you attempt to remove the
filter? To find out, while the form is open and filtered, press Ctrl+G to
open the Immediate Window, and enter:
? Forms![Form1].Filter
replacing Form1 with the name of your form.

The problem could be one of the generic problems that occurs in Access, or
it could be a specific bug related to this form. The steps below could help
if it's one of the generic problems:

1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

2. Compact the database to get rid of this junk:
Tools | Database Utilities | Compact/Repair

3. Close Access. Make a backup copy of the file. Decompile the database by
entering something like this at the command prompt while Access is not
running. It is all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

4. Open Access (holding down the Shift key if you have any startup code),
and compact again.

5. Open a code window.
Choose References from the Tools menu.
Uncheck any references you do not need.
For a list of the ones you typically need in your version of Access, see:
http://allenbrowne.com/ser-38.html

6. Still in the code window, choose Compile from the Debug menu.
Fix any errors, and repeat until it compiles okay.

At this point, you should have a database where the name-autocorrect errors
are gone, the indexes are repaired, inconsistencies between the text- and
compiled-versions of the code are fixed, reference ambiguities are resolved,
and the code syntax is compilable.

If it is still a problem, the next step would be to get Access to rebuild
the database for you. Follow the steps for the first symptom in this
article:
Recovering from Corruption
at:
http://allenbrowne.com/ser-47.html
Whenever I use toolbar under Record - Remove filter sort Access 2003
crashes!
Any fixs?
Click to expand...
Click to expand...
 
R

Russ via AccessMonster.com

Allen,
I found a form that was set as pivotchart that was causing the problem so I
deleted it and remove filter is now working. But noticed that any forms views
based as pivotchart will not work. Any suggestion here?
Thanks
Russ

Allen said:
We might need some more info to help you identify the problem here.

By "crash", I assume you mean "... shut down by Windows, sorry for the
inconvenience."

Does this happen with any form? Or with a particular form?

Is the RecordSource of this form a table? a query? a SQL statement?

What is in the form's Filter property before you attempt to remove the
filter? To find out, while the form is open and filtered, press Ctrl+G to
open the Immediate Window, and enter:
? Forms![Form1].Filter
replacing Form1 with the name of your form.

The problem could be one of the generic problems that occurs in Access, or
it could be a specific bug related to this form. The steps below could help
if it's one of the generic problems:

1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

2. Compact the database to get rid of this junk:
Tools | Database Utilities | Compact/Repair

3. Close Access. Make a backup copy of the file. Decompile the database by
entering something like this at the command prompt while Access is not
running. It is all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

4. Open Access (holding down the Shift key if you have any startup code),
and compact again.

5. Open a code window.
Choose References from the Tools menu.
Uncheck any references you do not need.
For a list of the ones you typically need in your version of Access, see:
http://allenbrowne.com/ser-38.html

6. Still in the code window, choose Compile from the Debug menu.
Fix any errors, and repeat until it compiles okay.

At this point, you should have a database where the name-autocorrect errors
are gone, the indexes are repaired, inconsistencies between the text- and
compiled-versions of the code are fixed, reference ambiguities are resolved,
and the code syntax is compilable.

If it is still a problem, the next step would be to get Access to rebuild
the database for you. Follow the steps for the first symptom in this
article:
Recovering from Corruption
at:
http://allenbrowne.com/ser-47.html
Whenever I use toolbar under Record - Remove filter sort Access 2003
crashes!
Any fixs?
Click to expand...
Click to expand...
 
A

Allen Browne

Someone else may have a suggestion on that, Russ.

I never use PivotChart, so have not struck the problem.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Russ via AccessMonster.com said:
Allen,
I found a form that was set as pivotchart that was causing the problem so
I
deleted it and remove filter is now working. But noticed that any forms
views
based as pivotchart will not work. Any suggestion here?
Thanks
Russ

Allen said:
We might need some more info to help you identify the problem here.

By "crash", I assume you mean "... shut down by Windows, sorry for the
inconvenience."

Does this happen with any form? Or with a particular form?

Is the RecordSource of this form a table? a query? a SQL statement?

What is in the form's Filter property before you attempt to remove the
filter? To find out, while the form is open and filtered, press Ctrl+G to
open the Immediate Window, and enter:
? Forms![Form1].Filter
replacing Form1 with the name of your form.

The problem could be one of the generic problems that occurs in Access, or
it could be a specific bug related to this form. The steps below could
help
if it's one of the generic problems:

1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

2. Compact the database to get rid of this junk:
Tools | Database Utilities | Compact/Repair

3. Close Access. Make a backup copy of the file. Decompile the database by
entering something like this at the command prompt while Access is not
running. It is all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

4. Open Access (holding down the Shift key if you have any startup code),
and compact again.

5. Open a code window.
Choose References from the Tools menu.
Uncheck any references you do not need.
For a list of the ones you typically need in your version of Access, see:
http://allenbrowne.com/ser-38.html

6. Still in the code window, choose Compile from the Debug menu.
Fix any errors, and repeat until it compiles okay.

At this point, you should have a database where the name-autocorrect
errors
are gone, the indexes are repaired, inconsistencies between the text- and
compiled-versions of the code are fixed, reference ambiguities are
resolved,
and the code syntax is compilable.

If it is still a problem, the next step would be to get Access to rebuild
the database for you. Follow the steps for the first symptom in this
article:
Recovering from Corruption
at:
http://allenbrowne.com/ser-47.html
Whenever I use toolbar under Record - Remove filter sort Access 2003
crashes!
Any fixs?
Click to expand...
Click to expand...
Click to expand...
 
Top