运行更新查询备注字段 [英] Running an update query to a memo field

问题描述

这可以是一个简单的（无论它是可以或不可以）..我有两个表来说是相同的一组记录。我需要找到最好的办法，当备注字段中的一个被修改，该修改得意忘形，以相同的记录上corrisponding相同的表。在许多情况下，该领域可能有几百个字......，我知道如何使用更新查询可能做到这一点的唯一方法，但我想知道，如果在测试中真的是大，会打破它？或者有另一种方式？谢谢，A

This may be a simple one (whether it is possible or not).. I have two tables which are identical with a set of records. I need to find the best way that when one of the memo fields is modified, that the modifications get carried to the identical record on the corrisponding identical table. In many cases the field may have hundreds of words.. The only way that i know how to potentially do this is using an update query, but i am wondering if the test within is really large, will it break? Or is there another way? Thanks, A

推荐答案

既然你正在使用Access 2010中您可以使用一个更新的数据宏后回到复制更改主表：

Since you're working with Access 2010 you can use an After Update data macro to copy the changes back to the main table:

有关详细信息，请参阅

创建数据宏

这篇关于运行更新查询备注字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！