I've got a Word User Form which lets the user type in information (e.g. Name, DateOfBirth, etc.) within a Word template. This information is saved as VBA variables and inserted in the right places (for instance, a business letter, referral or prescription).
My question is this: Can I store the data in an Access database, so over the years I don't have to keep entering the same stuff over and over. Some of these fields could include 500 or 1000 names. Word is the natural program for my word processing and Access seems like a natural place to store the data, but I'm kind of at a loss for how to do this -- preferably with the usual bells and whistles (jumps to entries alphabetically as you type, allows you to enter new Names, DateOfBirth, etc. and store it, etc.)
Any suggestions, code or resources (books, sites, etc.) appreciated.
My question is this: Can I store the data in an Access database, so over the years I don't have to keep entering the same stuff over and over. Some of these fields could include 500 or 1000 names. Word is the natural program for my word processing and Access seems like a natural place to store the data, but I'm kind of at a loss for how to do this -- preferably with the usual bells and whistles (jumps to entries alphabetically as you type, allows you to enter new Names, DateOfBirth, etc. and store it, etc.)
Any suggestions, code or resources (books, sites, etc.) appreciated.
