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 --------------------------------- It's here! Your new message! Get new email alerts with the free Yahoo! Toolbar. [Non-text portions of this message have been removed]
