Recent content by Imranis

Fantastic and it worked perfectly. Many thanks.

Thanks for reply, but even with this code, the problem persists.

Thanks for reply, will appreciate if you kind amend the the whole code with your above format.

I am using following code to open a report for the people who have already been entered with the help of date of birth. But the format of date dd/mm/yyyy is automatically converted into mm/dd/yyyy, even my regional setting of the computer is not that of US. will appreciate if the code is amended...

thanks. it is working. only last question on this. if the any other field on the table is text not the date, same code will work or there will be some change in it, if so, please help. thanks again.

Thanks I understand that. But purpose is to avoid re-entering all the data again & again for the same person and the check is to be placed on only one filed that is date of birth. So If entry is made with the same date of birth again, message pops up and tells that with the same date of birth...

Thanks for reply. But I do need. duplicates of date of birth because many people have same date of birth. Indexing with No duplicate of field does not serve the purpose. thanks for reply again.

Thanks for the reply. I created the report "rptMaintable", the code worked only for entry, then it stopped working altogether, now if I enter record with duplicate Date of Birth, the message is not coming up. I think there is some slight problem.

Hi, I have a table called 'maintable'. It has 5000 plus entries of employees with different fields. Every Employee has unique ID. One field is date of birth (dob). Normally more than one person can have the same date of birth. A form (maintable1) is created to enter data into this table. In...

It is giving run time error, please

Can you please type the exact words, how they should be typed in code. thanks

I am working on a Form, which has many fields. Among them there is one field which contains only two values "Manual" or "auto". I wish that whenever I type the value Manual in this field, the tab order should not touch the other field (the name is booklet) but if it is "auto", then the tab...

Thanks for reply. Actually I wish to set the tab pattern that if input in pptno is manual then the field bookletno may be inactive and so on. thanks.

thanks for reply. Basically i wished to have the following code workable: Private Sub Form_Load() If Me.typeppt = "Manual" Then Me.bookletno.Visible = False Else Me.bookletno.Visible = True End If End Sub thanks

thanks for reply. Actually I have many entries in a form and wish to make some fields status as false when the first entry does not correspond to it. If me code =3, the Chair= False, otherwise true This is a simple command, but it is not working because I do not know if Sub command will...