obtaining automation error from Word - Microsoft Access / VBA

Kent Eilers

I'm learning automation basics here with a Access-Word mail merge.
Specifically I want to obtain a reference to the Word error object....using
Access as an automation client. Is this possible? I've looked over the
Word object model provided in the excellent "access 97 developer's handbook"
and did not find any treatment of this.

I have used Access as a front end to an Oracle database and have been able
to write code to handle ODBC errors vs. the VBA errors from the err object
(they are not always the same). I want to be able to do the same thing with
automation servers.

Anyone doing this and can i see a code sample?

Thanks

--
kent eilers
ke**@kaeService s.com

Nov 12 '05 #1

Subscribe Reply

2789

Kent Eilers

thanks Albert -- but i'm looking for the ability to get to the Word err
object ...not the VBA err object in Access.
"Albert D. Kallal" <ka****@msn.com > wrote in message
news:9A******** ************@ne ws1.calgary.sha w.ca...

Hum, I do have a nice sample database with a working mail merge. The code is designed such that you just have to place one line of code behind a button, and your form is now word merge enabled (it sends just the one record you
are looking at to word). Since the code library works with all forms, then
it means that you don't have to hard code any fields in the merge process.

You might want to read my notes on how I obtained a reliable word merge.
http://www.attcanada.net/~kallal.msn.../msaccess.html
However, I don't have a good word object reference for you.

--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
ka****@msn.com
http://www.attcanada.net/~kallal.msn

Nov 12 '05 #2

Similar topics

12066

C++ Word automation Extract text

by: mickeydisn | last post by:

Sub: C++ Word automation Extract text hello. I want extact text form a word document using a visual c++ programme. I have see a lot of documentation. and my analysis is that I must use a "word automation". I have foud a lot of exemple to use it but I need your precious help to

C / C++

615

Word automation bug

by: Mike MacSween | last post by:

Office 2000 From Access I've been starting an instance of word and doing a mail merge. Everything hunky-dory until I applied SP1 yesterday. Now this: dim wrd as Object set wrd = CreateObject("Word.Application")

Microsoft Access / VBA

3699

Strange Automation Issue

by: Neil Ginsberg | last post by:

I have a strange situation with my Access 2000 database. I have code in the database which has worked fine for years, and now all of a sudden doesn't work fine on one or two of my client's machines. The code opens MS Word through Automation and then opens a particular Word doc. It's still working fine on most machines; but on one or two of...

Microsoft Access / VBA

5508

Access Word 2003 Automation

by: Cheval | last post by:

Has anyone had any problems with inter-office automation between MS Word and MS Access in Office 2003? I have recently installed office 2003 in a new folder and have left the older office 2000 and office XP components installed. ie I have word/access/excel 2k/xp/2003 installed. I tried to do a usual access 2k to word 2k automation yet I get...

Microsoft Access / VBA

2528

Trapping Errors Via Automation

by: Neil | last post by:

Is there a way to trap an error generated in another app that is controlled via automation? I have an Access 2000 app that opens Word 2000 and proceeds to open a series of documents and, in each document, parse the contents and write it to an Access table (the Access app, after opening Word, runs a macro within Word which parses and writes to...

Microsoft Access / VBA

2435

Automation of Office programs

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, where I declare objects as follows: Dim oWordApp As New Microsoft.Office.Interop.Word.Application, after adding a reference to...

Visual Basic .NET

2737

Distributable Files for Word Automation?

by: Charles Law | last post by:

Does anyone know which files need to be distributed with a VB.NET application to enable Word automation on a m/c that does not have Word installed? Is this even possible / permissible? I currently get the error "File or assembly name Microsoft.office.interop.word or one of its dependencies was not found". TIA Charles

Visual Basic .NET

1804

TransferSpreadsheet, word automation; 'Error 0'

by: robert.waters | last post by:

Hello, When executing DoCmd.TransferSpreadsheet to an .xls file that's being used as a datasource for a Word mail merge document, if that Word document is currently open, the TransferSpreadsheet action fails with an 'Error 0'. I have tried different methods of trapping that error, and I still cannot get my app to indicate that the user...

Microsoft Access / VBA

2249

Automation of Word from .net 2

by: liya.tansky | last post by:

Hello, I'm developing an intranet (win XP, .NET 2, Visual Studio 2005, Microsoft.Office.Interop.Word.dll in references) and needed to implement find-replace in word doc before sending letter and it worked fine on my station. I've go it fine on my station, and it doesn't work at all on the web server. 1. What should be the configuration of...

ASP.NET

7656

Problem With Comparison Operator <=> in G++

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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...

C / C++

7808

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...

Online Marketing

5972

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...

Career Advice

4945

Couldn’t get equations in html when convert word .docx file to html file in C#.

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 then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...

C# / C Sharp

3450

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...

Networking - Hardware / Configuration

3443

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1884

transfer the data from one system to another through ip address

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 we have to send another system

C# / C Sharp

1014

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

704

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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 can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

General