ms access 通过 Access 表单添加、编辑、删除项目

发布于 2024-08-06 09:38:38 字数 236 浏览 11 评论 0原文

我不太熟悉通过表单输入数据。到目前为止,我只是处理表中的数据。但是,现在我有一个包含两条信息的表:
群组 ID
每个ID都在一个组中,并不是所有的ID都在表中表示(即还有另一个表有完整的ID列表...多对一),并且多个ID可以与同一个组关联。
我想制作一个表单,允许用户添加新的 ID/组行、编辑现有 ID 的“组”以及删除现有行。我希望用户看到他/她所做的更改。我认为有一种方法可以将表格的快照显示为表单的一部分?我该如何做这一切?

I'm not real familiar with inputting data through forms. Up until now I've just been handling the data from the table. However, now I have a table with two pieces of information:
Group ID
Each ID is in a group, not all IDs are represented in the table (ie there is another table with a complete list of IDs...many to one), and multiple IDs can be associated with the same group.
I want to make a form that allows the user to add a new ID/group row, edit an existing ID's "Group," and delete an existing Row. I want the user to see the changes he/she has made. I think there's a way to show a snapshot of the table as part of the form? How do I do all this?

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(2

南城追梦 2024-08-13 09:38:38

您尝试过连续形式吗?如果需要,您可以使用组合来显示每个控件/字段的附加信息。

编辑评论

从您的评论和原始帖子来看,似乎适合的是主表单和子表单。子表单可以设置为防止编辑 - 它将显示现有的组。主窗体将包含您的组合和按钮。

对于各种类型的表单,查看表单的 ViewsAllowed 属性,您会发现:

  • Single Form(适合主表单)
  • Continuous Form(适合子表单)
  • Datasheet

Have you tried a continuous form? You can use a combo to display additional information for each control/field, if that is required.

EDIT re Comment

From your comments and original post, it seems that what may suit is a main form and subform. The subform can be set to prevent editing - it will display the existing groups. The main form will have your combos and buttons.

As to the various types of form, look at the Views Allowed property for the form, you will find:

  • Single Form (suitable for main form)
  • Continuous Form (suitable for subform)
  • Datasheet
耶耶耶 2024-08-13 09:38:38

将一个表(或查询)链接到主窗体,将第二个表(或查询)链接到子窗体。将子表单拖到主表单上。在链接主字段下的属性(子表单)中将两个表单绑定在一起,并添加密钥 ID 链接子字段。

Link one table (or query) to the main form and your second table (or query) to a sub form. Drag your sub form onto the main form. Tie the two forms together in properties (sub form) under link master fields and link child fields add the key ID.

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文