By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,115 Members | 898 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,115 IT Pros & Developers. It's quick & easy.

Exporting report containing image from Access to Excel gets Subscript Out of Range

P: n/a
I have a number of reports in a MS Access application that have a logo
picture embedded in the report. When I run the report and choose File,

then Export to Excel, I get an error indicating "Subscript Out of
Range". If I remove the picture from the report, it works fine.

I have tried writing code to set the picture field's "Visible" property

to false when an export is attempted, but I still get the error.
Any ideas on how to get around this error without removing the embedded

picture?
Thanks,
KR

Jan 24 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
More information.....
I discovered this error occurs only when the image field is embedded in
a subreport. If I move the image field from the subreport to the main
report and delete the subreport it works fine. I would still prefer to
use the subreport, though, so if anyone has any suggestions, please
share.

Thanks.
KR

Jan 24 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.