Export of report using runtime

[ttfitz]

I have an application developed in Access 2000, to be distributed as an MDE. For those folks without Access, they install the free Access 2007 runtime. For the most part, this seems to be working well. However, when viewing a report in Preview mode, if you right-click and select the "Export" option, when using the runtime you immediately get an error, which says, "you tried to perform an operation involving a function or feature that was not installed in this version".

Now, I know from some research that Access 2007 no longer supports exporting a report in Excel format, but this error comes up before you even try to choose a format. It works fine under the full version of 2000 and 2002, but not the runtime.

Any ideas why this is, and if there is any way to fix or get around it?

Thanks,

Tim

 

[genomon]

Runtime doesn't support that functionality. Install the full version of Access on the client PC.

"Before you criticize someone, you should walk a mile in their shoes.
That way, when you criticize them, you're a mile away and you have their shoes."

 

[ttfitz]

Genomon,

>Runtime doesn't support that functionality. Install the full version of Access on the client PC.

Thanks for the advice, but since I'm not willing to spend the money to upgrade my version in order to save a report as text, I'm doubtful the clients will, either.

But I do have another question - is this lack of support something new? I ask because I found someone with the 2002 runtime on their system, and the Export function worked fine there.

Thanks again for your help.

Tim

 

[KenReay]

Hi

Rather than leave the user to right click and export, have you tried giving them an option to output the report (or the query behind it) to Excel, and achieve the export using docmd.outputto or docmd.transfertext or docmd.transferspreadsheet ?



Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK