View Single Post
  #3  
Old April 19th, 2010, 10:02 PM posted to microsoft.public.access.gettingstarted
John W. Vinson
external usenet poster
 
Posts: 18,261
Default glorified address book

On Mon, 19 Apr 2010 12:32:01 -0700, shumate62
wrote:

OK- I need to go right back to start. I'm volunteering for a charity that has
a yearly event and they need help!, --seriously they have 400 names on scraps
of papers in manila folders--. I know the bare minimum about Access but know
it's got to be a heck of a lot better to struggle through Access than allow
them to handwrite 400 addresses for one more year. (seriously, like with a
pen? yes.)
I need a glorified address book.
I need a table with name, address etc.
But the key second part that stops this from just being a generic address
book is that I need to sort them by a second set of features such as Author,
speaker, Media, invitee, because some names will be just Author, or maybe be
Author and Speaker and I need to be able to create labels based on one or
more of these features. (guy works for the media and was a speaker so he has
two features).
My ***vision*** if you bear with me, is the "Address Book table" which
allows for the form to type in the address "stuff" and then click down to a
subform? to have a simple drop down box that I can then select one or several
features.
This seems blindingly simple, is this something a simple volunteer can do?


I believe that my Church Membership database would meet your needs (it
actually does a bit more than that, but it will at least let you create a list
of any number of people, any number of "lists" (each person can belong to any
number of lists), generate mailing labels or emails, and other kinds of
reports. There's nothing "churchy" about the database, and it's free.

If you're interested in a copy, send me an email to jvinson at wysard of
info dot com; edit out the blanks and make the obvious punctuation changes.

--

John W. Vinson [MVP]