MS Access Newsgroups lack real synergistic help

[bcap]

See comments inline:

Folks,

What I learned today in this forum is that I spent good money for Access
when I should have
purchased SQL server. This is an Access NG correct?

The only person who has told you that is Aaron, who is an idiot and should
be ignored. No-one here controls this NG, so none of us can do anything
about the odd numbskull like Aaron who decides to be a pain in the ass.
It's ludicrous for you to blame everyone for the behaviour of one dolt.

Incidentally, FWIW, SQL Server Express Edition is an excellent product, is
100% free, and works extremely well in conjunction with Access. Not that
I'm recommending it to you, merely correcting your misconception that SQL
Server has to be paid for.

I am obviously not a significant Access user. That said, what I am now
working on is an idea which
will cause a significant improvement in information and decrease time in
account reconciliation's.

I do not have the time right now to become an Access guru. My questions
were very simple and
answers were needed before tomorrow I had hoped.

As has been explained to you umpteen times, what you ask is *NOT* simple, in
large part because your questions are unclear or otherwise misconceived.
That in itself is not a crime, and people here often put a great deal of
effort into helping questioners to clarify their questions, so that an
appropriate answer can be given. But they are unlikely to do that for
someone who responds with an attitude like yours, not to mention the
arrogance to demand *free* answers before tomorrow.

The mission of this forum s/b to encourage Access use and proliferation.

I do not have PC-level access in my organization to SQL Server. More, I
am sure that the 10,000+
Access users in my organization would not be happy campers if they knew
that MS was badmouthing
there own product on their own forum - not real encouraging.

No-one here works for or in any way represents MS, not even the MVP's. And
the only person here who is bad-mouthing Access is Aaron. See above.

 

[Fred]

The content section of the original post looks blank to me. But I think
that original title sent this off on a tangent by including an implied
premise that getting / supplying help is supposed to be synergistic. The
process of asking for or getting help is not fundamentally "synergistic" nor
does it need to be.

 

[bcap]

Geez, and you describe people here as sensitive! Would you ever listen to
yourself? Such a hissy fit just because you were unlucky enough to have ONE
question non-answered by the resident piece of scum. It's a public forum
fer chrissakes, no-one can stop idiots from posting here, and if you can't
cope with the occasional asswipe then you'd best avoid public forums
altogether.


"EagleOne@microsoftdiscussiongroups"

 

[BruceM]

"EagleOne@microsoftdiscussiongroups"

If all Gods have returned from Access heaven and have cooled off, let us
try
this another time.

The questions were/are simple. Real simple. All that was asked was a VBA
code line to remove from report headers from a text import. Simple
stuff?

Next was can anyone share a macro that contains the VBA to name headings
and
set data types which I could modify for my use.

The import wizard allows you to specify that the first row contains field
names. In subsequent steps you can rename these fields and change their
data type. If this does not address the situation you will need to present
some simplified sample data. You can see your data. We cannot. The
meaning of "a VBA code line to remove from report headers from a text
import," is unclear. Even if you mean "a VBA code line to remove report
headers from a text import," you need data before you can create a report,
so even allowing for a typo the question is still unclear. If you mean you
want to exclude the header row from the imported data, the import wizard can
take care of this as explained. If you insist on using a single line of VBA
code to accomplish this you are out of luck.

Any response that initially came back was overbroad, assumed the worst,
assumed that some Access wacko was intentially screwing with the Access
Gods.

If you want a detailed response, try a detailed question. While you're at
it, try laying off the attitude.

In reality, I am just user who asked simple question(s). But the Access
Gods are so used to intimidating (browbeating, holyer-than-thouing) the
user
with imagined abuses never substatuated or in play. All but one walked
right
passed and never came back to the mission of this Forum.

This forum has provided endless valuable information to a wide range of
users. One difference is that when users are asked for clarification they
often provide it. If you were to ask in another context about how to hang a
shelf on a wall you would reasonably be asked about the shelf's purpose and
the wall material. If you were to insist on a simple response to a simple
question you may get one, but you may not want to place anything valuable on
the shelf.

Never have I seen a "professional group" so threat sensitive. There were
those in the group who stated that SQL Server was the only answer -
essentially Access is junk. The software I have is Access and I therefore
I
must use it.

There was one person who advocated SQL server. As has been explained, he is
a known troll with one answer to every question. There is evidence here
that you are not bothering to read the responses.

