Forms and option boxes information

[Guest]

I apologise for my lack of Access knowledge but this is my first attempt at
setting up a database.
I have designed a form to make it easier to put information into my main
table but when i use the option box in my form the information that is
transferred into the table it appears as a number.

How can I get the information in the main table to show the selected option
as a word?

 

[Arvin Meyer [MVP]]

The output values of Option Groups are numbers. Add a table with the values
of the option group and the corresponding text value. An example of this is
the Shipping Method table in the Northwind sample database that came with
Access. Select help from the menu to open this database to look for the
example. The Option Group will show on the Orders form.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Also how can I get the option group to allow multiple selections and show
therse selections in the main table

 

[Rick Brandt]

I apologise for my lack of Access knowledge but this is my first
attempt at setting up a database.
I have designed a form to make it easier to put information into my
main table but when i use the option box in my form the information
that is transferred into the table it appears as a number.

How can I get the information in the main table to show the selected
option as a word?

That's not how option groups work. Don't be concerned with how your data looks
in tables. It's better to store the number and then in queries, forms, and
reports, you can use an expression or a lookup against another table to display
the corresponding text.

If you build a simple SELECT query that has all the fields from your table plus
a calculated field to give you the text version of your field them you can just
use that query in all places where you would otherwise have used your table.
That way you only need to write the expression one time.

 

[Guest]

Ok Rick thanks for that i won't be worried about how my data looks in the
table but how can I allow multiple checks in my option group?
I have 6 check boxes of which depending upon the selection 1, a few or all
of them can be selected? How can I allow for say the 1st 3rd and 6th check
box to be selected and that data appear in the table?

 

[Duane Hookom]

Option groups don't allow multiple selections. It is beginning to sound like
you need to re-structure your tables and possibly add a related table to
store your options.

 

[Rick Brandt]

Ok Rick thanks for that i won't be worried about how my data looks in
the table but how can I allow multiple checks in my option group?
I have 6 check boxes of which depending upon the selection 1, a few
or all of them can be selected? How can I allow for say the 1st 3rd
and 6th check box to be selected and that data appear in the table?

A basic database design rule is that you never put more than one value in a
field. If your situation calls for that then you should have a separate
table because what you have is a one-to-many relationship.

 

[Guest]

OK! As I said this is my first database so I am learning from just having a go.
What I am after is various options on availabilities (ie 6 boxes of
Monday-Saturday). From these boxes I want users to be able to select any
(from one up to all 6) of these boxes and for that data to be shown on a
table. How would I go about putting this into a form for easier inputting
into the table?

 

[Duane Hookom]

I hope you aren't taking my (or Rick Brandt's) reply as being critical. We
see this type of table structure quite frequently.
Assuming you have a primary key field in your table [EmpID] you would create
a table of availability:

tblEmpAvail
===================
EmpID
DayNum Numeric (values like 2-7 for Mon-Sat)

The combination of the two fields should be defined as a unique index.

This could be implemented with a subform based on tblEmpAvail displaying a
combo box for DayNum. The subform link master/child would be the EmpID
field.


--
Duane Hookom
MS Access MVP

OK! As I said this is my first database so I am learning from just having
a go.
What I am after is various options on availabilities (ie 6 boxes of
Monday-Saturday). From these boxes I want users to be able to select any
(from one up to all 6) of these boxes and for that data to be shown on a
table. How would I go about putting this into a form for easier inputting
into the table?