Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / January 2007

Tip: Looking for answers? Try searching our database.

Subreport Is Changing When Opened

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
bhipwell - 29 Jan 2007 20:06 GMT
Hello all.  A very strange this is happening.  I have a report that has two
subreports on it.  One titled Health and the other titled Dental.  When I
actively open the report, sometimes the Dental subreport becomes the Health
report, thus having two Health reports.  When I go into design view, it also
confirms that the control has changed to the Health report?  Anyone have this
problem?

B
Allen Browne - 30 Jan 2007 01:12 GMT
Very strange. Are you certain that nothing is setting the SourceObject of
the subreport control?

If not, we must assume there is something wrong with the database. Try this
sequence (in order):

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. Check the Name of both subreport controls. Rename the Dental subreport
control (not the report in the subreport).

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

Signature

Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Hello all.  A very strange this is happening.  I have a report that has
> two
[quoted text clipped - 6 lines]
> this
> problem?
bhipwell - 30 Jan 2007 12:39 GMT
Thank You!

It was the auto correct feature that was causing the subreport to not save
the desired control source and replacing it with the most recent application.

B
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.