用于将数据输入链接表的表单 [英] Form for entering data into linked Table

问题描述

我有一个名为dbo_tblNotes的链接表。


dbo_tblNotes包含以下字段：


id（数据类型=数字，索引=否）

note（数据类型=备忘录）

addDate（数据类型=日期/时间）

uid（数据类型=文字）

私人（数据类型=数字）


我正在尝试创建一个可用于输入注释和注释的表单。输入的任何注释都将存储在dbo_tblNotes中。在注释下的表格领域。我只希望表单用于输入或更改备注。我尝试过根据dbo_tblNotes创建一个表单。表但我无法在Notes中输入任何内容。它仅显示每条记录的注释。


任何帮助将不胜感激。在此先感谢。

I have a linked table called "dbo_tblNotes".

dbo_tblNotes has the following fields:

id (Data Type = Number, Indexed = No)
note (Data Type = Memo)
addDate (Data Type = Date/Time)
uid (Data Type = Text)
private (Data Type = Number)

I am trying to create a form that I can use to enter notes and comments. Any notes that are entered would be stored in the "dbo_tblNotes" table under the "note" field. I only want the form to be used for entering or changing notes. I have tried creating a form based on the "dbo_tblNotes" table but I am unable to enter anything into Notes. It only displays the notes for each record.

Any help would be greatly appreciated. Thanks in advance.

推荐答案

您需要确保基础记录集是可更新的，并确保 AllowAdditions 设置为 True 。

You need to make sure the underlying recordset is updatable and ensure AllowAdditions is set to True.

还必须将 AllowEdits 设置为true。

Also AllowEdits must be set to true.

AllowAdditions 是否已找到在表单属性下？


在表单属性下找到 AllowEdits ？

Is AllowAdditions found under the forms properties?

Is AllowEdits found under the forms properties?

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