By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,694 Members | 2,122 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,694 IT Pros & Developers. It's quick & easy.

Wierd Access behavior while deleting a record

P: n/a
Access XP
Windows XP

This code has been working for over 5 years with no problems and all
of a sudden I am running into these wierd problems.

I have this code to delete a record.
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70
I am getting error 2465.
Sometimes the above code deletes the record the 3rd time I click the
button, the first 2 times i get 2465.

I changed the code to
DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdDeleteRecord
and I am getting 2046 and 2455 errors

I dont know if I am missing a reference. Here are all the references I
have
Visual Basic for Applications
Microsft Access 10.0 Object Library
Microsoft DAO 3.6 Object Library
Microsoft Visual Basic for applications Extensibility 5.3
OLE Automation

Have a nice weekend.

-Niranjan
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.