删除表单上的多个记录 [英] Delete Multiple Records On A Form

问题描述

我有一个现有的库存数据库，我正在尝试对其进行更改。数据库只有1个表，其中包含以下字段：


PartNumber

ItemDescription

类别

位置

所有者

SerialNumber。


目前我正在使用删除按钮删除单个项目。

I have an existing inventory database that I''m trying to make changes to. The database only has 1 table with the following fields:

PartNumber
ItemDescription
Category
Location
Owner
SerialNumber.

Currently I''m using the delete button to delete a single item.

展开 | 选择 | Wrap | 行号

推荐答案

嗨男人


我想你必须将所有数据放在rercodset中并检查它。

Hi man

I think you have to put all your data in rercodset and check it.

展开 | 选择 < span class =codeDivider> | Wrap | 行号

感谢您的快速回复。我把代码放进去，但是我在Dim db As Database中得到了一个编译错误（编译错误：未定义用户定义的类型）。我查了一下？CurrentProject.Connection，它返回了Provider = Microsoft.ACE.OLEDB.12.0。我也试过DAO.Database和DAO.Recordset但我仍然得到同样的错误。


谢谢，


Kevin

Hi,

Thanks for the fast response. I put the code in but I get a compile error at ''Dim db As Database'' (Compile error: user-defined type not defined). I checked ?CurrentProject.Connection and it came back with Provider=Microsoft.ACE.OLEDB.12.0. I also tried DAO.Database and DAO.Recordset but I still get the same error.

Thanks,

Kevin

感谢您的快速回复。我把代码放进去，但是我在Dim db As Database中得到了一个编译错误（编译错误：未定义用户定义的类型）。我查了一下？CurrentProject.Connection，它返回了Provider = Microsoft.ACE.OLEDB.12.0。我也试过DAO.Database和DAO.Recordset但我仍然得到同样的错误。


谢谢，


Kevin

Hi,

Thanks for the fast response. I put the code in but I get a compile error at ''Dim db As Database'' (Compile error: user-defined type not defined). I checked ?CurrentProject.Connection and it came back with Provider=Microsoft.ACE.OLEDB.12.0. I also tried DAO.Database and DAO.Recordset but I still get the same error.

Thanks,

Kevin

您没有Microsoft DAO对象库的参考集。

You don''t have the reference set for Microsoft DAO Object Library.

这篇关于删除表单上的多个记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！