Re: How to import certain fields from access database?

Use a Combobox on the form that is populated with data from the database and
then set the MatchEntry attribute of the combobox to 1 -
fmMatchEntryComplete. Then if the use types the word into the combobox, the
record that contains that word in that field will be selected.

--
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" <Haroon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:58A3BF2E-4960-41FE-A5E1-922543E27C61@xxxxxxxxxxxxxxxx
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_employ_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" <Haroon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1689ACD8-4BF8-4680-95E0-8195535D62A4@xxxxxxxxxxxxxxxx
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 :)





.

Loading