J
Jesse
BEGINNER - Using Access 2007, I'm trying to set up a survey form for someone
and am immediately having problems. I've only performed very basic designs in
Access. I took the task on because I've never done something like this and
wanted the challenge.
The first question is the worst of the lot. I have five columns and six rows
as shown in the Table below, which are actually Check Boxes on the form with
the info Header to the right. These all pertain to ONE QUESTION on the Survey.
N Y M W D
City
County
Local
Park
Town
Bypass
What I've done so far is to generate a table containing five Fields. The
above pertains to just the first question/first field. I generated a Form,
went to the Form Structure and for the "N" pulled in 6 check boxes. Under the
Arrange Tab I selected the Stack option which grouped that column vertically.
(Looking at it now I'm wondering if I should have grouped horizontally?) I
repeated these steps for each of the five columns. I ASSUMED after reading
what little there is in Access concerning Check Boxes that I was doing this
correctly.
I need to know if I've started this off correctly. If so, then HOW do I
extract the data from the check boxes. Each is unique, but how do I do a
compilation of say 500 records of information?
The next problem I ran into is that even though I neatly organized the Check
Boxes on the Form Structure, it does not retain that format when viewing the
form for Input. Rather it puts the check boxes in a row (record). How do I
get it to display much as a paper form would be?
I would appreciate any and all help with these problems.
Jesse
and am immediately having problems. I've only performed very basic designs in
Access. I took the task on because I've never done something like this and
wanted the challenge.
The first question is the worst of the lot. I have five columns and six rows
as shown in the Table below, which are actually Check Boxes on the form with
the info Header to the right. These all pertain to ONE QUESTION on the Survey.
N Y M W D
City
County
Local
Park
Town
Bypass
What I've done so far is to generate a table containing five Fields. The
above pertains to just the first question/first field. I generated a Form,
went to the Form Structure and for the "N" pulled in 6 check boxes. Under the
Arrange Tab I selected the Stack option which grouped that column vertically.
(Looking at it now I'm wondering if I should have grouped horizontally?) I
repeated these steps for each of the five columns. I ASSUMED after reading
what little there is in Access concerning Check Boxes that I was doing this
correctly.
I need to know if I've started this off correctly. If so, then HOW do I
extract the data from the check boxes. Each is unique, but how do I do a
compilation of say 500 records of information?
The next problem I ran into is that even though I neatly organized the Check
Boxes on the Form Structure, it does not retain that format when viewing the
form for Input. Rather it puts the check boxes in a row (record). How do I
get it to display much as a paper form would be?
I would appreciate any and all help with these problems.
Jesse