嗨男人


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

Hi man

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

感谢您的快速回复。我把代码放进去，但是我在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.