A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

glorified address book



 
 
Thread Tools Display Modes
  #1  
Old April 19th, 2010, 08:32 PM posted to microsoft.public.access.gettingstarted
shumate62
external usenet poster
 
Posts: 13
Default glorified address book

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?
  #2  
Old April 19th, 2010, 09:10 PM posted to microsoft.public.access.gettingstarted
Daniel Pineault
external usenet poster
 
Posts: 658
Default glorified address book

Yes, this can be put together rapidly, even by a novice. If you wish to do
it yourself, post your questions here (give as much detail as you can) and we
will be glad to help out.

I, like many developers here, also do not mind helping out charity groups.
If you wish use the link below to access my business e-mail and contact me
through my website and I would be more than willing to help you get up and
running.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.



"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?

  #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]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:40 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.