Recent content by kanxay

i can not upload the .accdb file , so i only post the picture like this , please some one explain clearly because i do not have basic about VBA access

I have a form with date entry ! And I want to make alert when forget to enter the date ? How can I do ???

turn on Index on the date field, (With No Duplicates) the message box alert on table but not effect on the access Form of that table ???

excuse me , is this VBA code ? i don't know how to use and where to put on ? could you help one more please ? and i can't upload file to show because The uploaded file does not have an allowed extension.

but ! i want alert box or pop up message to let's user know the duplicate date when they entry the form access

how to prevent duplicate date entry in access form ? i have a simplify form with name, age, phone number and date collected. i want the user cannot entry the form with same date or duplicate date how can i do ?

Dear Mr. vba_php , please see it again i add the data in to my form , when i click next or previous , the No: (Number) is not range

help me please

in my form i create next and previous buttons to rewind my data , but the data was not range ????? how should i do ?

Dear Mr. vba_php when i press search icon (With empty ) the massage box will alert "ID entered was not found" But when i fill wrong ID such as: 236598711621002346 then it Debug ???

Upload new try , please every body help :o:(:)

Private Sub cmdCancel_Click() Unload Me End Sub Private Sub cmdClear_Click() 'clear the form For Each ctl In Me.Controls If TypeName(ctl) = "TextBox" Or TypeName(ctl) = "ComboBox" Then ctl.Value = "" ElseIf TypeName(ctl) = "CheckBox" Then ctl.Value = False End If Next ctl End Sub...

ok ! i can upload ! help me please :confused:

Less than 2 Mb but it a enable VBA file ! I tried many time but it doesn't work