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  

F- in Access



 
 
Thread Tools Display Modes
  #11  
Old May 14th, 2010, 01:16 AM posted to microsoft.public.access.gettingstarted
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default F- in Access

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


"John W. Vinson" wrote in message
...
On Thu, 13 May 2010 11:19:01 -0700, 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!!!!


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]



  #12  
Old May 14th, 2010, 10:08 AM posted to microsoft.public.access.gettingstarted
Stop$teve
external usenet poster
 
Posts: 76
Default F- in Access


"Steve" schreef in bericht ...
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


  #13  
Old May 14th, 2010, 11:59 AM posted to microsoft.public.access.gettingstarted
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default F- in Access

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

Steve



"Stop$teve" Stop$teve@Data**** wrote in message
...

"Steve" schreef in bericht
...
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



  #14  
Old May 14th, 2010, 12:44 PM posted to microsoft.public.access.gettingstarted
BruceM via AccessMonster.com
external usenet poster
 
Posts: 448
Default F- in Access

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

Steve wrote:
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'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]
to
get back to you in the next day or so (free of charge).


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/201005/1

  #15  
Old May 14th, 2010, 08:33 PM posted to microsoft.public.access.gettingstarted
Wayne-I-M
external usenet poster
 
Posts: 3,674
Default F- in Access

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.



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

  #16  
Old May 17th, 2010, 02:54 AM posted to microsoft.public.access.gettingstarted
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default F- in Access

"Steve" wrote in message
...
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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


  #17  
Old May 18th, 2010, 04:36 PM posted to microsoft.public.access.gettingstarted
Keith Wilby[_2_]
external usenet poster
 
Posts: 5
Default F- in Access

On 14 May, 01:16, "Steve" wrote:
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.
  #18  
Old May 20th, 2010, 08:40 PM posted to microsoft.public.access.gettingstarted
Larry Linson
external usenet poster
 
Posts: 3,112
Default F- in Access

"Steve" wrote

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.

--
Larry Linson, Microsoft Office Access MVP
Co-author: "Microsoft Access Small Business Solutions", published by Wiley
Access newsgroup support is alive and well in USENET
comp.databases.ms-access


 




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 12:06 PM.


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