Save me!

hi all,
I would really appreciate it if you could help me solve some bugs.
I'm still rather new in VB6, and recently i've been assign to create a simple form.
Problem is, after a user types in the date in the incorrect format and clicks 'save', of course an error message is displayed.However, when the user retype the date correctly, it can't be saved. (the date doesn't follow the system's date)
Do i really need to use 'Begin/CommitTrans' command. My supervisor says there other ways to correct this without those commands.But i've got to figure it out (says he)
I know it seems like a small problem but its giving me a headache

and another thing is, after editting and clicking on 'Save', error message appears stating that duplicates aren't allowed. How do i update this data then?
Please help.

By the way u need to connect the database with the form.
(go to settings>control panels>chose ODBC Data Sources> chose System DSN tab> click 'Add'> chose Microsoft Access Driver (*.mdb)>click 'finish'> Type "EmployeeInfo" in the 'Data Source Name> click 'Select> find the location of the database(which i've attached it for you)>click 'ok'.)

thanx!!

p.s you can also reach me at [email protected]

what format is your date field in?

mm/dd/yy ?????

Try with this attachment. I hope it will work Fine.

thanks a lot Prasad,

it certainly lightened my problem. If you don't mind, do you know how to fix the part where the user correct their date mistake and try to save it again?

regards,

Wilde

I Hope this will solves all your problems