Faisal, I'm new in ASP .
And for ur information, I try to work on the above example n modify it , but I get the error messange as below:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
/employee_ac.asp, line 29

I add on a data field with file type to let user to browser their file, inside the form.

the section code as below:
<input name="FirstName" type="text" >
<input name="LastName" type="text" >
<input name="Tel" type="text" >
<input name="Address" type="text" >
<input name="DateContacted" type="text" >[Access field type:Date]
<textarea name="Comment" rows="5"></textarea>


I hope that u can help me to solve the problem that I encounter, I really appreciate ur contribution

san,

No wonder you get an error. Reason is that Access expects the date entered to be in a certain format like '5/18/2004'. The user might enter it in some other format not understood by Access e.g. '5/32/2004' , so Access doesn't accept the new record.

Remember you have to enclose the date using single quotes like you enclose user entered text.

If at all you have to let user enter dates, then instead of making them *enter*, make them *select* by using year, month and day option fields within a select box. Then you yourself should validate and create the appropriate date by using the values selected by user and enter it into the database.

Hope you get the idea.

while closing the pop up window we have to capture events using java component. and how we have to call that component in ASP. how we have get methods in ASP