RE: Mailmerge in Word: Suppress opening ACCESS 2000 again

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: jokobe (jokobe_at_discussions.microsoft.com)
Date: 03/14/05 

Date: Mon, 14 Mar 2005 07:49:05 -0800

Hi Raoul,

thanks for your answer.
- all available updates are installed.
- I'm referencing the query in the word doc.

The reference is needed because the user is working with
the single document before, and then should be able to
start the mailmerge from ACC.

Why is it, that ACC has to be opened again- even if one
instance is running?

"JaRa" wrote:

> Are you running the latest service packs for both products?
>
> Are you referencing (mailmerge) the/a database in the word document?
>
> - Raoul
>
> "jokobe" wrote:
>
> > I'm starting a mailmerge from ACC2000 like this:
> > Set wordObj = CreateObject("word.application")
> > wordObj.Visible = True
> > wordObj.Documents.Open case_file
> > wordObj.Documents(case_file).Activate
> >
> > In case_file the file name is stored. Every time the
> > file is opened, WORD opens a second instance of the database.
> > Is there a way to suppress this?
> >

Relevant Pages

  • Re: Auto populating in a table
    ... It does sound to me as if you are introducing redundancy. ... database and leaves it open to inconsistent data. ... in the county of Staffordshire, ... legitimate to have both task and area columns in a referencing table. ...
    (microsoft.public.access.gettingstarted)
  • Re: Keeping DB structure but adding new tables
    ... database names rather than storing them as values in rows in tables. ... Each year you'd append the data which you receive as text files to the ... table before inserting related data into a 'referencing' table. ... To restrict a report to a particular year you can either restrict the ...
    (microsoft.public.access.gettingstarted)
  • Re: Referencing fields
    ... >database to put student information in. ... If I could tackle referencing other cells ... should be worth yours to come back to the newsgroup for the answer. ... public replies to public messages are free. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: sorting/merging in C
    ... An A-record may be referencing B records. ... considered an error in the database that must be corrected. ... I want to know how many of such B-records there are ... write down the B reference in a separate file, "knownrefs" ...
    (comp.lang.c)
  • RE: Unrecognized database format C:Program FilesMicrosoft Offic
    ... OK, so it isn't referencing your hard drive, it's referencing G: ... example a 2002 format database in 2000. ... my users had no problems opening or working in the database either. ... the following message appears Unrecognized database format ...
    (microsoft.public.access.security)