Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Connect to View with Filter
Is there any way to connect to a view with a pre-defined fileter.
I have a table users and a table customers, with no relationship. I have x-joined joined these to make a view CustomerLetters for users to create personalised letters to customers. This view contains every user with every customer - a lot of records. When the user connects to mailmerge they have to filter recipients by user to just select themself, then filter by customer for the account they want, then run the mail merge on a single record. Is there any way to automate the first part by passing the user id to the view before bringing the full list of recipients onto the client? Thanks hals_left |
#2
|
|||
|
|||
Hi Hals,
Using VBA, you should be able to set the QueryString property to filter the data the user sees. Is there any way to connect to a view with a pre-defined fileter. I have a table users and a table customers, with no relationship. I have x-joined joined these to make a view CustomerLetters for users to create personalised letters to customers. This view contains every user with every customer - a lot of records. When the user connects to mailmerge they have to filter recipients by user to just select themself, then filter by customer for the account they want, then run the mail merge on a single record. Is there any way to automate the first part by passing the user id to the view before bringing the full list of recipients onto the client? 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 :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reading Layout View Problematic as Default Word Attachment View | Page Layout | |||
thumbnail page view | Microsoft Word Help | |||
Advanced Filter Won't Unfilter | Mailmerge | |||
Everything disappears in Normal view | Page Layout | |||
Word 2003: track changes opens in final view instead of final sho. | Microsoft Word Help |