Reply
 
Thread Tools Display Modes
  #1   Report Post  
Karen Newman Karen Newman is offline
Junior Member
 
Posts: 0
Default MS Word form to reference a large database

I have a form that I need to modify. The change requires that the MS Word form references a database of about 2500 test numbers and test names. In case you are able to help me or know of someone who can, I’ve laid out the request below.

MS Word form (2 columns – multiple rows) needs to be able to:

• In Test Number column:
o User starts typing the 6-digit number/code in the cell
o The cell should auto-fill the test number/code from a list of about 2500
o The associated Test Name should auto-fill in the next cell in the row (in the Test Name column).

AND/OR:

• In Test Name column:
o User starts typing the test name in the cell
o The cell should auto-fill the test name from a list of about 2500
o The associated Test Number should auto-fill in the appropriate cell in the row (in the Test Number column).

I have no experience with VBA, but am open to trying it.

Last edited by Karen Newman : December 5th 12 at 04:15 PM
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Stefan Blom[_3_] Stefan Blom[_3_] is offline
external usenet poster
 
Posts: 6,897
Default MS Word form to reference a large database

This newsgroup doesn't get much attention anymore, unfortunately. You should ask
your question in a programming forum, such as the Office Programming forum in
the Microsoft Community
(http://answers.microsoft.com/en-us/o...tomize?tab=all) or the Word
for Developers forum at MSDN
(http://social.msdn.microsoft.com/For...rddev/threads).

--
Stefan Blom
Microsoft Word MVP




"Karen Newman" wrote in message ...

I have a form that I need to modify. The change requires that the MS
Word form references a database of about 2500 test numbers and test
names. In case you are able to help me or know of someone who can,
I’ve laid out the request below.

MS Word form (2 columns – multiple rows) needs to be able to:

• In Test Number column:
o User starts typing the 6-digit number/code in the cell
o The cell should auto-fill the test number/code from a list of about
2500
o The associated Test Name should auto-fill in the next cell in the
row (in the Test Name column).

AND/OR:

• In Test Name column:
o User starts typing the test name in the cell
o The cell should auto-fill the test name from a list of about 2500
o The associated Test Number should auto-fill in the appropriate cell
in the row (in the Test Number column).

I have no experience with VBA, but am open to trying it.




  #3   Report Post  
Lucas437 Lucas437 is offline
Junior Member
 
Posts: 5
Default

For those who need in-depth background checks, risk assessments and other data. I recommend checking out https://radaris.com/who-called-me With a commitment to providing relevant and accurate information, users receive the most up-to-date data available, underscoring Radaris commitment to accuracy and reliability. Very convenient!

Last edited by Lucas437 : May 17th 24 at 11:26 AM
Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Tool to create Cross Reference of Large WORD document needed bobk544 Microsoft Word Help 0 March 28th 07 02:50 AM
word form letters from access database over the network dave d. Mailmerge 3 March 5th 07 05:45 PM
Convert Large Document into searchable database DDawson Microsoft Word Help 5 October 30th 06 09:19 PM
Linking Access database to Microsoft Word form Carrie B Microsoft Word Help 1 March 7th 06 09:22 PM
printing a large database in word Harvie Nielsen Mailmerge 1 January 26th 06 04:58 AM


All times are GMT +1. The time now is 04:30 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"