如何将数据字段转移到新记录？ [英] how do you get data fields to carry over to a new record?

问题描述

是否有一种简单的方法，无需设置模块，以便在MS Access 2003中将某些数据字段转移到新记录。我已尝试对默认值进行了大量修改。但是它们似乎都不起作用。


如果有人可以帮助我，我将不胜感激。

解决方案

< blockquote class =post_quotes>
是否有一种简单的方法，无需设置模块，以便在MS Access 2003中将某些数据字段转移到新记录。我已经尝试了很多修改到默认值但是它们似乎都没有用。


如果有人能帮助我，我将不胜感激。

1. 您是否希望所有字段都转移到新记录或选择性字段？
2. 您想要吗？这些值会自动转移到新记录，还是当您输入这些字段时？
3. 将数据输入字段后，它是否成为该字段的新默认值？

有一种简单的方法，无需设置模块，也可以将某些数据字段转移到新记录中在MS Access 2003中。我已经尝试了很多对默认值的修改。但是它们似乎都没有用。


如果有人能帮助我，我将不胜感激。

这个表是否有一个唯一的字段，为每个添加的记录递增？

如果是，那么你可以使用嵌入的DMax DLookup。

1. 您是否希望将所有字段转移到新记录或选择性的？
2. 您是否希望这些值自动转移到新记录，或者当您输入这些字段时？
3. 将数据输入字段后，它是否会成为新的该字段的默认值？

很抱歉之前不清楚：


我只需要选择性字段结账，而不是全部。


我实际上正在使用表单，所以当用户决定插入新记录时，我希望前一条记录中的某些字段可以继续使用。


是的，一旦在表单上修改了选择性字段中的值，我希望这些值成为新的de故障值。

Is there a simple way, without setting up a module, to get certain data fields to carry over to a new record as well in MS Access 2003. I''ve tried alot of modifications to the "default value" but none of them seem to work.

If anyone can help me out it would be greatly appreciated.

解决方案

Is there a simple way, without setting up a module, to get certain data fields to carry over to a new record as well in MS Access 2003. I''ve tried alot of modifications to the "default value" but none of them seem to work.

If anyone can help me out it would be greatly appreciated.

1. Do you want ALL Fields carried over to the New Record or selective ones?
2. Do you want these values automatically transferred over to the New Record, or when you enter these Fields?
3. Once data is entered into a Field, does it become the new default Value for that Field?

Is there a simple way, without setting up a module, to get certain data fields to carry over to a new record as well in MS Access 2003. I''ve tried alot of modifications to the "default value" but none of them seem to work.

If anyone can help me out it would be greatly appreciated.

Does this table have a unique field that increments for each record added?
If it does then you can use a DMax embedded in a DLookup.

1. Do you want ALL Fields carried over to the New Record or selective ones?
2. Do you want these values automatically transferred over to the New Record, or when you enter these Fields?
3. Once data is entered into a Field, does it become the new default Value for that Field?

Sorry for being unclear before:

I only need selective fields to be carried over, not all.

I''m actually using a form so, when the user decides to insert a new record, I want certain fields from the previous record to carry over.

Yes, once the values in the selective fields are modified on the form, i want those value to become the new default values.

这篇关于如何将数据字段转移到新记录？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！