Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Editing a sub-report in Access 2000 1

Status
Not open for further replies.

KeyserSoze

Programmer
May 18, 2000
79
US
I have a sub-report inside of a report form in an Access 2000 database. In Access 2003, if I wanted to open the sub-report in a new window, I would select the sub-report, perform a right-click and select "Subreport in New Window".

How can the same thing be done in Access 2000? I need to change some of the page setup parameters in the sub-report.

Thanks!
 
well instead of opening it thru the main report just open the subreport directly from the database window

I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY
 
IGPCS:

The sub-form is an object of the main form, hence the reason why I can't use your method.

..... Keyser
 
an object as in = ??

I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY
 
IGPCS:

I see what you are getting at. There should be an object in the list of report objects that the sub-report represents. The name and the source object properties are the following:

Name: LASACTComposites subreport2
Source Object" Report.LASACTComposite subreport2

"LASACTComposites" is a table. "subreport2" is nowhere to be found.

Is there a way in Access 2000 to list all of the dependencies of an object?

Thanks!

..... Keyser
 
yes it seems like you have a report called

"LASACTComposite subreport2"

check if you have this report




I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY
 
IGPCS:

The report is not there. Weird. Very weird.

..... Keyser (Confused)
 
did u import this report from some other database?


I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY
 
IGPCS:

As far as I know the report was not imported from another database. Even if it was, wouldn't the sub-report objects need to exist as well?

..... Keyser
 
ok
try to goto the database options and in the view tab make sure that the check on hidden objects are marked

I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY
 
and could if its imported, whoever imported it didnt import the subreport and only the main report

I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY
 
IGPCS:


The objects were hidden.

Thanks a ton for your help on this.

..... Keyser
 
You are welcome.

I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top