473,503 Members | 1,701 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Failed to publish report to MS Office Word or Excel

I preview a report and click the button to publish the report to
Word or Excel document. It works correctly until today. It
produced below error message.

Microsoft Office Access can't complete the Output operation.

The Visual Basic code you entered contains a syntax error or the Output
procedures are not available.

Make sure there isn't a syntax error in your code. If the syntax is
correct, run Setup to reinstall Microsoft Office Access. If you want to
preserve your security or custom settings, back up the Microsoft Office
Access workgroup information file.
For information on backing up files, search the Microsoft Windows Help index
for 'backing up files'.

It occurred using toolbar icon or Tools pull-down menu. All the references
are
in place. I uninstalled the Office and reinstalled a clean copy without any
effect. In addition, it did not occur on other pcs.

Any suggestion to the possible causes and fixes are appreciated.

Thanks!

Scott

Dec 2 '06 #1
2 5168
On Sat, 2 Dec 2006 12:04:29 +0800, "Scott" <No*************@GMail.com>
wrote:

When you reinstall, be sure to install the Full version. You don't
want to leave out the component you so desperately need.

-Tom.

>I preview a report and click the button to publish the report to
Word or Excel document. It works correctly until today. It
produced below error message.

Microsoft Office Access can't complete the Output operation.

The Visual Basic code you entered contains a syntax error or the Output
procedures are not available.

Make sure there isn't a syntax error in your code. If the syntax is
correct, run Setup to reinstall Microsoft Office Access. If you want to
preserve your security or custom settings, back up the Microsoft Office
Access workgroup information file.
For information on backing up files, search the Microsoft Windows Help index
for 'backing up files'.

It occurred using toolbar icon or Tools pull-down menu. All the references
are
in place. I uninstalled the Office and reinstalled a clean copy without any
effect. In addition, it did not occur on other pcs.

Any suggestion to the possible causes and fixes are appreciated.

Thanks!

Scott

Dec 2 '06 #2
Tom,

Thanks for your response. I did reinstall the full version like the first
time when I use this function without problem. It appears to me that the
link to publish report to MS Office Word or Excel is broken or any dll file
is corrupted. Unfortunately, I have no idea about such things and looking
for the advice who has in-depth knowledge about the program.

Scott

"Tom van Stiphout" <no*************@cox.netwrote in message
news:lr********************************@4ax.com...
On Sat, 2 Dec 2006 12:04:29 +0800, "Scott" <No*************@GMail.com>
wrote:

When you reinstall, be sure to install the Full version. You don't
want to leave out the component you so desperately need.

-Tom.

>>I preview a report and click the button to publish the report to
Word or Excel document. It works correctly until today. It
produced below error message.

Microsoft Office Access can't complete the Output operation.

The Visual Basic code you entered contains a syntax error or the Output
procedures are not available.

Make sure there isn't a syntax error in your code. If the syntax is
correct, run Setup to reinstall Microsoft Office Access. If you want to
preserve your security or custom settings, back up the Microsoft Office
Access workgroup information file.
For information on backing up files, search the Microsoft Windows Help
index
for 'backing up files'.

It occurred using toolbar icon or Tools pull-down menu. All the
references
are
in place. I uninstalled the Office and reinstalled a clean copy without
any
effect. In addition, it did not occur on other pcs.

Any suggestion to the possible causes and fixes are appreciated.

Thanks!

Scott


Dec 2 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
503
by: zfeld | last post by:
1. Where do I get the Office 2003 PIAs? On the MSDN download site there are only downloads for XP office PIAs. Do they automatically get installed to the GAC with the installation of office 2003? ...
1
3177
by: Patrick Stephens | last post by:
Hi, I produce a 30 page report that has data and two charts per page, using Access 2000. My boss wants the report in WORD format. When I use the "office links" to "Publish it in Word" I get all...
0
330
by: nigelc | last post by:
Hi, I have just converted a clients' bespoke database from Access 97 to Access 2003. The also got new machines, so Office 2003 was installed (no previous versions of Office exist). They can...
2
4380
by: kelly.pearson | last post by:
I had some access 97 reports that I used to publish to MS Word that worked before we upgraded to Access 2K and Word 2K. Although there were some minor discrepancies, I was able to tweak the access...
1
2345
by: Michael Connerton | last post by:
The company I work for still uses Excel97. In a weaker moment I added the pia for Excel2003 in attempt to get more programatic functionality out of some Excel interfaces I have been writing. The...
2
11437
by: William LaMartin | last post by:
I have created a program that allows for the automation of things in Word documents, like changing the values of DocVariables and the links to Excel Sheets. I did it using interoperoperatability,...
2
3326
by: Scott | last post by:
I usually preview a report and click the button to publish the report to Word document from time to time. It works correctly until today. It produced below error message. Microsoft Office...
1
10862
by: Bob Alston | last post by:
Anyt one know a way to correctly export an Access 2003 report to Excel? I can use Tools - Office Links ..... just fine with a query or table. But when I try a report it just doesn't work. right...
0
2411
by: tekiegreg | last post by:
Hi there, here is a snippet of my code that I've been getting an error message on, basically what I've been trying to do is pull out appointments, serialize to an object as well as all the contacts...
0
7074
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7273
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7322
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
6982
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7451
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
4667
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3150
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1501
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
0
374
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.