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 » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

MS Access Newsgroups lack real synergistic help



 
 
Thread Tools Display Modes
  #1  
Old July 27th, 2008, 05:29 PM posted to microsoft.public.access
[email protected]
external usenet poster
 
Posts: 308
Default MS Access Newsgroups lack real synergistic help



Over the years I have noted a significant difference between the XL and the Access NG's

MS would be smart to suggest to its Access MVP's to teach both by encouraging additional self
research coupled with real substantive immediate help.

i.e. if I ask:

Would someone supply a textfile import macro that I could edit? Or let me know how to "get to" the
saved import steps on 2007 for use in 2003?

or

I need the VBA code to delete the first three records (headers from a text import).

DoCmd.RunSQL "DELETE ???????

These answers are simple to Access professionals.

Sure links to additional sources are great. But let us be real. If you went to a more knowledgable
person and asked a question that you knew he knew and he pointed to 5 1000 page books how would you
really feel?

Sometimes a simple answer to a simple question works. Access needs new business and for others to
catch the creativity-motivation curve to solve immediate issues.

In short, answer questions with solutions not just additional projects which distinguishes
motivation to use Access.

I realize that I may never get help again in Access NG's because of the hissy-fits which will
follow.

Stimulate! Encourage! Create! Help!

EagleOne
  #2  
Old July 27th, 2008, 05:55 PM posted to microsoft.public.access
Bob Larson
external usenet poster
 
Posts: 89
Default MS Access Newsgroups lack real synergistic help

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


wrote in message
...


Over the years I have noted a significant difference between the XL and
the Access NG's

MS would be smart to suggest to its Access MVP's to teach both by
encouraging additional self
research coupled with real substantive immediate help.

i.e. if I ask:

Would someone supply a textfile import macro that I could edit? Or let me
know how to "get to" the
saved import steps on 2007 for use in 2003?

or

I need the VBA code to delete the first three records (headers from a text
import).

DoCmd.RunSQL "DELETE ???????

These answers are simple to Access professionals.

Sure links to additional sources are great. But let us be real. If you
went to a more knowledgable
person and asked a question that you knew he knew and he pointed to 5 1000
page books how would you
really feel?

Sometimes a simple answer to a simple question works. Access needs new
business and for others to
catch the creativity-motivation curve to solve immediate issues.

In short, answer questions with solutions not just additional projects
which distinguishes
motivation to use Access.

I realize that I may never get help again in Access NG's because of the
hissy-fits which will
follow.

Stimulate! Encourage! Create! Help!

EagleOne


  #3  
Old July 27th, 2008, 05:56 PM posted to microsoft.public.access
bcap[_2_]
external usenet poster
 
Posts: 260
Default MS Access Newsgroups lack real synergistic help

The exit is thataway...

DLTDHYITAOTWO

wrote in message
...


Over the years I have noted a significant difference between the XL and
the Access NG's

MS would be smart to suggest to its Access MVP's to teach both by
encouraging additional self
research coupled with real substantive immediate help.

i.e. if I ask:

Would someone supply a textfile import macro that I could edit? Or let me
know how to "get to" the
saved import steps on 2007 for use in 2003?

or

I need the VBA code to delete the first three records (headers from a text
import).

DoCmd.RunSQL "DELETE ???????

These answers are simple to Access professionals.

Sure links to additional sources are great. But let us be real. If you
went to a more knowledgable
person and asked a question that you knew he knew and he pointed to 5 1000
page books how would you
really feel?

Sometimes a simple answer to a simple question works. Access needs new
business and for others to
catch the creativity-motivation curve to solve immediate issues.

In short, answer questions with solutions not just additional projects
which distinguishes
motivation to use Access.

I realize that I may never get help again in Access NG's because of the
hissy-fits which will
follow.

Stimulate! Encourage! Create! Help!

EagleOne



  #4  
Old July 27th, 2008, 09:38 PM posted to microsoft.public.access
Pete D.[_3_]
external usenet poster
 
Posts: 488
Default MS Access Newsgroups lack real synergistic help

Funny, I have a job so I am here when not busy. I would say that 50% of my
answers come from answers already provided here using a quick search to find
them. Everyone here volunteers to provide help so when at the soup kitchen,
please don't get angry you didn't get lobster. I frequently see items I
could probally answer but know someone could answer better. I bypass those
and check later to see if an answer is provided. If not I'll look in my old
code or mock it up somewhere in an old datafile and provide the answer but I
don't live here.

