Suggestion?

[CribbsStyle]

I'm new to access and I have a few questions. I'm creating an access
application to keep track of my sports cards. I need to keep track of
several different items....

Own or Want
Sport
Manufacturer
Set
Player Name
Card #
Serial #
Autographed?
Rookie?
Game Used?

I'd like to use checkboxes for the yes/no questions. I see when I do
this, it stores the yes/no as -1 and 0, is their anyway to actually
store it as the word "Yes" or "No".

Also for the Sport, I'd like to use an Option Group, that lists the
sports. I see it stores the value as 1,2,3,etc...Is their a way to
ahve this show as the actual sports rather than numbers?

Any help would be appreciated.

 

[John W. Vinson]

I'm new to access and I have a few questions. I'm creating an access
application to keep track of my sports cards. I need to keep track of
several different items....

Own or Want
Sport
Manufacturer
Set
Player Name
Card #
Serial #
Autographed?
Rookie?
Game Used?

I'd like to use checkboxes for the yes/no questions. I see when I do
this, it stores the yes/no as -1 and 0, is their anyway to actually
store it as the word "Yes" or "No".

Why would you want to?

Tables are NOT for data display or for data editing. They're for data storage.
Store your yes/no fields as -1/0, your Sport as 1,2,3 etc.; use a Form for
displaying and editing the data, and use checkboxes, or textboxes formatted
Yes/No, or Option Groups, or combo boxes, or whatever you prefer. That way the
computer sees an unambiguous, short number, you see a meaningful name, and you
both are satisfied.


John W. Vinson [MVP]

 

[CribbsStyle]

Sounds good to me, one question...

How would I show it in a report?

Example
---------------------------
Sports Option Group
Baseball = 1
Basketball = 2
Football = 3

Now when I do a report I would much rather have it show the actual
sport instead of a number.

Any Help?

 

[John W. Vinson]

Sounds good to me, one question...

How would I show it in a report?

Example
---------------------------
Sports Option Group
Baseball = 1
Basketball = 2
Football = 3

Now when I do a report I would much rather have it show the actual
sport instead of a number.

Any Help?

Sure. Create a little translation table with two fields - SportID and Sport,
with values 1, Baseball; 2, Basketball; etc. Base the Report on a Query
joining your table to this lookup table.

This will also let you use a Listbox or Combo Box on the data entry form,
instead of the Option Group. The advantage here is that the list/combo box
will automatically expand to include Soccer, Field Hockey and Tiddlywinks when
and if you add them to the sports table, without the need to tweak the design
of your form.

John W. Vinson [MVP]

 

[CribbsStyle]

OK, I'm sorry...I'm pretty new to using Access...

Not sure how to do what you are saying

 

[John W. Vinson]

OK, I'm sorry...I'm pretty new to using Access...

Not sure how to do what you are saying

ok... break it down a bit more...

Ust the Tables window. Create a table named Sports with two fields - SportID,
Long Integer as a Primary Key; and Sport, Text, with values 1, Baseball; 2,
Basketball; etc.

Create a Query joining your table to Sports, joining whatever field your
option group updates (its Control Source) with the Sports table, joining the
number in your table to the SportID in Sports.

Use this Query (rather than your table) as the Recordsource for your report.
Pick the sport name from the Sports table to display on the report.

This will also let you use a Listbox or Combo Box on the data entry form,
instead of the Option Group. The advantage here is that the list/combo box
will automatically expand to include Soccer, Field Hockey and Tiddlywinks when
and if you add them to the sports table, without the need to tweak the design.
Just remove the Option Group from your data entry form (ummm... you *are*
using a Form, I hope, not a table datasheet with a Lookup Field, that
invention of the Devil?), and add a Combo Box or Listbox, your choice, using
Sports as its source of data.

John W. Vinson [MVP]