Search results

Hi, Could some one help me with my query pls.? Thanks.

Hi Bob, Is it possible to do the Dcount for combo boxes? If so how can I do it? I figured out it works fine with text boxes. But in the frm_EdData I have used combo boxes which makes editing records easy. It's for these that I struggle to use Dcount to check for duplicates in the beforeupdate...

Hi Bob, Did you get sometime to look at my request? Thanks.

Hi Bob, In the frm_EdData there are multiple controls where I don't want duplicates. The form is linked to the tbl_IpAdd. In the form there are 3 fields that need to be checked for duplicates when entering data and they are "Employee Details", "Machine Details" and IP Address. Once a machine...

Hi Bob, Don't worry I realised what I did wrong there. It's working now. Thanks. However I would like some guidance on how to use the code on a form where multiple controls have to be checked for duplicates (e.g. like in the frm_EdData).

Hi Bob, I've uploaded a copy of the database for your inspection. I've tried to replicate what you've done to the frm_NewMach in frm_NewBrnh but gets an error. Pls. let me know what I'm doing wrong. Also I would like an example how I could use the expression Dcount in a form where multiple...

Hi Bob, Am I doing something wrong when replicating the code for other forms? Thanks.

Hi Bob, Thanks for the code. I tried to modify it to suit other data entry forms in the database but then it gives an error. I've attached the screenshots with this. I've tried to modify it for the frm_NewBrnh. In your sample you've written "Me.Machine_Name". I'm wondering why an underscore...

Hi Bob, Thanks for all your help. I'm new to programing. I've uploaded a copy of the database with this. I would appreciate if you could guide me how to do it. Just show me at least for one field so that I can do the same to other fields too where I don't want duplicate entries. Also one more...

Hi, Could anyone help me please? I have uploaded a copy of the database few posts before. In tables some fields are indexed with no duplicates. When the field is changed to a value already present in the table via form the user gets the error as the change is not commited because if would...

Hi, I'm still having an issue with the code. Though the code works perfectly the information logged in the AuditLog table is wrong only for some fields. I have some combo boxes in the form. The table fields bound to them are indexed (with no duplicates). So if I try to select a value that's...

Hi Bob, Thanks a lot. It is working. I was breaking my head on this for so long.

Hi Bob, I've uploaded the database.

Hi Bob, When I put a comma it gives me the same run time error as before saying access can't find the field "recordid" referred to in your expression. The table has that field and it is the primary key of the table. The only difference is the case of letters (RecordId - in the table and...

Hi Bob, When I put "Call AuditTrail (Me. Me!RecordID), I get a compile error: Method or Data Member Not found. Also RecordID (wording) automatically gets converted to lowercase and reads as recordid. But in the table, the field is labeled as RecordID.

Hi Bob, Thanks again. What do you mean by field name here? In the table created for Audit Trail (i.e. tbl_AuditLog) RecordID is the primary key. As all records in all tables are captured in the Audit Trail I thought this should be the field name. Pls. correct me if I'm wrong. Thanks for the...

Hi Bob, Thanks for the reply. When I put the VB code VB Editor I get a runtime error 2465. Pls. see the attached image. When I click debug it goes to the VB editor but I can't find anything wrong in the expression. I've attached an image of the Code as well. This was the code mentioned in the...

Hi, When I put the code in the following thread by irish634 I get the error, "Microsoft Office Access can't find the macro 'Call AuditTrail(Me.'. I've also attached a screenshot of the error. http://www.access-programmers.co.uk/forums/showthread.php?t=157566 What should I do to rectify...