[AccessD] Office Links > Analyze it with Excel

Jennifer Gross jgross at databasicsdesign.com
Thu May 6 00:44:39 CDT 2004


Hi Group,

I am having a problem on certain reports using Office Links > Analyze it
with Excel.  Here is the error message I have received:
----------------
Microsoft Access can't retrieve the value of this property.

The property isn't available from the view in which you're running the
macro or Visual Basic code, or Microsoft Access encountered an error
while retrieving the value of the property.
To see the valid settings for this property, search the Help index for
the name of the property.
----------------

I've searched Microsoft's knowledge base as well as the archives with no
luck.

I am able to use Office Links > Excel successfully on the report's
underlying query.  There is nothing unusual going on in these reports, a
little sorting, a little grouping.  The only calculated controls are
totals in either the group or report footers.

Any insight would be greatly appreciated.

Thanks in advance,

Jennifer Gross
databasics
+ 01 (805) 480-1921
www.databasicsdesign.com 






More information about the AccessD mailing list