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.

 

[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
(e-mail address removed)

 

[golfinray]

Go to microsoft.com They have dozens of Access database templates already
built. Just search for Access Templates

 

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

 

[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.

 

[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

 

[John... Visio MVP]

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

 

[John W. Vinson]

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

 

[Steve]

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

Steve

 

[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 ...".

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
[quoted text clipped - 30 lines]

to
get back to you in the next day or so (free of charge).

 

[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

 

[Arvin Meyer [MVP]]

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.

 

[Keith Wilby]

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.

 

[Larry Linson]

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.