Reports and Quweeries

  • Thread starter Thread starter Brian Keanie
  • Start date Start date
B

Brian Keanie

In my application I have to produce 5 different reports. Each report
contains a SubReport.
I created a query for the initial SubReport and the MainReport as well as
the SubReport and MainReport based on the appropriate queries. I then copied
each of these four objects to create the other 4 reports and of course
connecting to the appropriate queries.
Believe it or not they all functioned as expected then for no apparent
reason the Reports all seemed to refer to a source which I had not dictated
they should. The entire 5 of them seem to have a mind of their own. I can
open one up and point it to the correct query, save it and reopen to find it
has reverted to whatever.
Can anyone shed some lite on what is going on? Much appeciated as always.

Regards
 
Brian, this sounds like a corruption caused by Name AutoCorrect.

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.

Post back if that does not solve the problem.
 
Back
Top