将表格数据输入表格 [英] Input form data into table

问题描述

通过使用添加记录按钮，我想将表格（tbfullname）上的值添加到表格（L1 Reviwer），表格称为LC1_Tbl


表单上的某些字段中包含表达式。


请问您是否可以通过VBA或SQL来帮助它？


表格名称为Lc1_tbl

表格中的字段为L1审稿人

表格上的文本框称为tbfullname


非常感谢您的帮助。

Hi,

By using an add record button, I would like to add the values on a form (tbfullname) to the table (L1 Reviwer), table is called LC1_Tbl

Some fields on the form have expressions within.

Please could you help whether it be by VBA or SQL?

Form name is called Lc1_tbl
Field in table is L1 Reviewer
textbox on form is called tbfullname

Your help is greatly appreciated.

推荐答案

您是否有理由不希望表格绑定到表格，这样就不会有任何代码是否有必要将表格中的数据输入表格？

Is there a reason that you don''t want the form bound to the table, which would make it so that no code is necessary to enter the data from the form into the table?

感谢您的回复..


我的表达式附加了2个这些文本框似乎不可能将这些绑定到表格。


一个表达式使用fOSusername（）函数，另一个表达式是日期

Thanks for the reply..

I have expressions attached to some 2 of the text boxes so it doesn''t seem possible to have these bound to the table.

One expression uses the fOSusername() function and the other is the date

将表达式放在默认值属性而不是控件源属性中。

Put the expressions in the Default value property instead of the control source property.

这篇关于将表格数据输入表格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！