This would have gone much smother if Access Guru's were willing to share
their knowledge. Just look at the number of Excel postings which contain
actual VBA code or real formulas that work! How amazing. Compare that to
Access NG! What one can see is more questions than answers. What results
in
User's minds is "Access is to difficult to understand, I'll just limp with
Excel limits". Which of course smacks at self-serving their consulting
businesses.

You are way out of line suggesting people respond only in service of their
consulting businesses. This is a nothing less that a paranoid delusion on
your part. Spend some time looking yourself at the many VBA postings
containing code and links to code examples. Access is more difficult to
understand than is Excel. Excel is more difficult to understand than is a
calculator. Each one has its purpose. There is some overlap, but they are
not interchangeable.

In Access, a question is asked and the third-degree interigrators jump in
you face with more questions than answers. To be sure, some of that is
needed. But in reality it is much more like "I paid my dues; I could not
get
help; I did it on my own; I am going to make you (the user) bleed first
then
I might consider giving you something that you could to solve an issue at
hand and make Access-use a blessing.

It has been explained why people provide links to existing code examples and
to sample databases rather than copying and pasting the code. What exactly
to you find inadequate about that approach?

 

[BruceM]

You are in error, as is usual.

bullshit; Jet is not reliable enough for more than a single user and a
single record

 

[Klatuu]

In Brendon's case, I believe a synergy is there.
His Mom may not have ever thought of nor considered a blue and green cake,
but she knows a good bit about cakes in general.

Brendon may be able to produce a cake from a cake mix box, but have no clue
as to what is in the box, but does think about "how could I make a blue and
green cake?" So knowing Mom knows a good bit about cakes, she seems to be
the one to ask.

So Mom, being motivated by Brendon's idea, produces a blue and green cake.
Therein lies the synergy.

 

[Wayne-I-M]

So ... to follow on from that. If you are alone in a kitchen does muching a
cake make no sound.

I will think on it some more

 

[Klatuu]

No, but munching on carrots would.
But then there is carrot cake.
So then one wonders which came first, the cake or the frosting?

 

[So Sorry For Poor Aaron]

Try to be civil on this newsgroup.

You learned how to be civil when you were inside, didn't you, before Papa's
money bought you out... "Yes, Sir, Big Bruce." "Yes, Sir, Big Bubba."
"Whatever you say, Big Barney." "Of course, Sir, anything you want, Sir, let
me take care of that for you, Sir."

Some pansy might call the cops on you

Hey, sweetie, if they hadn't hauled you in and bunked you up with Big Bruce,
you might never have developed your romantic relationship with Big Bruce, Big
Bubba, and Big Barney, nor discovered how truly sexy orange jumpsuits can be.


And, you accuse somebody else of being a "pansy"? Bwaaaahahahahaha.

Poor, poor, pitiful aaron -- this is the only place he can get by with
acting big and tough.

A little advice, honey, don't try it with Big Bruce, Big Bubba, and Big
Barney. Just pucker up and do whatever they tell you to.

 

[David W. Fenton]

(e-mail address removed) wrote in

This is not rocket science.

