Best Road To Take

I am wondering if I am taking the correct approach to a program.  I produce documents for clients based upon the state requirements and by project name (construction related).  So I have a folder per state with several Word documents.  These documents contain links to a table that the user fills out specifying names, addresses, work description, etc.  This works fine but I want to write a program that is easier for my clients to use.  

I am thinking that I need to build datatables in VB (one for each contact type ie "Owner", "Contractor", "Architect", etc.)  I wish for my clients to be able to "add" information that will then become part of a drop down menu as many have repeat customers, contractors, etc.

I then want to be able to copy these fields into the Word document (either by bookmark or others have suggested mail merge).

Another expert told me to build a text file in VB but I don't think that is necessary.  I want to make sure I start this with a good foundation so any advise would be helpful.  You guys have been awesome thus far in helping me and I really appreciate it.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Is it going to be a single user app? If so, Access can serve you adequately. You would need tables for entities as you said and forms to add/edit/view these entities.
noticetoownerAuthor Commented:
The problem I am having is that most of my clients do not have or use Access.  So I am trying to work exclusively with VB 2010 Express and Word 2010.
They do not need to have Access. They just need to have Jet database engine(included in Windows) or Office connectivity components based on version of Access that you choose to use.
HTML5 and CSS3 Fundamentals

Build a website from the ground up by first learning the fundamentals of HTML5 and CSS3, the two popular programming languages used to present content online. HTML deals with fonts, colors, graphics, and hyperlinks, while CSS describes how HTML elements are to be displayed.

Éric MoreauSenior .Net ConsultantCommented:
you can use OpenXML (freely) to fill a Word document, check

another way to go if you can afford its price is to use
noticetoownerAuthor Commented:
Okay I set up a database in Access with the appropriate tables.  I then mail merged them in Word.  I have a few questions as to how to go from here.  If I just want to use Access and Word how do I prompt users for information if they do not have Access?  Also a few of the documents will be used several times with different data throughout the project.  I will need to prompt user for that info also, how is that built?  I am looking at the Access posts here to see if I can find the info and links on my own.  I have attached file to clarify what I mean.
noticetoownerAuthor Commented:
dont think it attached my doc...
You would be better off building an application which allows users to manage their information and then export to word. You have multiple options for this export functionality including mail merge, bookmarks, openxml etc.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Helen FeddemaCommented:
See my Code Sample #24 (Four Ways to Merge to Word):

or my more recent ebook, Working with Word (can't give the link, but it is available from the Office Watch Website).  This book covers methods and techniques through Word 2010.
noticetoownerAuthor Commented:
I think codecruiser has the right idea.  I will need to use Access and Word but I want this to be a VB exe program.  I am just lost as to where to begin so I started with Access and am learning more about it.  I guess I will post another question as to the best layout as I am confused on how to organize my data.
noticetoownerAuthor Commented:
Codecruiser has been awesome in helping me, not just with code but set up and basics...
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.