View Single Post
  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Haroon Haroon is offline
external usenet poster
 
Posts: 15
Default How to import certain fields from access database?

hi Doug,

thanks for reply, i want to add a search box on the form to search for data
from the database, e.g. have a textbox where user types in cust. ref and
presses search button and relevant textboxes get populated with the results,
e.g. cust add, date, etc.



"Doug Robbins - Word MVP" wrote:

Use a userform that contains a combobox or list box that is populated with
data from the Access database.

See the following pages of fellow MVP Greg Maxey's website:

http://gregmaxey.mvps.org/Create_and...a_UserForm.htm

http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm



--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Haroon" wrote in message
...
hi

i made a form using ms word 2003 vba with few textboxes, when the user
types
in one of the field, e.g. customer ref, the database imports few selected
field from databse into bookmarks on word document, e.g. customr name,
add,
date, etc.

i dont want to use the search option in mailmerge to find records, as i
also
want the user to type/add additional data on the textboxes in the form to
be
placed in bookmarks on document, as some data is not coming from database.

anyone got idea?

thanks in advance