[AccessD] Office Links > Analyze it with Excel

Jennifer Gross jgross at databasicsdesign.com
Thu May 6 13:58:22 CDT 2004


Thanks Marty - at least I know I'm not the only one.

I wound up building my own export to excel, which works without a hitch.

Thanks again,

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

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MartyConnelly
Sent: Thursday, May 06, 2004 11:43 AM
To: Access Developers discussion and problem solving
Subject: Re: [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=uKAl
d5ikCHA.2708%40tkmsftngp11&rnum=1&prev=/groups%3Fq%3D%2522Microsoft%2BAc
cess%2Bcan%27t%2Bretrieve%2Bthe%2Bvalue%2Bof%2Bthis%2Bproperty%2522%2Bex
cel%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



-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com






More information about the AccessD mailing list