Microsoft Access 2007 Inexplicable issues
Posted on 2014-10-04
This morning I began working on an existing application and noticed some bizarre behavior that I didn't see yesterday. I tried to repair the Office installation and then decided to uninstall, reinstall, download and update any needed updates but the issues persist.
Here are some examples of what I'm experiencing:
1. In the OnOpen event of a form I go to new record (DoCmd.GoToRecord , , acNewRec) and the form opens with the autonumber showing (New) as it should but the bound form data -- is from the last record in the table. Wasn't doing that yesterday??
2. DoCmd.ShowToolbar "Ribbon", acToolbarYes -- suddenly no longer works. I have no idea if I need a reference for that to work.
Any ideas? I'm stumped.