Advanced Filter Won't Unfilter

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nucleo - 01 Aug 2005 11:17 GMT

Hi, using Mail merge to query a view on a MSSQL server. the advanced
filter works fine. Do the mail merge and no problem.

Back to the main merge document, i want to change the filter, but the
filtered data is still there, and i can only filter the filtered data
=S

To get back to showing all of the data, i have to re-open the
connection file to get the data back...

So, is there a way to make the filter un filter itself? without having
to re-open the connection?

Thanks

Reply to this Message

Peter Jamieson - 01 Aug 2005 14:35 GMT

Yes, this is an irritating problem.

As far as I know, all you can do is
a. change the filter to one that includes everything (e.g. if you are
filtering on Country, Country > '' might get you all the records back, but
there will still be a filter, which may for example affect performance or
result in records with null values being excluded.
b. go into the VBA Editor and, for example, use the Immediate Window to
set, for example

ActiveDocument.MailMerge.DataSource.QueryString = "SELECT * FROM
""tablename"""

However, that's probably harder than going through the connection process
again.

Peter Jamieson

> Hi, using Mail merge to query a view on a MSSQL server. the advanced
> filter works fine. Do the mail merge and no problem.
[quoted text clipped - 10 lines]
>
> Thanks

Reply to this Message

Nucleo - 02 Aug 2005 10:41 GMT

your probably right =)

i think i will stick with just re-opening the connection.

with any luck, the client will only use the mail merge doc, then close
it, then re-open later.

thanks for the heads up

Nuc

Reply to this Message

Rate this thread: