Hi Sophie,
It sounds as if you are working in entirely in Microsoft Word. This
newsgroup is for questions about using Microsoft Access to work with
external data. I suggest you start by looking at http://word.mvps.org
and then if necessary posting your question in the appropriate Microsoft
Word newsgroup.
On 7 Jun 2006 13:28:51 -0700, "Sophie" <ifnotwhynot2010[ at ]yahoo.com>
wrote:
[Quoted Text] >Hello,
>
>I designed a word template with some bookmarks and a word table with 7
>cols(Prod.No, Descr, price, qty, colr, etc) .
>I've also designed a userform with a list box to enable user select the
>products. This listbox is populated from a products table in access.
>When the user selects a product from the list, the Prod.No, Descr., and
>price details are entered into the word table cells. The remaining
>cols. are to be filled later.
>However, want to search the table (Descr. colum) , if a certain product
>is entered, then a standard text should be entered in a bookmark
>("bmk_match") in the template.
>Say if the user selects a product like: Dye light blue, Dye dark brown,
> Plastics light blue, etc.
>How can I write a macro to search through the table and when a product
>with only ..light blue
>description is found, then a standard text like "available once a
>month" should be inserted into a bookmark("bmk_match") in the template.
>
>Thanks
>sophia
--
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
|