F- in Access

[shumate62]

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!!!!

[Jeff Boyce]

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.

Post by shumate62
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!!!!

[Steve]

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

Post by shumate62
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!!!!

[Linq Adams via AccessMonster.com]

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!

[Stop$teve]

Post by Steve
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

--
Get lost $teve. Go away... far away....

Again... Get lost $teve. Go away... far away....
No-one wants you here... no-one needs you here...

This newsgroup is meant for FREE help..
No-one wants you here... no-one needs you here...
OP look at http://home.tiscali.nl/arracom/whoissteve.html
(Website has been updated and has a new 'look'... we have passed 12.000 pageloads... it's a shame !!)

Arno R

[John... Visio MVP]

Post by Steve
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

Stevie is our own personal pet troll who is the only one who does not
understand the concept of FREE peer to peer support!
He offers questionable results at unreasonable prices.

These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified individuals who gladly help for free. Stevie
is not one of them, but he is the only one who just does not get the idea of
"FREE" support. He offers questionable results at unreasonable prices. If he
was any good, the "thousands" of people he claims to have helped would be
flooding him with work, but there appears to be a continuous drought and he
needs to constantly grovel for work.

Please do not feed the trolls.

John... Visio MVP

[golfinray]

Go to microsoft.com They have dozens of Access database templates already
built. Just search for Access Templates
--
Milton Purdy
ACCESS
State of Arkansas

Post by shumate62
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!!!!

[Jeff Boyce]

Before you make a decision to hire someone who solicits paid work in these
(free) newsgroups, be aware that the Code of Conduct for these newsgroups
prohibits soliciting paid work. Do you really want to hire someone who
ignores the rules?

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.

Post by shumate62
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!!!!

[Steve]

There is nowhere in the Code of Conduct for these newsgroups that prohibits
offering help with an Access application for a reasonable fee.

Steve

Post by Jeff Boyce
Before you make a decision to hire someone who solicits paid work in these
(free) newsgroups, be aware that the Code of Conduct for these newsgroups
prohibits soliciting paid work. Do you really want to hire someone who
ignores the rules?
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.

Post by shumate62
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!!!!

[Arvin Meyer [MVP]]

Post by Steve
There is nowhere in the Code of Conduct for these newsgroups that
prohibits offering help with an Access application for a reasonable fee.

Offering a product or service for sale is considered spam. Spam is
prohibited. You've been told this many times and yet you persist. The fact
that you must spam the newsgroups for work must be a testament to the poor
quality of your work, since you'd have sufficient business if you satisfied
your clients.

There are posters here that sell a product. If they mention their product in
the body of their post, they always include other free competing products as
well. You are welcome of course, to use 3 or 4 lines in your SIG to promote
your services provided you actually offer relevant help in the posting.

[John W. Vinson]

On Thu, 13 May 2010 11:19:01 -0700, shumate62

Post by shumate62
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!!!!

I have a copy of your current Word doc describing your needs and will try to
get back to you in the next day or so (free of charge).

[Steve]

That's very nice of you, John, but why don't you make similar offers to many
other OPs you respond to?

Further, you condone the actions of visio john and arno r but they never
make an offer like yours to any OP. In fact their conduct obviously violates
the Rules Of Conduct of the newsgroups and you condone their actions. OPs
need to be very wary of hypocrites in sheep's clothing.

Steve

Post by John W. Vinson
On Thu, 13 May 2010 11:19:01 -0700, shumate62

Post by shumate62
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!!!!

I have a copy of your current Word doc describing your needs and will try to
get back to you in the next day or so (free of charge).
--
John W. Vinson [MVP]

[Stop$teve]

That's very nice of you, John, but why don't you make similar offers to many other OPs you respond to?
Further, you condone the actions of visio john and arno r but they never make an offer like yours to any OP. In fact their conduct
obviously violates the Rules Of Conduct of the newsgroups and you condone their actions. OPs need to be very wary of hypocrites in
sheep's clothing.
Steve

It's about time to take your pills again $teve...
You are becoming VERY lunatic again.

There is hope:
When MS is really discontinuing newsgroups and transitioning users to Microsoft forums they can (and will) ban you.

Arno R

[Steve]

Case in point - he offers zero help to this OP!

Steve

Post by Stop$teve

Post by Steve
That's very nice of you, John, but why don't you make similar offers to
many other OPs you respond to?
Further, you condone the actions of visio john and arno r but they never
make an offer like yours to any OP. In fact their conduct obviously
violates the Rules Of Conduct of the newsgroups and you condone their
actions. OPs need to be very wary of hypocrites in sheep's clothing.
Steve

It's about time to take your pills again $teve...
You are becoming VERY lunatic again.
When MS is really discontinuing newsgroups and transitioning users to
Microsoft forums they can (and will) ban you.
Arno R

[Larry Linson]

Post by Steve
Case in point - he offers zero help to this OP!
Steve

Au contraire, Steve. By cautioning the OP against your solicitation for
business, he has, in fact, been very helpful to the OP.

See the SIG below? It identifies me, the poster; it brags a bit about one
accomplishment -- a book; and points out that (free) newsgroup support for
Access will continue to be available after these newsgroups are shut down on
June 1, and where to find that newsgroup. It does it all in three lines, and
(look carefully) contains no solicitations for paid work, nor even a link to
buy the book.

[BruceM via AccessMonster.com]

Everybody who hasn't run across you yet needs to be wary of you, especially
those who in a moment of madness may consider hiring you. In fact, John has
offered a membership database (and maybe some other databases, but that is
the one I can recall offhand) free of charge to people working on projects
for non-profits. He is always generous with his time and expertise, but
never more so than when somebody posts along the lines of "I have been asked
to create a directory for my church ...".

Post by Steve
That's very nice of you, John, but why don't you make similar offers to many
other OPs you respond to?
Further, you condone the actions of visio john and arno r but they never
make an offer like yours to any OP. In fact their conduct obviously violates
the Rules Of Conduct of the newsgroups and you condone their actions. OPs
need to be very wary of hypocrites in sheep's clothing.
Steve

Post by John W. Vinson

Post by shumate62
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

[quoted text clipped - 30 lines]

Post by John W. Vinson
to
get back to you in the next day or so (free of charge).

[Keith Wilby]

Post by Steve
That's very nice of you, John, but why don't you make similar offers to many
other OPs you respond to?
Further, you condone the actions of visio john and arno r but they never
make an offer like yours to any OP. In fact their conduct obviously violates
the Rules Of Conduct of the newsgroups and you condone their actions. OPs
need to be very wary of hypocrites in sheep's clothing.
Steve

I see you're still a complete and blithering idot $teve.

[Wayne-I-M]

If you post a sample of the type of data you have to work with - DON'T use
real data - then I'm sure that someone will be able to help you out.

It doesn't sound too complex.

Can I suggest that you make astart yourself.
1 Create a table (call it tblPeronnel).
in this table create
An Autonumber field - make this the primary field.
Also add the following
1stname
Surname
1s tline of the address
2nd line of the address
3rd line of the address
4th line of the address
ZipCode or PostCode
Salutation (thats Mrs, Mrs, Miss,Dr, etc,etc)
You can add any other details you want "as long as this information only
applies to the specific person"
All of these fields are text fields - except for the Autonumber field.
Don't add - speaker, guest, etc to this table

Next create another table with details of the meetings you hold
Autnumber - primary
Date of meeting (date . time format)
Location of meeting
Plus other items eg. Max seating, etc

Now the 3rd table I would suggest that you hold off with. Just create the 2
above and then come back to this form ans someone will be able to tell you
how to link them together with a many to many (thats many people can go to
many meetings and many meetings can have many people in them).
In this 3rd table is where you will store the details of speakers, guests,
etc - as they are applicable to a specific mix of people and meeting.

Post back when you have the 1st 2 tables done.



Next
--
Wayne
Manchester, England.

Post by shumate62
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!!!!