help with dates

[beanbeanbean]

hi guys can u all please take a look at my database. there are problems with the datequery, transaction one, transaction two and transaction three textbox.

the thing wrong is that the date can be typed in any amount like 64 / 64 / 2008.

can anyone help me and tell me what can i do to restrict it ?

i've tried make my table field into date/time but it still does not work.



attached is my database. thanks.

 

[naungsai]

In the table design, you should choose "Date/time" in data type.

 

[beanbeanbean]

thats what i did bro, but it didnt work. i need it to show the / in the table too.

 

[naungsai]

thats what i did bro, but it didnt work. i need it to show the / in the table too.

I have reattahced your file. I have change the data type in the table.

 

[beanbeanbean]

yes bro. thats what i did.

but here's the catch.

for example if its date/time in the table design. and i enter 64 / 64 / 2008 in the form. the form would still continue to enter the data even thought the value typed in the form in wrong. but when i refer to the table, it shows up as a blank as the date i've entered is invalid due to the date/time data type in the table design.

what i want to ask:
is there any way to validate the date before entering it into the table ? like for example, i type 64 / 64 / 2008 and press the submit button. a msgbox would pop up saying that the date entered is invalid.

anyone can help ?

thanks !

 

[Rabbie]

Just select Shortdate when setting the input mask on your form. This will then flag an error if you try to input something stupid like 64/64/2008

 

[naungsai]

yes bro. thats what i did.

but here's the catch.

for example if its date/time in the table design. and i enter 64 / 64 / 2008 in the form. the form would still continue to enter the data even thought the value typed in the form in wrong. but when i refer to the table, it shows up as a blank as the date i've entered is invalid due to the date/time data type in the table design.

what i want to ask:
is there any way to validate the date before entering it into the table ? like for example, i type 64 / 64 / 2008 and press the submit button. a msgbox would pop up saying that the date entered is invalid.

anyone can help ?

thanks !

I found out that you did not link your form with the table. I have done one in my attached. In doing so you just use the form wizard.

I have not add buttons in the attached.