Indeed it's not, and your questions are so confused that I wouldn't
even know how to begin to answer them. The first thing I'd do would
be to ask you a bunch of questions to clarify what it is you want to
do (and as posed so far, it seems to me that you want to do things
that you shouldn't want to do in the first place).

To get a good answer, you need to ask a good question.

So far as I can see, you have not.

 

[David W. Fenton]

=?Utf-8?B?RWFnbGVPbmVAbWljcm9zb2Z0ZGlzY3Vzc2lvbmdyb3Vwcw==?=

The questions were/are simple.

To you they may be, but the way they've been posed makes them sound
like completely different questions each time you ask them.

To me, the problem is in the way you're asking your questions, and
that's why you're not getting good answers.

 

[David W. Fenton]

=?Utf-8?B?RWFnbGVPbmVAbWljcm9zb2Z0ZGlzY3Vzc2lvbmdyb3Vwcw==?=

This news group should be more about empowerment than about hazing
and self-service that it is in reality.

It is what it is. You get what you contribute. You seem to be
contributing nothing but negativity simply because you aren't
getting the answers you think you deserve.

Well, here's my answer to your questions:

<PLONK>

 

[ç¿°]

I think you need to take a bit of context into account when comparing the
Excel Newsgroups and Access Newsgroups. Excel is not concerned with
normalization and correct keys, etc. These are way more complex issues
that tend to permeate everything that gets posted around Access. So, many
times the explanation of these related items can take forever to write
each time so posting links to information is the only way to reasonably
help someone with those things. If they do have an immediate need, and
that need would be complicated by normalization issues, we don't
necessarily give them the quick, direct response because we are attempting
to TEACH (albeit using other resources than our own writing) as compared
to giving them a band-aid solution.

In fact, reusability is the reason why I created my website with "quick
tutorials" (tutorials basically from screenshots) so that I can
communicate with users around commonly asked questions without having to
write the answer over and over and over again.

Now, I know that there are those who just supply answers and never explain
them. I am guilty of that at times as well. That can also come from the
fact that we are volunteers who are trying to help but also have other
things in life to deal with. We can't always write a book of our own for
each post.

I'm sorry that you feel that we don't seem to fit into your ideal support
model.

--

Thanks,

Bob Larson
Access MVP
Administrator, Access World Forums
Utter Access VIP

Free Access Tutorials and Resources: http://www.btabdevelopment.com

 

[a a r o n _ k e m p f]

I have no proof? YES I DO

Oh, you say you worked at MS but you are just lying like the piece of sh@#
you are.  You have no proof Miss Aaron.

Chris;

I've heard MS Employees bad-mouth Access thousands of times. Check
your facts, kid.
I've worked at Microsoft for what, 6 different contracts?

MS is full of Excel dorks.  They are blinded by Excel.

I've never met anyone at MS that is not a blue-blood excel dork.
Maybe that is why they never had enough Cojones to take the JET
database engine seriously.

Maybe if they took JET seriously-- maybe they wouldn't have killed it
off (a decade ago)

I look back and see you've had lots of good answers to your many questions
in
this group. This morning a troll bit you when you posted another one.
Instead of ignoring the troll, you go on a rant about the inadequacies of
the
volunteers in these groups who help you and hundreds of others every day
at
no cost to you.

Your reward for fueling the troll is that he'll consider you to be his
pal.
(He loves Excel users, especially ones who complain about Access and the
people who answer questions in these groups). Now that he knows how much
he
can irk you, he's going to keep doing it. Over and over.

Not sure which MS employee you're telling your organization is badmouthing
MS
products, but you'd better check your facts first before you get caught
making false claims.

Chris
Microsoft MVP

 

[a a r o n _ k e m p f]

don't know what you're referring to, technically

there is no 'out'

they could not convict.
case closed

 

[So Sorry For Poor Aaron]

don't know what you're referring to, technically

Poor, poor, pitiful little aaron -- weasel words don't change the fact.
Could be he's just delusional, but the probability is high that he's just an
egotistical pathological liar.

there is no 'out'

No "out" for you, sweetie. You are still on probation. Threaten one person
again in a newsgroup, and <SNAP> just like that, you'll be back in the orange
jumpsuit with Big Bruce, Big Bubba, and Big Barney. But, then, maybe those
are "friendships" you'd like to resume and that's why you are pushing the
edge.

they could not convict.

Matter of public record: Aaron Kempf pled GUILTY to cyberstalking (so he
could get probation instead of a jail term). Pleading GUILTY makes poor,
poor, pitiful little aaron just as GUILTY as conviction by a jury or by the
judge. Ask Daddy's lawyer, aaron, if that's not true.

case closed

Oh, no, your case is not closed, not by a long shot, sweetie. I'm sure you
won't be able to control yourself for the whole term of your probation and
will earn some "good time" with Big Bruce, Big Bubba, and Big Barney. Have
fun. The Big Boys really want you back.

Poor, poor pitiful little aaron! Cruisin' for a carousin' and doesn't even
know it.

 

[a a r o n _ k e m p f]

I wouldn't be so sure of your facts, kids

-Aaron

 

[Aaron Kempf knows nothing]

I wouldn't be so sure of your facts, kids

-Aaron

 

[Aaron Kempf knows nothing]

don't know what you're referring to, technically

there is no 'out'

they could not convict.
case closed

 

[Aaron Kempf knows nothing]

whatever, Bob.

Try to be civil on this newsgroup.
Some pansy might call the cops on you (for having the audacity to
_SWEAR_ on a newsgroup? )

-Aaron