Recent content by bijondhanbad

I have deleted the .ldb file. No change. Unable to open the mdb file. bijon

I was working with a stand alone mbd. Some how on closing the file, the locking information did not go. On opening the file, I get a message: " Unwanted file format (c:\raw\.................) OK/cancel" How do I open the file? Please help. bijon

Can any one suggest a method of rounding off the edges of a form? bijon

I want to convert a multi page access report to pdf format and mail it to my boss. Is there any way to do this using the on Click event. Thanks in advance bijon

Sorry to be late. But there are two codes given, which one has to be copied & pasted/ bijon

Still not getting it. Please help. bijon

The users will always be updating the HQ_File_Ref first & then the HQ_File_Date fields.The code will have to be written keeping this in mind. bijon

Still not getting it. Someone please help!!!! bijon

Both these fields are filled up by user. In the form that has been designed, the first field to be entered is HQ_File_Ref & the second is HQ_File_Date. Yes, u have got it right.... "The bottom line is, the code can't be run until both fields are filled." bijon

In the form, the first field that is populated is the HQ_File_Ref, then the HQ_File_Date. So when the first field HQ_File_Ref is entered, the second field is still blank. I think the DCount function shall have to be applied only after the first field is entered & before the HQ_File_Date is...

Yes, HQ_File_Date is Date/Time & HQ_File_Ref is Text. I have set another field Prop_ID as the primary key.

Let me be more elaborate. I am trying to prevent duplicate entries on a combination of two fields, eg, HQ_File_Ref & HQ_File_Date. I am using the following code in the event before update in the field HQ_File_Date Private Sub HQ_File_Date_BeforeUpdate(Cancel As Integer) If...

Let me be more elaborate. I am trying to prevent duplicate entries on a combination of two fields, eg, HQ_File_Ref & HQ_File_Date. I am using the following code in the event before update in the field HQ_File_Date Private Sub HQ_File_Date_BeforeUpdate(Cancel As Integer) If...

These two fields are not composite primary key.Duplicacy has to be checked for both these fields.

I am using a data entry form to enter new data into one of the tables.How can we prevent entry of duplicate records? Duplicacy shall be checked on the first two fields only. Please help. regards bijon