Reports not working after MS Update

[lauradilts]

I have an accounting program written in Access that I have been using for many years. Sometime shortly after mid-August 2011, apparently a Windows or Office automatic update went in that makes the criteria on all reports selected through a certain selection form not work any more. My husband backed up to a restore point of (I think) August 14th, and it worked again. The code that opens any report is:

DoCmd.OpenReport strRptName, acViewPreview, , strSQL

The strSQL is building fine, so that when it get to that line, it should work, but somehow it doesn't any more, so that I get all the records for all the dates. Does anybody have an idea where to look for a solution? He says that now that restore point has fallen off so I can't even go back to that any more.



I have checked the References and don't see anything labeled "missing".

[June7]

Did you test on another machine? Is this an mdb or accdb file, as opposed to an mde/accde?

[lauradilts]

It is an mdb file. I tried it on another machine with the same results.

[June7]

Would have paid to keep a copy of the working version.

You can try to rebuild the form and its code.

You can try importing all to a new project.

You could post the project to forum and will take a look at.

[lauradilts]

We finally tracked it down. It is a bug in MS Office 2010 SP1. The link to the hotfix is below. Separate downloads for 64-bit and 32-bit Access.

http://support.microsoft.com/kb/2596496