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

DoCmd.RunCommand acCmdDeleteRecord Problem in A2007

P: n/a
I've noticed a behaviour in A2007 that doesn't appear in A2003. The
problem is appearing in a native A2007 database and an A2003 database
running in A2007. If I press a command button to delete a record on a
single form using DoCmd.RunCommand acCmdDeleteRecord as the code
behind the button, when I close that form Access asks me if I want to
save the changes to the form.

This only happens if the database is an mdb or accdb. If it has been
compiled into an mde or accde the problem doesn't manifest. Why would
this be happening?
Mar 7 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a
ARC
I've seen this a lot in a2007. It does not happen in a .accdr file, by the
way. I had to change lots of code on my close commands, where I first do a
save record, then I do a:

docmd.close acForm, "FormName",acSaveNo

Then the message doesn't appear. However, if you have subforms, you'll get
save messages for the subforms as well. So I made a blank subform, and prior
to the docmd.close statement, I'll put something like:

forms!Customer!subform.sourceobject = "subBlank", where subBlank is the
blank subform. Not sure why access 2007 does this, however.

Andy
"Wayne" <cq*******@volcanomail.comwrote in message
news:69**********************************@s13g2000 prd.googlegroups.com...
I've noticed a behaviour in A2007 that doesn't appear in A2003. The
problem is appearing in a native A2007 database and an A2003 database
running in A2007. If I press a command button to delete a record on a
single form using DoCmd.RunCommand acCmdDeleteRecord as the code
behind the button, when I close that form Access asks me if I want to
save the changes to the form.

This only happens if the database is an mdb or accdb. If it has been
compiled into an mde or accde the problem doesn't manifest. Why would
this be happening?
Mar 7 '08 #2

P: n/a
On Mar 8, 9:11*am, "ARC" <PCES...@PCESoft.invalidwrote:
I've seen this a lot in a2007. It does not happen in a .accdr file, by the
way. I had to change lots of code on my close commands, where I first do a
save record, then I do a:

docmd.close acForm, "FormName",acSaveNo
Thanks.
Mar 8 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.