04-Aug-2005

I've created an Insert page with DreamweaverMX. There are 4 fields in the form - used to add training events to an Access database. Two of the form fields are dynamic lists ('course' and 'room') and the other two are text-input fields ('date' and 'time'). THE FORM WILL NOT SUBMIT THE RECORD WHEN SUBMIT IS PRESSED.

Through process of elimination, I removed the date and time (text-input) fields from the form - tested again and got a SUCCESSFUL submission. I then tried to include only the date field with the two working fields (as a 'text' datatype as well as a 'date' datatype) but that won't work either. Nor does it help to change the date to a menulist item and submit as text.

I also tried doing only text input fields for all four form fields (inserted as text) and I still cannot get the form to submit. Each time I was careful to make sure the datatypes matched up between Acccess and my insert form. The two menulist items are submitted as text so it's very confusing that it will not work when all for fields are submitted as text or if I try to include additional menulist items with the same formatting.

I also tried to add only the 'time' (text-input/text datatype) field along with the course and room menu fields - again, no success.

The page was built manually - field by field. I also tried building the page with the Wizard but that doesn't work either.

As best as I can tell, I am building the page properly - am beginning to wonder if it's a server issue - but why will it add the record if I use only the menu fields?? Does anyone have a clue as to what could be causing this problem? <b></b><b></b><b></b><b></b><b></b>

I've had forms that sometimes required the date to be entered as MM/DD/YYYY. The form wouldn't submit unless leading zeroes were added in the form. You might try that to see if it will submit with the extra zeroes.

Using a javascript calendar pop-up to complete the date field ensured the field was correctly formatted and didn't rely on the user to complete the form correctly.

Thanks Pam, I'll try that. Sounds like you've been 'down the road' with date formatting. The odd thing is how the date DISPLAYS when you create a 'results' page. Seems like it doesn't matter how I have it formatted in Access, it will display as YYYY-MM_DD 00:00:00.0

Have you stumbled upon this too? Do you know how I can change it.

Have tried this suggestion for entering dates. Still no luck. Again - I am stumped that it will not accept ANY data in that field regardless of how it's formatted. Both the form and the database were formatted as text fields but it won't work. <img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle>

SOLUTION FOUND! If anyone should run into this issue - my problem turned out to be a KEYWORD ISSUE. Both 'date' and 'time' were keywords and that's why the insert would not work on those fields.