![]() |
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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
![]() 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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 |
#10
|
|||
|
|||
![]()
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 | |
|
|