The folks here provide a service that if paid for would be worth thousands a
day, they try but I'll even bet a few are married and have a honey do list
also. Give it some time, your question hasn't been out here that long and
you probally just made bunches block your address. Anything provide here
can be purchased at the book store or a little college and 40 years
experience. I for one appreaciate it and when flamed learn from it and move
on. Give it some time and I'll bet someone will throw you the two lines of
code to delete lines in a text file. I just decided not to look for it.

"Bob Larson" wrote in message
...
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


wrote in message
...


Over the years I have noted a significant difference between the XL and
the Access NG's

MS would be smart to suggest to its Access MVP's to teach both by
encouraging additional self
research coupled with real substantive immediate help.

i.e. if I ask:

Would someone supply a textfile import macro that I could edit? Or let
me know how to "get to" the
saved import steps on 2007 for use in 2003?

or

I need the VBA code to delete the first three records (headers from a
text import).

DoCmd.RunSQL "DELETE ???????

These answers are simple to Access professionals.

Sure links to additional sources are great. But let us be real. If you
went to a more knowledgable
person and asked a question that you knew he knew and he pointed to 5
1000 page books how would you
really feel?

Sometimes a simple answer to a simple question works. Access needs new
business and for others to
catch the creativity-motivation curve to solve immediate issues.

In short, answer questions with solutions not just additional projects
which distinguishes
motivation to use Access.

I realize that I may never get help again in Access NG's because of the
hissy-fits which will
follow.

Stimulate! Encourage! Create! Help!

EagleOne




  #5  
Old July 28th, 2008, 01:45 AM posted to microsoft.public.access
Arvin Meyer [MVP]
external usenet poster
 
Posts: 4,231
Default MS Access Newsgroups lack real synergistic help

That's odd. I've been on these newsgroups since they started over 12 years
ago, and before that on the CompuServe Forums. This is my 8th year as an
Access MVP. Additionally, I operate the 3 Access websites in my sig. In all
that time, I thought I was providing exactly the kind of help that you seem
to be asking for.

I usually don't answer questions that I see have been answered by another
MVP, nor to I give the man a fish when he wants to learn how to fish. When I
point to a book, it's precisely because I know that the copyrighted code is
in there or because a book was the question. I point to a website when I or
someone else has written the code or an example, or when Microsoft has
written a KB article.

Because Access is a database, and a database is generally not a simple
thing, there is often no simple answer, or the answer may not be what you
want to hear. I usually won't give you code to do something that I know is
wrong.

So specifically, what is it that you are having a problem with?
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


wrote in message
...


Over the years I have noted a significant difference between the XL and
the Access NG's

MS would be smart to suggest to its Access MVP's to teach both by
encouraging additional self
research coupled with real substantive immediate help.

i.e. if I ask:

Would someone supply a textfile import macro that I could edit? Or let me
know how to "get to" the
saved import steps on 2007 for use in 2003?

or

I need the VBA code to delete the first three records (headers from a text
import).

DoCmd.RunSQL "DELETE ???????

These answers are simple to Access professionals.

Sure links to additional sources are great. But let us be real. If you
went to a more knowledgable
person and asked a question that you knew he knew and he pointed to 5 1000
page books how would you
really feel?

Sometimes a simple answer to a simple question works. Access needs new
business and for others to
catch the creativity-motivation curve to solve immediate issues.

In short, answer questions with solutions not just additional projects
which distinguishes
motivation to use Access.

I realize that I may never get help again in Access NG's because of the
hissy-fits which will
follow.

Stimulate! Encourage! Create! Help!

EagleOne



  #6  
Old July 28th, 2008, 01:50 AM posted to microsoft.public.access
Arvin Meyer [MVP]
external usenet poster
 
Posts: 4,231
Default MS Access Newsgroups lack real synergistic help

I see that the original question that you asked was answered incorrectly,
and I also see why you may be upset. Instead of venting your frustration,
please ask again.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Arvin Meyer [MVP]" wrote in message
...
That's odd. I've been on these newsgroups since they started over 12 years
ago, and before that on the CompuServe Forums. This is my 8th year as an
Access MVP. Additionally, I operate the 3 Access websites in my sig. In
all that time, I thought I was providing exactly the kind of help that you
seem to be asking for.

