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
---------------------------------
Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, news,
photos & more.
[Non-text portions of this message have been removed]
