Search results

I don't think this is a code issue. The append only is in the property of the column. Looking at the table in Design View, click on the relevant column (which is a Memo field), look at the properties at the bottom - set the Append Only property to YES. Save the BE and then open the FE and...

I've got an A2010 DB. Split DB. I've got a column in the back end which I would like to make append only. When I do so, and then open the front end I get the error "The search Key was not found in any record". If I set the append only property back to No for that column, its fine again...

Thanks for the help. I've sorted it now. I added a text box to the form to show Date Completed, and changed the vba so it shows in that box. Works now and to be honest is better than just updating the backend table.

Cheers, at least I know I'm heading in the right direction! So my vba looks like this: Private Sub txtStatus_AfterUpdate() If txtStatus = "Completed" Then CompletedDate = Now() End If End Sub After saving, and setting a record to completed it doesn't update the CompletedDate. There's...

I've got an Access 2010 database based on the Tasks template. I've added a column to the Tasks table called "CompletedDate" I'd like for the Status combo box on the Task Details form to update the Completed Date for that record. i.e. so when the Status is set to completed, it auto completes...