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
  #51  
Old July 31st, 2008, 08:47 PM posted to microsoft.public.access
Aaron Kempf knows nothing[_2_]
external usenet poster
 
Posts: 126
Default MS Access Newsgroups lack real synergistic help



"a a r o n _ k e m p f" wrote:

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

there is no 'out'

they could not convict.
case closed



On Jul 28, 4:31 pm, So Sorry For Poor Aaron
wrote:
"a a r o n _ k e m p f" wrote:

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.



  #52  
Old July 31st, 2008, 08:47 PM posted to microsoft.public.access
Aaron Kempf knows nothing[_2_]
external usenet poster
 
Posts: 126
Default MS Access Newsgroups lack real synergistic help



"a a r o n _ k e m p f" wrote:

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

-Aaron



On Jul 29, 11:09 pm, So Sorry For Poor Aaron
wrote:
"a a r o n _ k e m p f" wrote:

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.



  #53  
Old July 31st, 2008, 08:47 PM posted to microsoft.public.access
Aaron Kempf knows nothing[_2_]
external usenet poster
 
Posts: 126
Default MS Access Newsgroups lack real synergistic help



"a a r o n _ k e m p f" wrote:

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


On Jul 28, 6:17 am, "Bob Larson" wrote:
Go E S A D Miss Aaron.

"a a r o n _ k e m p f" wrote in ...
you just choose to listen to the snake oil salesman.
Is that my fault?

I choose a real database engine-- paired with Access forms and
reports-- for the same cost as JET

ADP forever, baby.

On Jul 27, 6:22 pm, wrote:

At the end of the day have you made any positive progress in this Forum? I
think not.


a a r o n _ k e m p f wrote:


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


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



  #54  
Old July 31st, 2008, 08:47 PM posted to microsoft.public.access
Aaron Kempf knows nothing[_2_]
external usenet poster
 
Posts: 126
Default MS Access Newsgroups lack real synergistic help



"a a r o n _ k e m p f" wrote:

you just choose to listen to the snake oil salesman.
Is that my fault?

I choose a real database engine-- paired with Access forms and
reports-- for the same cost as JET

ADP forever, baby.


On Jul 27, 6:22 pm, wrote:
At the end of the day have you made any positive progress in this Forum? I think not.

a a r o n _ k e m p f wrote:

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


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



  #55  
Old July 31st, 2008, 08:48 PM posted to microsoft.public.access
Aaron Kempf knows nothing[_2_]
external usenet poster
 
Posts: 126
Default MS Access Newsgroups lack real synergistic help



"a a r o n _ k e m p f" wrote:

ADP is a great front end.

It looks just like MS Access-- same forms and reports-- but the query
engine is much faster and superior.

It supports 'code reuse' for starters




On Jul 27, 8:39 pm, "Arvin Meyer [MVP]" wrote:
wrote in message

...

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?


SQL-Server would not have answered the particular problem you asked to
solve. SQL-Server may indeed be required if you have lots of records, but
you will still need a front-end capable of running code. By far, the best
solution for database front-ends is Access, that is assuming that you don't
require a large amount of WAN users.
--
Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com



  #56  
Old August 1st, 2008, 04:20 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

please stop following me, I no longer feel safe with your predatory
behaivor


On Jul 31, 12:48*pm, Aaron Kempf knows nothing
m wrote:
"a a r o n _ k e m p f" wrote:

ADP is a great front end.


It looks just like MS Access-- same forms and reports-- but the query
engine is much faster and superior.


It supports 'code reuse' for starters


On Jul 27, 8:39 pm, "Arvin Meyer [MVP]" wrote:
wrote in message


.. .


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?


SQL-Server would not have answered the particular problem you asked to
solve. SQL-Server may indeed be required if you have lots of records, but
you will still need a front-end capable of running code. By far, the best
solution for database front-ends is Access, that is assuming that you don't
require a large amount of WAN users.
--
Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmv...


  #57  
Old August 1st, 2008, 08:08 PM posted to microsoft.public.access
So Sorry For Poor Aaron[_2_]
external usenet poster
 
Posts: 64
Default MS Access Newsgroups lack real synergistic help

"a a r o n _ k e m p f" wrote:

ADP forever, baby.


ADP for never, pussybaby.

DAP is deprecated -- lost and gone forever like Clementine.

Don't you think ADP is going to be next?

Rub your cloudy crystal ball, peer into the future, and see what you see?

I see an obnoxious, irritating, totally-off-base, disheveled, drooling, and
finally completely irrelevant aaron struggling in his canvas coat with the
buckle-down sleeves, screaming "ADP forever, baby!" And everybody, even his
keepers, ignoring him.
  #58  
Old August 2nd, 2008, 02:13 AM posted to microsoft.public.access
[email protected]
external usenet poster
 
Posts: 308
Default MS Access Newsgroups lack real synergistic help

Thanks for your time and thoughts.

My main point is/was that the questions asked could have been answered with a "provisionary"
solution to the immediate issue. For sure, a cautionary comment from an expert is very welcome.

I was not proud later of my unnecessary use of "pontificating ........."


"Larry Linson" wrote:

wrote

Interesting! My point still stands.

Not one MVP answered my questions.

All just pontificated and rationalized there indefensible positions.


First, you should be aware that not everyone who responds here is an MVP.
aaron kempf, for example, is not an MVP, nor does he often provide useful,
or even serious, responses to questions about Access. He appears to be, for
some reason, mentally pre-programmed to respond to all Access questions with
"move to SQL Server" whether or not that is an appropriate or useful answer.

Is it "pontificating" to explain that sometimes there is no "easy, simple
answer" that someone can just type in from memory? (See my comments below
regarding File IO.)

Is there some reason why John Vinson's approach does not work for you? Link
the external text file, open it as a Recordset, and try his code. Looks to
me to be worth a try.

If it doesn't work, post back with some details about the text file (fixed
field or delimited or ???) and someone can likely offer you a FileIO
solution -- as I don't do FileIO very often, any more, and as I don't have a
lot of time and energy to create a new example or to go search out an
example and revise it for your purposes, I might very well give you a link
or a reference to a resource. (Most of the VBA FileIO is not a great deal
different from the File IO from previous versions of BASIC, including the
DOS BASIC interpreters that came bundled with MS DOS and early versions of
Windows.)

I'm sorry you are unhappy with the level of response you are getting here in
microsoft.public.access; you might visit the USENET newsgroup
comp.databases.ms-access. Not nearly as many MVPs post there, anymore, but
there are still a lot of useful answers.

Larry Linson
Microsoft Office Access MVP


  #59  
Old August 3rd, 2008, 12:01 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

DAP is the best thing that MS ever did.. PivotTables-- web-based..
these are not licensed appropriately for users of office 2007.

there is a correction coming, thank you very much






On Aug 1, 12:08*pm, So Sorry For Poor Aaron
wrote:
"a a r o n _ k e m p f" wrote:

* ADP forever, baby.

ADP for never, pussybaby.

DAP is deprecated -- lost and gone forever like Clementine.

Don't you think ADP is going to be next? *

Rub your cloudy crystal ball, peer into the future, and see what you see? *

I see an obnoxious, irritating, totally-off-base, disheveled, drooling, and
finally completely irrelevant aaron struggling in his canvas coat with the
buckle-down sleeves, screaming "ADP forever, baby!" And everybody, even his
keepers, ignoring him.


 




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 07:03 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.