Creating a specific form

[Lynxy]

Is it possible to create a form to enter data so that it ends up like this in
the table:

Ice Sports (tab) hockey
Ice Sports (tab) figure skating
Ice Sports (tab) speed skating
Skiing Sports (tab) cross country skiing
Skiing Sports (tab) downhill skiing
Skiing Sports (tab) ski jumping

but so I only have to type each category once (cause some of them have a
bajillion sports in that category), and then type all the sports In that
category? So the form looks something like this:

Ice Sports
hockey
figure skating
speed skating

and I end up typing the word "Ice Sports" only once, instead of 3 times (or
in some cases, 20 or 30 times)

Thanks!

 

[Steve]

It starts by having the proper tables! You need:
TblCategory
CategoryID
Category (Ice Sports, Skiing Sports, etc)

TblSport
SportID
CategoryID
Sport

TblSport would look like:
1 1 Hockey
2 1 Figure Skating
3 1 Speed Skating
4 2 Cross Country Sking
5 2 Downhill Skiing
6 2 Ski Jumping

To enter this data, you need a form/subform. Base the main form on
TblCategory
and base the subform on TblSport. Set the Linkmaster and Linkchild
properties of the subform control on the main form to CategoryID. All you
need on the subform is a textbox for entering Sport. CategoryID will
automatically be entered for each record. The form/subform will allow you to
enter a Category in the main form and build a list of Sports in that
category in the subform.

If you need help with this, I can help you. I provide help with Access,
Excel and Word applications for a small fee. My fee to set this up for you
would be minimal. Contact me if you want my help.

Steve
(e-mail address removed)

 

[Gina Whipp]

Lynxy,

I would start with a form/Subform scenario. So you would select *Ice
Sports* on the main form (once) and on the subform select Hockey, Figure
Skating, etc... However, without knowing your table set up not sure this is
possible or if this the way you want it. You can post your table structure
we can better assist you for FREE. Also, note, you would not your layout in
a table but in a query which would join the two tables... if that is how you
set it up, which is why we need the table structure.

Please note, everyone, with the exception of Steve, is here *volunteering*
to help you for FREE, no monies required.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Is it possible to create a form to enter data so that it ends up like this
in
the table:

Ice Sports (tab) hockey
Ice Sports (tab) figure skating
Ice Sports (tab) speed skating
Skiing Sports (tab) cross country skiing
Skiing Sports (tab) downhill skiing
Skiing Sports (tab) ski jumping

but so I only have to type each category once (cause some of them have a
bajillion sports in that category), and then type all the sports In that
category? So the form looks something like this:

Ice Sports
hockey
figure skating
speed skating

and I end up typing the word "Ice Sports" only once, instead of 3 times (or
in some cases, 20 or 30 times)

Thanks!

 

[Jeff Boyce]

Before you do business with someone who solicits for-a-fee business in these
newsgroups, be aware that the Code of Conduct prohibits solicitation. Do
you want to do business with someone who knowingly disregards the rules?

Most folks here are volunteering their time, and these newsgroups are
provided to offer FREE assistance.

From your description, it sounds like you are trying to make Access behave
like a spreadsheet. Access is not a spreadsheet!

If the terms "relational database" and "normalization" aren't familiar, plan
to spend some time coming up to speed on them. If you want to get the best
use of Access' relationally-oriented features/functions, you can't feed it
'sheet data.

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Lynxy]

I have my two tables

For the category field in table1, the Display control is Combo Box, the Row
Source Type Table/Query, the Row Source SELECT Table2.Category FROM Table2;

now, what I want to do, is create a form for entering Data into table1,
where I can choose the category, and then enter all the sports in that
category (if that makes sense). It would be a whole lot less typing.

 

[John... Visio MVP]

If you need help with this, I can help you. I provide help with Access,
Excel and Word applications for a small fee. My fee to set this up for you
would be minimal. Contact me if you want my help.

Steve

Stevie is our own personal pet troll who is the only one who does not
understand the concept of FREE peer to peer support!
He offers questionable results at unreasonable prices.

These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified individuals who gladly help for free. Stevie
is not one of them, but he is the only one who just does not get the idea of
"FREE" support. He offers questionable results at unreasonable prices. If he
was any good, the "thousands" of people he claims to have helped would be
flooding him with work, but there appears to be a continuous drought and he
needs to constantly grovel for work.

Please do not feed the trolls.

John... Visio MVP

 

[Lynxy]

I'm not going to do business with him - no way when everyone else is giving
help for free.

And ya, I guess I am trying to make it behave like a spreadsheet a little -
I'm very new to access, and a lot more familiar with Excel, but for the
project I'm doing Access will be much better. I understand "relational
database" but I'll look up normalization. Thanks

 

[Gina Whipp]

Lynxy,

Well, we have an small issue here... okay maybe a big one... You are using
Reserved Words for field names. This will eventaully cause a problem for
Access which will cause a big headache for you. So first thing is you want
to fix your field names. For the complete list see...

http://allenbrowne.com/AppIssueBadWord.html

Now, on to your question...

You will have to sue a form/subform scenario to enter it the way you want.
And then use a query to get it to display the way you want.

Main form - Select the Category
Subform - Select all the related Sports

Go to a new Category and repeat the above...

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I have my two tables

For the category field in table1, the Display control is Combo Box, the Row
Source Type Table/Query, the Row Source SELECT Table2.Category FROM Table2;

now, what I want to do, is create a form for entering Data into table1,
where I can choose the category, and then enter all the sports in that
category (if that makes sense). It would be a whole lot less typing.

 

[Gina Whipp]

Lynxy,

So you don't have to look too far...

Jeff Conrad's resources page...
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page...
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP)...
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials...
http://allenbrowne.com/links.html#Tutorials

Sample data models...
http://www.databasedev.co.uk/table-of-contents.html

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I'm not going to do business with him - no way when everyone else is giving
help for free.

And ya, I guess I am trying to make it behave like a spreadsheet a little -
I'm very new to access, and a lot more familiar with Excel, but for the
project I'm doing Access will be much better. I understand "relational
database" but I'll look up normalization. Thanks