New to databases, simple question

  • Thread starter Thread starter Houston
  • Start date Start date
H

Houston

I am trying to create a very simple database. All I am asking is two
questions, "Are you going to the lake this weekend" and all I want to store
is an answer YES or NO via radio buttons.

Then I ask, "Your Name" and store that. I am not able to fugure out ohow to
ask the first question using radio buttons. Can someone help please?


Thanks
Houston
 
You need a table with at least two fields:

Name Text
GoingToLake Yes/No

You might also want an autonumber primary key field to
uniquely ID the record, and in complex DB's, name is
usually broken into the first and last names. If your
scope is small, you needn't do this.

Create a form based on the table, placing a textbox for
the Name and an Option Group for the Yes/No field. Before
doing so, enable Wizards by clicking on the toggle button
with the wand and five stars on the Toolbox toolbar.

Choose labels for each choice. When the wizard asks what
values to assign to each, say -1 for Yes and 0 for No,
then tell it to save the value in your GoingToLake field.

HTH
Kevin Sprinkel
 
Houston, TX., Place an option group on the form and follow the wizard. If
the wizard doesn't launch make sure the little wand with stars is selected
on the toolbox before placing the option group on your form.
 
I am using Access 2000 and I see no Wizzard tool to activate on the toolbar.
I do however have the option of using "Design View" or the "Wizzard" to
create the form. When I use the Wizzard, it never askes me about lables.
Need more help I guess.

Houston
 
I am sorry, I am using access 2002


Kevin Sprinkel said:
You need a table with at least two fields:

Name Text
GoingToLake Yes/No

You might also want an autonumber primary key field to
uniquely ID the record, and in complex DB's, name is
usually broken into the first and last names. If your
scope is small, you needn't do this.

Create a form based on the table, placing a textbox for
the Name and an Option Group for the Yes/No field. Before
doing so, enable Wizards by clicking on the toggle button
with the wand and five stars on the Toolbox toolbar.

Choose labels for each choice. When the wizard asks what
values to assign to each, say -1 for Yes and 0 for No,
then tell it to save the value in your GoingToLake field.

HTH
Kevin Sprinkel
Click to expand...
 
Houston,

Select View, Toolbox (or View, Toolbars, Toolbox) from the
form design menu to display the wizard icon on the Toolbox
toolbar.
 
Back
Top