Prev: Database name added to link tables!
Next: F- in Access - the troll is back
From: shumate62 on 13 May 2010 14:19
I'm throwing myself at the mercy of the experts and asking for help. I
volunteered to help my local library- fundraiser group create a database in
order to put their annual event names in a computer rather than the stack of
loose papers and notes they have in a three inch file. Each year they have to
spend days handwriting invites and sorting through the names etc and I wanted
to put it in a specific type of database. I thought I would be able to create
it but after spending every spare minute I had over the last month or two
watching tutorials and making a thousand broken databases I have reached the
conclusion that I am a failure at Access.
The database I wanted to create seems so simple I know it would take an
Access master a mere 27 and a half minutes to create it. The basic idea is
an address book table with Name, Address, Email, etc. Then a second table
that lists the type of person they are Speaker, Guest, Media, and then a
third table allows for the year to be selected for that type (In 2007 John
Smith was a Speaker and then in 2008 he was a Guest, etc) so you would have
the address book part and then a subform below that would allow for two combo
boxes with the type of person and the year.
Does anyone already have something like this created that I could just enter
in my data? Anything like that?
Thank you thank you thank you so much for any help!!!!
From: Jeff Boyce on 13 May 2010 14:39
Have you checked for templates at the Microsoft and other on-line sites?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"shumate62" <shumate62(a)discussions.microsoft.com> wrote in message
news:5762EA2F-8A4B-4E33-85D8-2B7FA9B31DF7(a)microsoft.com...
> I'm throwing myself at the mercy of the experts and asking for help. I
> volunteered to help my local library- fundraiser group create a database
> in
> order to put their annual event names in a computer rather than the stack
> of
> loose papers and notes they have in a three inch file. Each year they have
> to
> spend days handwriting invites and sorting through the names etc and I
> wanted
> to put it in a specific type of database. I thought I would be able to
> create
> it but after spending every spare minute I had over the last month or two
> watching tutorials and making a thousand broken databases I have reached
> the
> conclusion that I am a failure at Access.
> The database I wanted to create seems so simple I know it would take an
> Access master a mere 27 and a half minutes to create it. The basic idea
> is
> an address book table with Name, Address, Email, etc. Then a second table
> that lists the type of person they are Speaker, Guest, Media, and then a
> third table allows for the year to be selected for that type (In 2007 John
> Smith was a Speaker and then in 2008 he was a Guest, etc) so you would
> have
> the address book part and then a subform below that would allow for two
> combo
> boxes with the type of person and the year.
> Does anyone already have something like this created that I could just
> enter
> in my data? Anything like that?
> Thank you thank you thank you so much for any help!!!!


From: Steve on 13 May 2010 14:54
Hello,

I would like to offer to create your database for you. I provide help with
database applications for a small fee. You can spend every spare minute over
the next month or two trying to do it yourself or you can let me do it for
you and have it done soon; it's your choice. Contact me if you want my help.

Steve
santus(a)penn.com



"shumate62" <shumate62(a)discussions.microsoft.com> wrote in message
news:5762EA2F-8A4B-4E33-85D8-2B7FA9B31DF7(a)microsoft.com...
> I'm throwing myself at the mercy of the experts and asking for help. I
> volunteered to help my local library- fundraiser group create a database
> in
> order to put their annual event names in a computer rather than the stack
> of
> loose papers and notes they have in a three inch file. Each year they have
> to
> spend days handwriting invites and sorting through the names etc and I
> wanted
> to put it in a specific type of database. I thought I would be able to
> create
> it but after spending every spare minute I had over the last month or two
> watching tutorials and making a thousand broken databases I have reached
> the
> conclusion that I am a failure at Access.
> The database I wanted to create seems so simple I know it would take an
> Access master a mere 27 and a half minutes to create it. The basic idea
> is
> an address book table with Name, Address, Email, etc. Then a second table
> that lists the type of person they are Speaker, Guest, Media, and then a
> third table allows for the year to be selected for that type (In 2007 John
> Smith was a Speaker and then in 2008 he was a Guest, etc) so you would
> have
> the address book part and then a subform below that would allow for two
> combo
> boxes with the type of person and the year.
> Does anyone already have something like this created that I could just
> enter
> in my data? Anything like that?
> Thank you thank you thank you so much for any help!!!!


From: golfinray on 13 May 2010 15:03
Go to microsoft.com They have dozens of Access database templates already
built. Just search for Access Templates
--
Milton Purdy
ACCESS
State of Arkansas


"shumate62" wrote:

> I'm throwing myself at the mercy of the experts and asking for help. I
> volunteered to help my local library- fundraiser group create a database in
> order to put their annual event names in a computer rather than the stack of
> loose papers and notes they have in a three inch file. Each year they have to
> spend days handwriting invites and sorting through the names etc and I wanted
> to put it in a specific type of database. I thought I would be able to create
> it but after spending every spare minute I had over the last month or two
> watching tutorials and making a thousand broken databases I have reached the
> conclusion that I am a failure at Access.
> The database I wanted to create seems so simple I know it would take an
> Access master a mere 27 and a half minutes to create it. The basic idea is
> an address book table with Name, Address, Email, etc. Then a second table
> that lists the type of person they are Speaker, Guest, Media, and then a
> third table allows for the year to be selected for that type (In 2007 John
> Smith was a Speaker and then in 2008 he was a Guest, etc) so you would have
> the address book part and then a subform below that would allow for two combo
> boxes with the type of person and the year.
> Does anyone already have something like this created that I could just enter
> in my data? Anything like that?
> Thank you thank you thank you so much for any help!!!!
From: Linq Adams via AccessMonster.com on 13 May 2010 15:32
Steve , please go and play in heavy traffic! This site is not to eb used to
hawk your dubious skills, as you've been told hundreds of times!

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/201005/1

 |  Next  |  Last
Pages: 1 2 3 4
Prev: Database name added to link tables!
Next: F- in Access - the troll is back