S
Sajit
I am trying to use an Excel file as a template for an Access report.
To do this I have linked the excel file through an unbound OLE frame.
The OLE frame is placed over the report detail area and data controls are
placed over this at locations such that it fills the template form behind it.
The properties of the frame related to the Excel area as,
Source Doc : C:\sajit\test.xls
Source Item : test1
where test1 is the range name in the Excel sheet.
I also have other sheets which are used as templates for other reports.
When I preview the report, Access picks the wrong template, even though the
filename and the range name specified in properties are correct.
I have tried giving the reference to the sheet, even though the range name
is unique to the Excel file.
That does not help either.
I have posted this query on Excel and Access groups, on Microsoft and other
Access and Excel forums, did not receive any answer.
I conclude this is another Access bug.
Would Microsoft care to address and fix this in an update patch, soon enough.
Sajit
sxviswan (at the rate of) yahoo.co.uk
Abu Dhabi
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...c443f989a4&dg=microsoft.public.access.reports
To do this I have linked the excel file through an unbound OLE frame.
The OLE frame is placed over the report detail area and data controls are
placed over this at locations such that it fills the template form behind it.
The properties of the frame related to the Excel area as,
Source Doc : C:\sajit\test.xls
Source Item : test1
where test1 is the range name in the Excel sheet.
I also have other sheets which are used as templates for other reports.
When I preview the report, Access picks the wrong template, even though the
filename and the range name specified in properties are correct.
I have tried giving the reference to the sheet, even though the range name
is unique to the Excel file.
That does not help either.
I have posted this query on Excel and Access groups, on Microsoft and other
Access and Excel forums, did not receive any answer.
I conclude this is another Access bug.
Would Microsoft care to address and fix this in an update patch, soon enough.
Sajit
sxviswan (at the rate of) yahoo.co.uk
Abu Dhabi
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...c443f989a4&dg=microsoft.public.access.reports