quote:

---

Greetings

I'm reasonably new to FrontPage, the DBRW, and ASP. I was pushed into it when my employer needed some dynamic pages. Enough about that I suppose. ;)

I have a very small but highly visible ASP application I've created. I have created an Access database in our company intranet. I have a page that displays records from the database and some administration pages that allow adding/updating/deleting records. Upon creating the form that adds records to the database, I noticed it captured what I'm assuming to be a hidden form field called Timestamp. My records on the display page are sorted in reverse order by this Timestamp field.

My goal is to update this Timestamp field when an update is made. That way the newest information will "float" to the top of the list. Unfortunately, I keep getting a syntax error upon any method I use to update the Timestamp field. I'm assuming it's because the field in the FrontPage form is text and the Access database is expecting some bizarre date format.

I posted in another forum and got as far as being able to set my form field with the current date and time as it displays from the database, but I'm stuck when it comes to actually updating the field with a different date and time.

Any takers?

Sincerely... Rick :)

---