且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

无法添加新字段;在设计视图中添加新字段时,它不会更新

更新时间:2023-01-15 12:13:05

您运行的是什么版本的Access?您使用的是什么文件类型(mdb accdb mdr mde)?


表单的记录源是什么?


如果重新打开表格,是否已保存设计更改?

在第一句中,您声明无法添加新字段。在第二句中,你说在添加一个新字段后你找不到它。那是什么?
What version of Access are you running? What filetype (mdb accdb mdr mde) are you using?

What is the recordsource of the form?

If you reopen the table, have the design changes been saved?

In sentence one you state you cannot add a new field. In sentence two you state that after adding a new field you can''t find it. So which is it?


访问2007 ....

文件类型mdb

但是数据库是在访问之前创建的另外,我已经知道字段列表不用于创建数据库。


我最初的意思是,我无法在数据表视图中创建字段,(如同访问一样) 2007 ...你通常会得到一个添加新字段,以帮助你创建一个新的领域)但是如果我使用设计视图,我可以创建一个新字段。

当我在设计视图中创建一个字段时,它会在数据表视图中更新,但是在表单中看不到创建的字段(我希望用这些新字段更新现有表单)。
access 2007....
File Type mdb
But the database was created in access prior to 2003. Also, i have learnt that field lists were not used for creating the database.

What I meant initially was, I can not create fields in the datasheet view, (LIKE IN ACCESS 2007... YOU GENERALLY GET A ''ADD NEW FIELDS'' COLUMN TO HELP YOU CREATE A NEW FIELD) but I can create a new field if I use the design view.
When I create a field in the design view it gets updated in the data sheet view, however the created fields are not seen in the form (I wish to update an existing form with these new fields).


我可能错了,但我认为它必须是一个ACCDB文件,用于在数据表视图中添加字段。我总是以任何一种方式使用设计视图。


首先查看表单的记录源。您可能需要修改查询以将字段拉入表单记录集。从那里你需要添加一个控件,并将字段绑定到它。这通常可以通过从可用字段列表中拖放来完成(不确定它在2007年的名称,我使用的是2010年)
I could be wrong but I think it has to be a ACCDB file for adding fields while in datasheet view. I always use design view either way.

Start by looking at the recordsource of the form. You may need to modify a query to pull the field into the forms recordset. From there you will need to add a control, and bind the field to it. This can usually be done by drag-n-drop from a list of available fields (Not sure what its called in 2007, I use 2010)