[AccessD] Office Links > Analyze it with Excel

Have a look at this
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=uKAld5ikCHA.2708%40tkmsftngp11&rnum=1&prev=/groups%3Fq%3D%2522Microsoft%2BAccess%2Bcan%27t%2Bretrieve%2Bthe%2Bvalue%2Bof%2Bthis%2Bproperty%2522%2Bexcel%2Boffice%2Blinks%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26selm%3DuKAld5ikCHA.2708%2540tkmsftngp11%26rnum%3D1
It suggests you may have null in a numeric field or calculatedd control

http://ourworld.compuserve.com/homepages/attac-cg/
look in the Code and Design Tips area under the Reports section.  There is a
method discussed there as to how to modify your query to accept vb param at
run time and still use TransferSpreadsheet or OutputTo.

Jennifer Gross wrote:

>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 
>
>
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada