• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 218
  • Last Modified:

How can I write form field data into rows rather than columns?

Hi All,

I am trying to create a simple online questionnaire, using frontpage 2003, to go on our intranet. The idea is to use it for entering workshop evaluation data (happy sheets filled in by our client delegates at the end of an event) and automate the process of reporting on this data.

So for instance, Question 1 might read: 'To what extent were the workshop objectvives met?', below this there is a dropdown box (1-5) rating and a txt box for entering any comments. Question 2 might say:  'What benefits have you personally derived?' and just have a txt box to enter the delegates comments, and so on and so on.

My form is setup and connected to my access db but I only appear to have the option of writing form fields into columns. What I want is for each question (rating and comment response) to go into a seperate row in the db. I suspect that I need to insert some kind of looping code for this to happen but its a bit beyond me at the moment - any pointers or sample code gratefully received as I'm completely stumped!

Many thanks in advance,

Lenny


0
Mad_Lenny
Asked:
Mad_Lenny
  • 2
1 Solution
 
hhammashCommented:
Hi Lenny,

You do not have to worry about how the data are entered in the database,  you can do what you want in the report.

Question 1 has a drop down and a text box,  so in the table desing make:

Field Name
Question1cbo
Question1txt
Question2txt
Question3cbo
Question3txt
Question3rdo

cbo=combo box
txt= text field
rdo=radio button
....etc

Then on the report page you can position the info as you like

hhammash
0
 
hhammashCommented:
I did a huge questionnaire before in the same way,  and since I am the webmaster and have access to the database, I created the reports in MS Access.

You can also create a web page for the report.

In the questionnaire you will be gathering count on the questions also right?  like how many said yes or no to something ..etc
0
 
Mad_LennyAuthor Commented:
Hi Hammash, sry for not replying sooner (plate spinning other projects), but hope to spend time on this over the weekend and work through your replies, many thanks...and yes I will want to be gathering count on the questions. The reporting side of things should be fun, but I'll worry about that (and no doubt post a new question!) once I'm happy that the data is going in ok...

Will, let you know how I get on,

Lenny
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now