I usually don't answer questions that I see have been answered by another
MVP, nor to I give the man a fish when he wants to learn how to fish. When
I point to a book, it's precisely because I know that the copyrighted code
is in there or because a book was the question. I point to a website when
I or someone else has written the code or an example, or when Microsoft
has written a KB article.

Because Access is a database, and a database is generally not a simple
thing, there is often no simple answer, or the answer may not be what you
want to hear. I usually won't give you code to do something that I know is
wrong.

So specifically, what is it that you are having a problem with?
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


wrote in message
...


Over the years I have noted a significant difference between the XL and
the Access NG's

MS would be smart to suggest to its Access MVP's to teach both by
encouraging additional self
research coupled with real substantive immediate help.

i.e. if I ask:

Would someone supply a textfile import macro that I could edit? Or let
me know how to "get to" the
saved import steps on 2007 for use in 2003?

or

I need the VBA code to delete the first three records (headers from a
text import).

DoCmd.RunSQL "DELETE ???????

These answers are simple to Access professionals.

Sure links to additional sources are great. But let us be real. If you
went to a more knowledgable
person and asked a question that you knew he knew and he pointed to 5
1000 page books how would you
really feel?

Sometimes a simple answer to a simple question works. Access needs new
business and for others to
catch the creativity-motivation curve to solve immediate issues.

In short, answer questions with solutions not just additional projects
which distinguishes
motivation to use Access.

I realize that I may never get help again in Access NG's because of the
hissy-fits which will
follow.

Stimulate! Encourage! Create! Help!

EagleOne





  #7  
Old July 28th, 2008, 01:50 AM posted to microsoft.public.access
[email protected]
external usenet poster
 
Posts: 308
Default MS Access Newsgroups lack real synergistic help

I am not looking for the ideal - just a lot less arrogance and more real solutions. You can hide
all you wish with technical gobbly gook. If a person asks for the VBA command to delete records
why the question why?

For heavens sake why not help by giving the VBA answer? THEN giving the sermonette?

What happens, is users have to bleed first. That is not help! That is arrogance in the way of
progress.

"Bob Larson" wrote:

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.

  #8  
Old July 28th, 2008, 01:58 AM posted to microsoft.public.access
[email protected]
external usenet poster
 
Posts: 308
Default MS Access Newsgroups lack real synergistic help

I have great respect for MVP's in general. They do perform a excellent service of which I have
partaken. I have spent much time thanking them profusely and that can be verified and you know
that.

The Access groups excepted. There are a few Access MVP's that believe more in help than inflating
themselves. There a few which are good and thank God for those few.


"Pete D." wrote:

Funny, I have a job so I am here when not busy. I would say that 50% of my
answers come from answers already provided here using a quick search to find
them. Everyone here volunteers to provide help so when at the soup kitchen,
please don't get angry you didn't get lobster. I frequently see items I
could probally answer but know someone could answer better. I bypass those
and check later to see if an answer is provided. If not I'll look in my old
code or mock it up somewhere in an old datafile and provide the answer but I
don't live here.

The folks here provide a service that if paid for would be worth thousands a
day, they try but I'll even bet a few are married and have a honey do list
also. Give it some time, your question hasn't been out here that long and
you probally just made bunches block your address. Anything provide here
can be purchased at the book store or a little college and 40 years
experience. I for one appreaciate it and when flamed learn from it and move
on. Give it some time and I'll bet someone will throw you the two lines of
code to delete lines in a text file. I just decided not to look for it.

"Bob Larson" wrote in message
...
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


wrote in message
...


Over the years I have noted a significant difference between the XL and
the Access NG's

MS would be smart to suggest to its Access MVP's to teach both by
encouraging additional self
research coupled with real substantive immediate help.

i.e. if I ask:

Would someone supply a textfile import macro that I could edit? Or let
me know how to "get to" the
saved import steps on 2007 for use in 2003?

or

I need the VBA code to delete the first three records (headers from a
text import).

DoCmd.RunSQL "DELETE ???????

These answers are simple to Access professionals.

