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

Multidimensional Forms/Tables



 
 
Thread Tools Display Modes
  #1  
Old October 7th, 2005, 06:21 PM
sharan
external usenet poster
 
Posts: n/a
Default 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  
Old October 7th, 2005, 07:42 PM
PC Datasheet
external usenet poster
 
Posts: n/a
Default

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  
Old October 7th, 2005, 09:31 PM
Douglas J. Steele
external usenet poster
 
Posts: n/a
Default

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  
Old October 8th, 2005, 12:38 AM
PC Datasheet
external usenet poster
 
Posts: n/a
Default

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  
Old October 8th, 2005, 01:41 PM
Douglas J. Steele
external usenet poster
 
Posts: n/a
Default

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  
Old October 8th, 2005, 10:57 PM
PC Datasheet
external usenet poster
 
Posts: n/a
Default

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  
Old October 8th, 2005, 11:15 PM
Douglas J. Steele
external usenet poster
 
Posts: n/a
Default

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  
Old October 8th, 2005, 11:31 PM
Duane Hookom
external usenet poster
 
Posts: n/a
Default

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  
Old October 10th, 2005, 04:29 AM
PC Datasheet
external usenet poster
 
Posts: n/a
Default

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  
Old October 10th, 2005, 04:29 AM
PC Datasheet
external usenet poster
 
Posts: n/a
Default

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

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

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 10:59 PM


All times are GMT +1. The time now is 11:31 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.