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
|
|||
|
|||
Multidimensional Forms/Tables
Please see the attachment. How can I create a form like this to store
information. Here is what I have done. Created table BUSINESS , which has all the business names. Created table CATEGORY , that has the Business name and Category Name. Created table SUB CATEGORY , that has the Category Name and Sub Category Name. Created table APPLICATION , Which has all the Application Names Created table COMPONET, Which has the Application Name and Component Name. I have linked all the tables and have primary keys. Create a query which would pull out all the Business, Category , Subcategory , Application and Component infomation. PROBLEM: If you look at the attachment I need to store values X. How doI store this information and it which Table. Also how can I design a form like the Excel sheet that helps me to store Information in a user friendly way. Thanks, Sharan. |
#2
|
|||
|
|||
Contact me at my email address below if you would like outside help with
this. My fees are very reasonable. -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com "sharan" wrote in message ... Please see the attachment. How can I create a form like this to store information. Here is what I have done. Created table BUSINESS , which has all the business names. Created table CATEGORY , that has the Business name and Category Name. Created table SUB CATEGORY , that has the Category Name and Sub Category Name. Created table APPLICATION , Which has all the Application Names Created table COMPONET, Which has the Application Name and Component Name. I have linked all the tables and have primary keys. Create a query which would pull out all the Business, Category , Subcategory , Application and Component infomation. PROBLEM: If you look at the attachment I need to store values X. How doI store this information and it which Table. Also how can I design a form like the Excel sheet that helps me to store Information in a user friendly way. Thanks, Sharan. |
#3
|
|||
|
|||
You just don't get it, do you Steve?
-- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "PC Datasheet" wrote in message link.net... Contact me at my email address below if you would like outside help with this. My fees are very reasonable. -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com |
#4
|
|||
|
|||
Why don't you explain it to me in concrete terms, Doug.
"Douglas J. Steele" wrote in message ... You just don't get it, do you Steve? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "PC Datasheet" wrote in message link.net... Contact me at my email address below if you would like outside help with this. My fees are very reasonable. -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com |
#5
|
|||
|
|||
These newsgroups are not intended for you to solicit commercial business.
You know that: you've been told MANY times by MANY different people, yet you still persist. Are you really that egocentric that you figure you can ignore everyone? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "PC Datasheet" wrote in message ink.net... Why don't you explain it to me in concrete terms, Doug. "Douglas J. Steele" wrote in message ... You just don't get it, do you Steve? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "PC Datasheet" wrote in message link.net... Contact me at my email address below if you would like outside help with this. My fees are very reasonable. -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com |
#6
|
|||
|
|||
Doug,
I have always respected your approach and continue to feel that way. My intent here is not meant to put you down in any way. I just am asking you on a professional level where specifically does it say that offers of help on an Access related problem for a fee are prohibited? Steve "Douglas J. Steele" wrote in message ... These newsgroups are not intended for you to solicit commercial business. You know that: you've been told MANY times by MANY different people, yet you still persist. Are you really that egocentric that you figure you can ignore everyone? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "PC Datasheet" wrote in message ink.net... Why don't you explain it to me in concrete terms, Doug. "Douglas J. Steele" wrote in message ... You just don't get it, do you Steve? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "PC Datasheet" wrote in message link.net... Contact me at my email address below if you would like outside help with this. My fees are very reasonable. -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com |
#7
|
|||
|
|||
I will grant you that the words in Rules of Conduct for this group, as
posted at http://msdn.microsoft.com/library/ga...RulesofConduct can be interpretted, should you choose to, as letting you advertise: "We ask that you refrain from posting advertisements or solicitations that do not pertain directly to the intended use and purpose of the newsgroup or chat." However, as you're well aware, the vast majority of people here interpret "the intended use ... of the newsgroup" to mean that this is a free help service. I'm sorry that your business is so poor that you feel it necessary to emulate ambulance-chasing lawyers, using tactics that draw the scorn and comtempt of your peers. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "PC Datasheet" wrote in message link.net... Doug, I have always respected your approach and continue to feel that way. My intent here is not meant to put you down in any way. I just am asking you on a professional level where specifically does it say that offers of help on an Access related problem for a fee are prohibited? Steve "Douglas J. Steele" wrote in message ... These newsgroups are not intended for you to solicit commercial business. You know that: you've been told MANY times by MANY different people, yet you still persist. Are you really that egocentric that you figure you can ignore everyone? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "PC Datasheet" wrote in message ink.net... Why don't you explain it to me in concrete terms, Doug. "Douglas J. Steele" wrote in message ... You just don't get it, do you Steve? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "PC Datasheet" wrote in message link.net... Contact me at my email address below if you would like outside help with this. My fees are very reasonable. -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com |
#8
|
|||
|
|||
I did a quick search of google:
"NewsGroup" etiquette advertise First Hit ========================= http://www.netscape.co.uk/help/faqs/...oupmanners.htm Don't Spam Spamming is e-mailing or posting unsolicited advertising. Never post advertising on a Newsgroup unless it is specifically created to accept adverts. Second Hit ========================= http://groups.google.com/googlegroup...ing_style.html Please do not use Usenet as an advertising medium. Advertisements on Usenet are rarely appreciated. In general, the louder or more inappropriate the ad is, the more antagonism it stirs up. Just think how annoying it is to you to have your evening meal interrupted by a telemarketer. The feeling is the same when someone posts inappropriate commercial messages in a newsgroup. If in doubt, don't do it. Third Hit ========================== http://www.gotfusion.com/tutsTD/groupetiquette.cfm DO NOT Advertise: It doesn't work, it gets people really really mad, it gets me really really mad, and no matter what you say it will not be taken well. Everyone HATES SPAM. This is one of the things that will guarantee that I bring out my "big hammer" and remove your thread. Do not answer posts of this nature as it just adds to the number of posts I have to remove. If you continue to advertise after being warned you may find yourself blacklisted from posting anything on these newsgroups. Fourth Hit ========================== http://www.mommyshelperonline.com/email-etiquette.html 6.) Use 4-6 lines for your signature line, this is an opportunity to highlight your business or company information, but don't be ostentatious.. -- Duane Hookom MS Access MVP "PC Datasheet" wrote in message link.net... Doug, I have always respected your approach and continue to feel that way. My intent here is not meant to put you down in any way. I just am asking you on a professional level where specifically does it say that offers of help on an Access related problem for a fee are prohibited? Steve "Douglas J. Steele" wrote in message ... These newsgroups are not intended for you to solicit commercial business. You know that: you've been told MANY times by MANY different people, yet you still persist. Are you really that egocentric that you figure you can ignore everyone? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "PC Datasheet" wrote in message ink.net... Why don't you explain it to me in concrete terms, Doug. "Douglas J. Steele" wrote in message ... You just don't get it, do you Steve? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "PC Datasheet" wrote in message link.net... Contact me at my email address below if you would like outside help with this. My fees are very reasonable. -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com |
#9
|
|||
|
|||
Duane,
I will preface what I have to say with, I have been reading the newsgroups for many years and all that time you have stood out as a prominent figure. I can say as a fact that everything that you have always had to say was said in a very professional way. From that I have developed great respect for you and continue to feel that respect. What I have to say is meant to be in the spirit of that respect and is no way intended to put you down. None of what you quoted here comes from the Rulse Of Conduct and therefore does not apply. The Rules Of Conduct are found at http://msdn.microsoft.com/library/ga...RulesofConduct and the pertinent part states: "We ask that you refrain from posting advertisements or solicitations that do not pertain directly to the intended use and purpose of the newsgroup or chat." Nonetheless, here is my response --- As far as advertising, please explain in concrete terms how "Contact me at my email address below if you would like outside help with this. My fees are very reasonable" is advertising. My sig is advertising but again it pertains to the purpose of the newsgroups to provide Access users a resource for help with Access related problems. Duane Hookom, MS Access is the same type of advertising. So is the following: o "MVPDoug Steele, Microsoft Access MVP" o "See http://www.QBuilt.com for all your database needs." o "John Viescas, author "Building Microsoft Access Applications" (Coming Soon!) "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" o David Lloyd MCSD .NET http://LemingtonConsulting.com The above are a very small example of what you see daily on the newsgroups. In terms of Contact me if you would like help, I am not the only one to post this type of post. Every once in a while you will see offers from others besides myself. Consider the following: genenky - You can contact me via www.cadellsoftware.org and we can discuss what you're seeking to do.- Ken Snell MS ACCESS MVP No one posts derogatory responses to these others. Is it because Ken is an MVP? In terms of advertising, consider the following in the sig line of an infrequent responder: "A Christian Response http://www.pastornet.net.au/response" Check out the web address. It has absolutely nothing to do with Access. You see other adverts like this and adverts that are directly in the body of the post. None of the above are ever taken to task for advertising that obviously does not pertain to providing Access users a resource for help with Access problems. In conclusion, I want to ask that you drop out of the crowd of the likes of Arno R, Keith Wilby, Randy Harris and others and defend me from their malicious attacks. If you are not willing to do this then I ask that you keep silent rather than trying to support them. Thanks, Duane, Steve "Duane Hookom" wrote in message ... I did a quick search of google: "NewsGroup" etiquette advertise First Hit ========================= http://www.netscape.co.uk/help/faqs/...oupmanners.htm Don't Spam Spamming is e-mailing or posting unsolicited advertising. Never post advertising on a Newsgroup unless it is specifically created to accept adverts. Second Hit ========================= http://groups.google.com/googlegroup...ing_style.html Please do not use Usenet as an advertising medium. Advertisements on Usenet are rarely appreciated. In general, the louder or more inappropriate the ad is, the more antagonism it stirs up. Just think how annoying it is to you to have your evening meal interrupted by a telemarketer. The feeling is the same when someone posts inappropriate commercial messages in a newsgroup. If in doubt, don't do it. Third Hit ========================== http://www.gotfusion.com/tutsTD/groupetiquette.cfm DO NOT Advertise: It doesn't work, it gets people really really mad, it gets me really really mad, and no matter what you say it will not be taken well. Everyone HATES SPAM. This is one of the things that will guarantee that I bring out my "big hammer" and remove your thread. Do not answer posts of this nature as it just adds to the number of posts I have to remove. If you continue to advertise after being warned you may find yourself blacklisted from posting anything on these newsgroups. Fourth Hit ========================== http://www.mommyshelperonline.com/email-etiquette.html 6.) Use 4-6 lines for your signature line, this is an opportunity to highlight your business or company information, but don't be ostentatious.. -- Duane Hookom MS Access MVP "PC Datasheet" wrote in message link.net... Doug, I have always respected your approach and continue to feel that way. My intent here is not meant to put you down in any way. I just am asking you on a professional level where specifically does it say that offers of help on an Access related problem for a fee are prohibited? Steve "Douglas J. Steele" wrote in message ... These newsgroups are not intended for you to solicit commercial business. You know that: you've been told MANY times by MANY different people, yet you still persist. Are you really that egocentric that you figure you can ignore everyone? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "PC Datasheet" wrote in message ink.net... Why don't you explain it to me in concrete terms, Doug. "Douglas J. Steele" wrote in message ... You just don't get it, do you Steve? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "PC Datasheet" wrote in message link.net... Contact me at my email address below if you would like outside help with this. My fees are very reasonable. -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com |
#10
|
|||
|
|||
the vast majority of people here interpret "the intended use ... of the
newsgroup" to mean that this is a free help service. Your statement is not based in fact. There are a vast number of posters and responders to the newsgroups. The vast majority of these posters and responders have never expressed an opinion one way or another. The fact of the matter is that there are only a handful of people that have made condescending responses to my posts offering help for a fee (Arno R, Keith Wilby, Randy Harris, rkc to name a few.) The fact of the matter is that there are ten times this number that accept fee-based offers of help. On numerous occasions I have been paid a fee for my help from a poster I made an offer to. From most other posters I have made an offer to, I receive a genuine thank you with an explanation of why they are unable to pay a fee (boss says No, limited budget, personnal application to name a few.) It is rare that I get a response back mentioning any expectation of "free help". Do you agree that the purpose of the newsgroup is to provide Access users a resource for getting help with Access problems? Look at my Sig: "Your Resource For Help With Access, Excel and Word Applications" My mission is to provide customers a resource for help with Access, Excel and Word applications. And I am very successful at this. I charge customers a very reasonable fee and I do the best I can to ensure customers are well satisfied. A good portion of my business is from the newsgroups helping customers with typical problems you read in the newsgroups daily. I am not a major consulting firm ripping customers off for a $100 or more an hour. My typical projects are $500 to $1500 and I am busy 85-90% of the time. I do not do mission-critical projects. You accurately quote the Rules Of Conduct, "We ask that you refrain from posting advertisements or solicitations that do not pertain directly to the intended use and purpose of the newsgroup or chat." My offers of fee-based help are always Access related and pertain to the purpose of the newsgroup to provide Access users a resource for getting help with Access problems. On at least a ten-to-one ratio I also provide free support on the newsgroups. I judiciously only offer fee-based help to posters who seem to need extra help beyond a newsgroup. Some time ago an MVP responded to one of my posts, "True, but that (that I provide a lot of free support in the Access newsgroups) is not the issue you are being taken to task on. It is your offering to help without disclosing the cost. When you post any of your "call me" messages, you need to indicate that unlike other offers of help, your help comes at a price." I have taken that suggestion and sincerely make an effort to always indicate that I am offering fee-based help. For example, my post in this thread reads, "Contact me at my email address below if you would like outside help with this. My fees are very reasonable." As far as advertising, please explain in concrete terms how "Contact me at my email address below if you would like outside help with this. My fees are very reasonable" is advertising. My sig is advertising but again it pertains to the purpose of the newsgroups to provide Access users a resource for help with Access related problems. Doug Steele, Microsoft Access MVP is the same type of advertising. So is the following: o "See http://www.QBuilt.com for all your database needs." o "John Viescas, author "Building Microsoft Access Applications" (Coming Soon!) "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" o David Lloyd MCSD .NET http://LemingtonConsulting.com The above are a very small example of what you see daily on the newsgroups. In terms of Contact me if you would like help, I am not the only one to post this type of post. Every once in a while you will see offers from others besides myself. Consider the following: genenky - You can contact me via www.cadellsoftware.org and we can discuss what you're seeking to do.- Ken Snell MS ACCESS MVP No one posts derogatory responses to these others. Is it because Ken is an MVP? In terms of advertising, consider the following in the sig line of an infrequent responder: "A Christian Response http://www.pastornet.net.au/response" Check out the web address. It has absolutely nothing to do with Access. You see other adverts like this and adverts that are directly in the body of the post. None of the above are ever taken to task for advertising that obviously does not pertain to providing Access users a resource for help with Access problems. I want to address another Rule Of Conduct that reads: "Appropriate Language: The purpose of our communities is to exchange technical information and expertise about Microsoft products. Please avoid personal attacks, slurs, and profanity in your interactions." I'm sorry that your business is so poor ... You know nothing about my business. Please explain what makes you think that you are qualified to make a statement like this? As stated above, the opposite is true in fact which makes your statement a personal attack, a slur and slanderous. emulate ambulance-chasing lawyers This statement also is nothing but a personal attack and a slur. In making these kind of statements, you are therefore violating the Rules Of Conduct. Please do not consider the above an affront because I sincerely do respect you, Doug. The above is to just make a point. In conclusion, I want to ask that you drop out of the crowd of the likes of Arno R, Keith Wilby, Randy Harris and others and defend me from their malicious attacks. If you are not willing to do this then I ask that you keep silent rather than makeing statements like are in this post. Thanks, Doug, Steve "Douglas J. Steele" wrote in message ... I will grant you that the words in Rules of Conduct for this group, as posted at http://msdn.microsoft.com/library/ga...RulesofConduct can be interpretted, should you choose to, as letting you advertise: "We ask that you refrain from posting advertisements or solicitations that do not pertain directly to the intended use and purpose of the newsgroup or chat." However, as you're well aware, the vast majority of people here interpret "the intended use ... of the newsgroup" to mean that this is a free help service. I'm sorry that your business is so poor that you feel it necessary to emulate ambulance-chasing lawyers, using tactics that draw the scorn and comtempt of your peers. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "PC Datasheet" wrote in message link.net... Doug, I have always respected your approach and continue to feel that way. My intent here is not meant to put you down in any way. I just am asking you on a professional level where specifically does it say that offers of help on an Access related problem for a fee are prohibited? Steve "Douglas J. Steele" wrote in message ... These newsgroups are not intended for you to solicit commercial business. You know that: you've been told MANY times by MANY different people, yet you still persist. Are you really that egocentric that you figure you can ignore everyone? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "PC Datasheet" wrote in message ink.net... Why don't you explain it to me in concrete terms, Doug. "Douglas J. Steele" wrote in message ... You just don't get it, do you Steve? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "PC Datasheet" wrote in message link.net... Contact me at my email address below if you would like outside help with this. My fees are very reasonable. -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Multidimensional Table/Form Question | sharan | Database Design | 1 | October 8th, 2005 12:55 PM |
Duplicating Forms/Tables | Charlie | New Users | 2 | May 17th, 2005 08:20 PM |
Making products - laying out forms/tables | babs | Using Forms | 6 | December 7th, 2004 09:59 PM |