I did note that when I first load the 2nd page it looks right, but there is a error on the page, then when I got to editsave.. the error triangle is gone... but I get an error message!.. line 51

A small advice for Tandy...

Be carefull with your personal information like your email adress etc. Perhaps it is fictional but spammers enjoy spamming the emails put online.

Jacob.

Thanks Jacob.. for bringing that to my attention.... duh on me.

Still have a problem with my strSQL???
I fixed the (,) but still....
 strSQL = "UPDATE tblIThelp SET " _
        & "sFname = '" & (Request.Form("Fname")) & "', " _
        & "Lname = '" & (Request.Form("Lname")) & "', " _
        & "Email = '" & (Request.Form("email")) & "', " _
        & "phone = '" & (Request.Form("phone")) & "', " _
        & "dept = '" & (Request.Form("dept")) & "', " _
        & "repeat = '" & (Request.Form("repeat")) & "', " _
        & "priority = '" & (Request.Form("priority")) & "', " _
        & "Comment = '" & (Request.Form("comment")) & "', " _
        & "notes = '" & (Request.Form("notes")) & "', " _
        & "tech = '" & (Request.Form("tech")) & "', " _
        & "date = '" & (Request.Form("date")) & "', " _
        & "time = '" & (Request.Form("time")) & "', " _
        & "solved = '" & (Request.Form("solved")) & "' " _
        & "WHERE (id = " & intID & ")"

It would be easier if you post the outcome of the query, rather than posting the code.

So, please post the results of the response.Write statement.

Also, before you post the query, paste it in the Microsoft Access Query designer, so you can test it......

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Check for keywords; you use word like date, time, repeat, priority which could be keywords.

Other things could be difference in the types in the database. You enclose every value in quotes where you might have a representation in your database, which is not string or similar types. E.g. priority could be an integer.

You write Comment with capitalized C where all other names are with lower case letters? is this right?

Jacob.

Is this what you mean?

I am in editsave UPDATE tblIThelp SET sFname = 'Tandy', Lname = 'Lala', Email = 'some email', phone = 'no phone', dept = 'one', repeat = 'no', priority = 'med', Comment = 'Just testing it help desk program', notes = 'fdgsdg', tech = 'RON', date = '3-21-99', time = '9:33', solved = '' WHERE (id = 1)

Yes, that's what I meant.

Take Jacob's advice, and look at the datatypes in your database. Also, paste this query in Access. Access is a lot better in debugging your queries than a P2P forum where people can just guess at the things you're doing and the data structure you're using.....

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Imar,
I'm not sure I understand. Are you politely telling me to bug off? What do you mean by paste this query in access? I've never done that. I guess I can go back to my Acces book.
Thanks for all your help,
 Tandy

You open your access database and click 'Queries'. Then you create a new one (without wizard) and then you go to the upper left corner, where it says SQL. Click this and you can paste your query.

Jacob.

Nonono, not at all. I am trying to give you hints on how to improve your debugging abilities:

1. Open Access
2. Open your database in Access
3. Click the Queries tab / category
4. Choose Create query in Design View
5. Close the add table dialog
6. Choose View | SQL View
7. In the textbox that appears paste the update statement you posted (the outcome of Response.Write)
8. Choose: Query | Run


Access will tell you what's wrong with the UPDATE statement.....

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.