Search results

I would like to write a macro in Access 2010 that can compare two memo fields (field and [old].field) and determine if any changes has been made. To determine if a text field have been changed I can used the 'updated' operator: if (updated([field]) then ..... endif but this doesn't work...

You may find the answer in a thread I started in the forms sections of this forum useful - I can't post hyperlink to it but it last part of URL is '/showthread.php?t=224867'. My issue was slightly different but using Lookup record in a data macro and some vars may help you. You could then...

I can see them now thanks. I see that the table data macro replaces the SQL lookup step in my VBA code and the other macro does the control setting function. Cool - I have been struggling with how to do lookups etc in macros - I see now that you have to do it with a data macro and that this...

Thanks Beetle, that sounds really useful. I cannot see your images / attachments. Can you check they have uploaded correctly?

Hi all, I am creating a Web Database and need to be able to present a form that will autopopulate with values from a previous record but that will insert a new record rather than editing the existing one once any edits have been made. For auditing purposes, the existing record cannot be edited...