Sure links to additional sources are great. But let us be real. If you
went to a more knowledgable
person and asked a question that you knew he knew and he pointed to 5
1000 page books how would you
really feel?

Sometimes a simple answer to a simple question works. Access needs new
business and for others to
catch the creativity-motivation curve to solve immediate issues.

In short, answer questions with solutions not just additional projects
which distinguishes
motivation to use Access.

I realize that I may never get help again in Access NG's because of the
hissy-fits which will
follow.

Stimulate! Encourage! Create! Help!

EagleOne



  #9  
Old July 28th, 2008, 02:03 AM posted to microsoft.public.access
[email protected]
external usenet poster
 
Posts: 308
Default MS Access Newsgroups lack real synergistic help

Interesting! My point still stands.

Not one MVP answered my questions.

All just pontificated and rationalized there indefensible positions.


wrote:



Over the years I have noted a significant difference between the XL and the Access NG's

MS would be smart to suggest to its Access MVP's to teach both by encouraging additional self
research coupled with real substantive immediate help.

i.e. if I ask:

Would someone supply a textfile import macro that I could edit? Or let me know how to "get to" the
saved import steps on 2007 for use in 2003?

or

I need the VBA code to delete the first three records (headers from a text import).

DoCmd.RunSQL "DELETE ???????

These answers are simple to Access professionals.

Sure links to additional sources are great. But let us be real. If you went to a more knowledgable
person and asked a question that you knew he knew and he pointed to 5 1000 page books how would you
really feel?

Sometimes a simple answer to a simple question works. Access needs new business and for others to
catch the creativity-motivation curve to solve immediate issues.

In short, answer questions with solutions not just additional projects which distinguishes
motivation to use Access.

I realize that I may never get help again in Access NG's because of the hissy-fits which will
follow.

Stimulate! Encourage! Create! Help!

EagleOne

  #10  
Old July 28th, 2008, 02:09 AM posted to microsoft.public.access
a a r o n _ k e m p f
external usenet poster
 
Posts: 415
Default MS Access Newsgroups lack real synergistic help

if you've been using Access for that long-- you'd be using SQL Server
by now. I guarantee it.
Access is just a speed bump on the path towards SQL Server.

A pothole.
A driveway to the information super highway that is 'SQL Server'.

You're kidding yourself.
It is inconcievable that you have this much experience with Access and
yet you cannot spell SQL Server







On Jul 27, 5:45*pm, "Arvin Meyer [MVP]" wrote:
That's odd. I've been on these newsgroups since they started over 12 years
ago, and before that on the CompuServe Forums. This is my 8th year as an
Access MVP. Additionally, I operate the 3 Access websites in my sig. In all
that time, I thought I was providing exactly the kind of help that you seem
to be asking for.

I usually don't answer questions that I see have been answered by another
MVP, nor to I give the man a fish when he wants to learn how to fish. When I
point to a book, it's precisely because I know that the copyrighted code is
in there or because a book was the question. I point to a website when I or
someone else has written the code or an example, or when Microsoft has
written a KB article.

Because Access is a database, and a database is generally not a simple
thing, there is often no simple answer, or the answer may not be what you
want to hear. I usually won't give you code to do something that I know is
wrong.

So specifically, what is it that you are having a problem with?
--
Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com

wrote in message

...



Over the years I have noted a significant difference between the XL and
the Access NG's


MS would be smart to suggest to its Access MVP's to teach both by
encouraging additional self
research coupled with real substantive immediate help.


i.e. if I ask:


Would someone supply a textfile import macro that I could edit? *Or let me
know how to "get to" the
saved import steps on 2007 for use in 2003?


or


I need the VBA code to delete the first three records (headers from a text
import).


* * * DoCmd.RunSQL "DELETE ???????


These answers are simple to Access professionals.


Sure links to additional sources are great. *But let us be real. *If you
went to a more knowledgable
person and asked a question that you knew he knew and he pointed to 5 1000
page books how would you
really feel?


Sometimes a simple answer to a simple question works. *Access needs new
business and for others to
catch the creativity-motivation curve to solve immediate issues.


In short, answer questions with solutions not just additional projects
which distinguishes
motivation to use Access.


I realize that I may never get help again in Access NG's because of the
hissy-fits which will
follow.


Stimulate! Encourage! Create! Help!


EagleOne


 




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 02:33 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.