Discussion Locked

MS Word Database

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I would like to know how to setup a database for word documents, This is what I would like it to do,I would type in the last four letters of the last name and it would open all the documents starting with the last four letters of the last name that I have typed in. I already have all the reports typed, all I need to know is how I would set it up. Just to let you know I do not know anything about VB or Macros Any help would be really really gratefull.

5 replies

by anthony

If you do not know anything about VB or macros your best bet (especially if all the documents are in the same folder) would be to use Windows' Search (Start Menu -> Search). When you enter the search criteria ask for .doc filetypes which contain the 4 letters you wish to search for in the particular folder that you have stored them in.

If you would like to have an application custom built you may contact my company which provides this service via email at sales@anthonystark.com or by phone at 636-575-0102.

Good Luck,

Anthony Stark
President / CEO
AnthonyStark.com, Inc.
www.AnthonyStark.com
Internet & Microsoft Windows Application Development and Consulting.

by bob sellman

To make a worthwhile database, you'll have to enter some data into the database. I'd suggest something like the following, which you could do in Access.

Create a table to contain important information about each document. I've listed some suggested ideas below just to give you some ideas.

File name [you must have this column]
Directory [also required to find the file]
Title
Short description
Date
Group [like the company group/district/etc.]

Create a continuous form in Access that lists the documents and associated data.

Create another form that includes a control that will invoke Word to display a document. The actual document file will be determined by the contents of the controls you place on the same formthat contain the file name and the directory.

I realize that this is a short description, but it should point you in the "right" direction.

This discussion is closed to new replies.