Re: Access query merge error

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Cindy M -WordMVP- (C.Meister-C_at_hispeed.ch)
Date: 07/06/04 

Date: Tue, 06 Jul 2004 10:21:44 +0200

Hi Jordan,

Mmmm. I think, in this case, your best hope for speeding
things up is to choose the record in the original query (set
criteria).

Next best would probably be to set the criterium in Word.
    - In the Recipients list, click the arrow next to a
field name, choose Advanced and set the criteria

    - Faster (due to building the Recipients list) would be
to show the Query Options dialog box via the toolbar. See
the Word 2002 section of my website's mail merge FAQ for
instructions how to get back functionality from old versions

    - You could also provide your own button on a toolbar to
display the dialog box directly, using this command

    Dialogs(wdDialogMailMergeQueryOptions).Show

> We have something like 2500 records. I have the
> documents linked to my main query (that includes
> calculations) that includes all of my records. We need
> to search because we don't want to merge all of the
> records to the printer, just print the current record we
> need. We're using the Find Record button on the toolbar,
> once it's merged. All of the documents are saved with
> the merge information, so we only see the Recipients box
> the one time when I set them up with the merge data.
>
> >How many records does the data source contain?
> >
> >Why are you searching a record? And in what interface
> (the
> >merge document, the Recipients dialog box, other)?
>

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun
8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail
:-)

Quantcast