C
chico_yallin
I am trying to use an Excel file as a template for an Access report.
To do this, I have linked the excel range to an unbound OLE frame.
The OLE frame is placed over the report detail area and the data
controls of the report are placed over this at locations such that it
fills the template form behind it.
The properties of the frame related to the Excel are as follows,
Source Doc : C:\sajit\Data sheet templates.xls
Source Item : test1
where test1 is the range name in the templates Excel file.
I also have other sheets in the same file, which are used as templates
for other reports.
When I preview the report, Access displays the wrong sheet as the
template, even though the filename and the range name specified in
properties are correct.
I have tried giving the reference to the sheet, along with the range
name, even though the range name is unique to the Excel file. That
does not help either.
I want to do this report as I have it set up, I have other reasons for
that. That is to say that alternatives such as to use the picture
frame cannot help because it cannot accept an Excel file as file type
that it can link
To do this, I have linked the excel range to an unbound OLE frame.
The OLE frame is placed over the report detail area and the data
controls of the report are placed over this at locations such that it
fills the template form behind it.
The properties of the frame related to the Excel are as follows,
Source Doc : C:\sajit\Data sheet templates.xls
Source Item : test1
where test1 is the range name in the templates Excel file.
I also have other sheets in the same file, which are used as templates
for other reports.
When I preview the report, Access displays the wrong sheet as the
template, even though the filename and the range name specified in
properties are correct.
I have tried giving the reference to the sheet, along with the range
name, even though the range name is unique to the Excel file. That
does not help either.
I want to do this report as I have it set up, I have other reasons for
that. That is to say that alternatives such as to use the picture
frame cannot help because it cannot accept an Excel file as file type
that it can link