转换访问2000时 - > 97我的addnew不会工作 [英] When converting access 2000 --> 97 my addnew wont work
问题描述
嗨我知道这看起来很怪异我在2000年完成了一个数据库所有工作都比我必须将它转换为97.我不得不重做我的所有代码，但是当OnOpen运行时我无法重新获得表单只是赢了，除了它
在访问2000我所需要的只是recordset.addnew你如何在97中做到这一点???
谢谢你的帮助
Hi i Know this looks weird by i done a database in 2000 all worked well than i had to convert it to 97. I had to redo all my code that was fine but i can not get the form to addnew when OnOpen runs just won`t except it
In access 2000 all i needed was recordset.addnew how do you do this in 97 ???
Thankyou for any help
推荐答案
你使用什么库来访问Access 97.
你有没有检查过它的参考资料是否被添加了在VBA窗口？
What library are you using for Access 97.
Have you checked that it''s Reference has been added in the VBA window?
我知道这看起来很奇怪我在2000年完成了一个数据库所有工作都比我必须转换它到97.我不得不重做我所有的代码都没问题，但是当OnOpen运行时，我无法获得更新的表格除了它之外它是
在访问2000我只需要的是recordset.addnew你如何在97中做到这一点???
谢谢你的任何帮助
Hi i Know this looks weird by i done a database in 2000 all worked well than i had to convert it to 97. I had to redo all my code that was fine but i can not get the form to addnew when OnOpen runs just won`t except it
In access 2000 all i needed was recordset.addnew how do you do this in 97 ???
Thankyou for any help
你不应该重做所有代码。你是怎么做这个转换的。这样做的方法是在2000年转换为以前的版本。然后在''97中打开并允许它转换为当前版本。然后你应该打开vba编辑器并编译代码，并且正如Ade（NeoPa）所说你应该检查库列表中没有丢失的库。
Mary
You shouldn''t have had to redo all your code. How did you do the converstion. The way to do it is while in 2000 convert to previous version. Then open in ''97 and allow it to convert to current version. Then you should open the vba editor and compile the code and as Ade (NeoPa) says you should check that there are no missing libraries from the library list.
Mary
我的代码在那里，但似乎与97
Eg不相容。此错误，运行时错误''424''：
所需对象
[代码]
私有子Form_Open（取消整数）
Recordset.AddNew
结束子
[代码]
我找到了1（Microsoft Access 10.0对象库）丢失，因为名称与现有模块，项目或对象库冲突，因此不允许我将其放入。
有一个旧版本（Microsoft Access 8.0对象库） ）
如何解决？
My code is there but does not seem compatable with 97
Eg. this error, run time error ''424'':
Object Required
[code]
Private Sub Form_Open(Cancel As Integer)
Recordset.AddNew
End Sub
[code]
I Have Found 1 (Microsoft Access 10.0 Object Library) missing which won`t let me put it in because name conflicts with existing module,project,or object library.
There is one older version (Microsoft Access 8.0 Object Library)
how do i fix it??
这篇关于转换访问2000时 - > 97我的addnew不会工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
