I want to update a database, the first column of the database contains a 
list of every student in a department, the next 8 columns for each student 
shows what module each student is doing, some of these are different and 
some of these are the same. What I want to do is select a specific module 
for a specific student and update that cell. How can I do this?
I'm a beginner at ASP, I have found out how to do some of the other stuff 
like inserting new data, but not this.
I know how I could update a field where a field is like something, but 
this would update every module in a column that is like the condition.
Any hepl would be greatly appreciated, thank you.

Try something like this,

"UPDATE YourTable SET YourField =YourData WHERE YourID = " & idNumber

Where idNumber is the ID of the record you want to update.

Ethan

-----Original Message-----
From: Philip Jeffery [mailto:P.A.Jeffery@e...]
Sent: Sunday, April 07, 2002 5:53 PM
To: Access ASP
Subject: [access_asp] Help updating an access database using ASP

I want to update a database, the first column of the database contains a
list of every student in a department, the next 8 columns for each student
shows what module each student is doing, some of these are different and
some of these are the same. What I want to do is select a specific module
for a specific student and update that cell. How can I do this?
I'm a beginner at ASP, I have found out how to do some of the other stuff
like inserting new data, but not this.
I know how I could update a field where a field is like something, but
this would update every module in a column that is like the condition.
Any hepl would be greatly appreciated, thank you.

> Try something like this,

"UPDATE YourTable SET YourField =YourData WHERE YourID = " & idNumber

Where idNumber is the ID of the record you want to update.

Ethan

-----Original Message-----
From: Philip Jeffery [mailto:P.A.Jeffery@e...]
Sent: Sunday, April 07, 2002 5:53 PM
To: Access ASP
Subject: [access_asp] Help updating an access database using ASP

I want to update a database, the first column of the database contains a
list of every student in a department, the next 8 columns for each student
shows what module each student is doing, some of these are different and
some of these are the same. What I want to do is select a specific module
for a specific student and update that cell. How can I do this?
I'm a beginner at ASP, I have found out how to do some of the other stuff
like inserting new data, but not this.
I know how I could update a field where a field is like something, but
this would update every module in a column that is like the condition.
Any hepl would be greatly appreciated, thank you.

I thought it would be easier if I showed you the website:

go to http://gosh.ex.ac.uk/~se99paj

This has a zip file that contains all of the pages, what I would like is 
for the user to select a module that they would like to ask a 
questionnaire on, after they have selected it for that module for that 
user to be updated to something else. I know how to update now, but don't 
know how I can specify the field for that module.
Please help.