Form Filter/Sort Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

For some reason my form has stopped displaying all the records in my
database. When I click Records -> Remove Filter/Sort they all come back.

There aren't any filters applied to the form that I can see.

Ideas?

Thanks

Dave
 
Fixed it now. It had an event procedure On Open and On Load. There was no
code in it though so I'm not sure why it was behaving differently.
 
David, it sounds like the form had corrupted, so that code you could not see
was executing.

That can happend if the compiled version of the code is out of sync with the
text version of the code. You worked around the problem by removing the
[Event Procedure] property, but the bad code may still be present. Decompile
to remove it.

Suggested steps:

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

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, and compact again.
 
Back
Top