Access 2003, Can run a report but can't print 1 section.

[stemo76]

I have created a report with subform/subreports. I can see all the
data on the screen but when I try to print it to a printer or adobe
distiller I get 'The Microsoft Jet Database engine could not find the
obect ". Make sure the object exists and that you spell its name and
path name correctly.'. Everything prints expect for the last
subform/subreport. If I remove that subreport it prints fine. The
subreport prints by itself if I run it individually.

Any suggestions?

[Linda Burnside]

Check the name of your subreport. If the name of the report contains a
character or word that is reserved, or it contains spaces, that may be your
problem. If you think this is the problem, rename the report.

Linda

<st*****@gmail.com> wrote in message
news:11********************@g47g2000cwa.googlegrou ps.com...

I have created a report with subform/subreports. I can see all the
data on the screen but when I try to print it to a printer or adobe
distiller I get 'The Microsoft Jet Database engine could not find the
obect ". Make sure the object exists and that you spell its name and
path name correctly.'. Everything prints expect for the last
subform/subreport. If I remove that subreport it prints fine. The
subreport prints by itself if I run it individually.

Any suggestions?

[stemo76]

I use the wizard to add it to the main report. I can change the name
but I use the same naming convention for about 6 different subreports
on the same main report. Could it be the name it is still displays on
the screen but gives me problems when I print?

Linda Burnside wrote:

Check the name of your subreport. If the name of the report contains a
character or word that is reserved, or it contains spaces, that may be your
problem. If you think this is the problem, rename the report.

Linda

<st*****@gmail.com> wrote in message
news:11********************@g47g2000cwa.googlegrou ps.com...

I have created a report with subform/subreports. I can see all the
data on the screen but when I try to print it to a printer or adobe
distiller I get 'The Microsoft Jet Database engine could not find the
obect ". Make sure the object exists and that you spell its name and
path name correctly.'. Everything prints expect for the last
subform/subreport. If I remove that subreport it prints fine. The
subreport prints by itself if I run it individually.

Any suggestions?

[Allen Browne]

It could be the name, if Access itself is confused about what things are
called. That happens regularly if you don't uncheck the Name AutoCorrect
boxes under:
Tools | Options | General
More info on problems caused by that issue here:
Failures caused by Name Auto-Correct
at:
http://allenbrowne.com/bug-03.html

After unchecking those boxes, compact the database:
Tools | Database Utilities | Compact

Then open the main report in design view.
Right-click the edge of the subreport, and choose Properties.
Change the Name of the subreport control.
Check the SourceObject property.
Save the change.
Compact again.

If the problem still persists, try a decompile. 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"
Open Access, and compact again.

Then remove any references you don't need. Open a code window.
Choose References from the Tools menu.
Uncheck any references you do not need.
For a list of the ones you typically need in your version of Access, see:
http://allenbrowne.com/ser-38.html

Still in the code window, choose Compile from the Debug menu.
Fix any errors, and repeat until it compiles okay.

At this point, you should have a database where the name-autocorrect errors
are gone, the indexes are repaired, inconsistencies between the text- and
compiled-versions of the code are fixed, and reference ambiguities are
resolved.

--
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.

<st*****@hotmail.com> wrote in message
news:11*********************@g49g2000cwa.googlegro ups.com...

I use the wizard to add it to the main report. I can change the name
but I use the same naming convention for about 6 different subreports
on the same main report. Could it be the name it is still displays on
the screen but gives me problems when I print?

Linda Burnside wrote:

Check the name of your subreport. If the name of the report contains a
character or word that is reserved, or it contains spaces, that may be
your
problem. If you think this is the problem, rename the report.

Linda

<st*****@gmail.com> wrote in message
news:11********************@g47g2000cwa.googlegrou ps.com...

>I have created a report with subform/subreports. I can see all the
> data on the screen but when I try to print it to a printer or adobe
> distiller I get 'The Microsoft Jet Database engine could not find the
> obect ". Make sure the object exists and that you spell its name and
> path name correctly.'. Everything prints expect for the last
> subform/subreport. If I remove that subreport it prints fine. The
> subreport prints by itself if I run it individually.
>
> Any suggestions?

[stemo76]

Followed your instructions. Same result. I did find however that the
problem seems to follow the last subreport that I add. I deleted two
and recreated them in a different order and the missing data is still
the last subreport that I created. I have 5 subreports attached to the
main report. 5 doesn't seem like a lot. when I added a 6th both the
5th and 6th had the same issue.

[Allen Browne]

As you say, 6 subreports does not sound excessive.

I guess you have double-checked that the LInkMasterFields/LinkChildFields
are correct.

It does not sound like this issue, where data disappears from a subreport,
but you might want to check it out:
http://support.microsoft.com/default...b;en-us;840656

--
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.

<st*****@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

Followed your instructions. Same result. I did find however that the
problem seems to follow the last subreport that I add. I deleted two
and recreated them in a different order and the missing data is still
the last subreport that I created. I have 5 subreports attached to the
main report. 5 doesn't seem like a lot. when I added a 6th both the
5th and 6th had the same issue.

[stemo76]

The subreports are all indiviuals, they are not linked to each other.

[Allen Browne]

The LinkMasterField/LinkChildField properties relate to how the subreports
are linked to the main report, not to each other.

--
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.

<st*****@gmail.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

The subreports are all indiviuals, they are not linked to each other.

[stemo76]

The main report is an empty shell. Then I add the subreports into the
details section of the main report. The main report is not based on
any table or query.