Search results

Is there a way to be able to use the Edit Record button even though it's not in the detail section of the form? I hadn't planned to keep the RescID field in the detail section.

It's not working for me. I put the code you just send on the Edit Record button as an OnClick event. I'm getting the same error "Compile error: Method or data member not found". Can you return the database with the code you entered?

Ok, I have stripped it down and have attached it. The issue lies with the Edit Button on the form frmOfficeDetails1. I would like to be able for the User to have their cursor in any field of a record in the subform, click the edit record button and have the form frmRescEdit open to the record...

I would have to strip a bunch of confidential information out before sending it. In the message above, I used a generic name for the ID. In the actual database, there is the following: The source table for the Subform includes an ID field named RescID The source query for the Subform includes...

The ID is in the record source for the subform and it also in the subform. What would I change them to? I'm so glad you are the one to respond. I have reviewed your website http://www.baldyweb.com/wherecondition.htm but have been knocking my head against the wall because I haven't been able...

I am having an issue with a MainForm and SubForm scenario that includes filtering, running a query on the subform data and also opening a separate form to edit the subform records. Scenario #1 I have a Navigation form that includes a list of clients. When a client is clicked in the list...

Sorry I did not reply sooner. Deep in a project. Thanks for your updated code.

jdraw, I tested it and everything seems good. Thanks again.

I will give it a full test in the AM. Can't get to it right now.

Yes, I'm still following. I deleted a record using the Record Selector and it deleted two records. Again, I would never have someone delete a record using the record selector so I don't think it matters but wanted you to know. Would this code also handle and record changes if the form had a...

Correct, I would never leave the record selector on a form but was just curious about the error message. Take care and thanks again for all of your help.

jdraw, I don't think I ever responded to your other question below. I'm still not following exactly what you are doing in this Quote: For curiosity sake, I clicked the Record Selector in the form for a record and hit the delete key and received this error message "The Microsoft Access database...

Thanks for the links to the VBA code. I'll also look at Dane's post. Yes, I had tried to implement data macros and I deleted them. I guess some info remained in that table.

I had tried using data macros from ScottGem at https://scottgem.wordpress.com/2012/10/18/audit-trail-using-data-macros-2/ and a few others but they required that you implement the data macros on each individual field which, like Allen Browne's audit trail, I thought was too much. To date, the...

In the database you returned, I can delete a record with no issues using the command button you inserted. For curiosity sake, I clicked the Record Selector in the form for a record and hit the delete key and received this error message "The Microsoft Access database engine stopped the process...

For the test database I was clicking on the recordselector and pressing the delete key, however, wouldn't a delete no matter what caused it behave the same way, e.g. I used the recordselector or if I inserted a command button on a form to delete a record?

I believe it's by the AfterDelConfirm event. I'm using the code that arnelgp added in response to the original post to include events in subforms in the audit trail.

jdraw, Ok, I created a test database and have attached it. I deleted record 5185 and it recorded 5186 as deleted with no other information. Again, thanks for your help.

jdraw, Actually, when I delete a record it's only adding one line to the Audit Trail table with the Date/Time, User Name, FormName, RecordID (Wrong ID), and Action of "Delete". It's not listing each of the record's fields on a separate line marked with "Delete" and the old value.

jdraw, Thanks for your assistance. I'm not just deleting a field, I'm deleting an entire record and then it's recording the wrong RecordID. Even Mr. Green's sample database is recording the wrong ID of a deleted record. Unfortunately, I can't send you my database because it contains...