Forum Discussion
Form button has to be recreated every time Access closes and is reopened
I have a frustrating problem with a data entry form I created in my Access database. I created a button on the form (using one of the Form Design controls) that duplicates the current record every ti...
My opinion: NEVER EVER USE MACROS, they are an invention of the Devil! Write VBA code, which can be easily edited, modified, debugged, error trapped, etc. You can even save working VBA code into text files so they don't disappear if your database ever gets corrupted or deleted.
If you have a goofy form in your database, try creating a new empty ACCDB file and importing all the forms, tables, queries, code, etc, into it. Sometimes MS Access files get corrupted (ok, they get corrupted a lot), and occasional the only fix is to start with a whole new fresh container. And make backups all the time! I do it several times a day when I'm in heavy development mode so i don't lose my work if Access goes crazy. Which it will do.
If you have a goofy form in your database, try creating a new empty ACCDB file and importing all the forms, tables, queries, code, etc, into it. Sometimes MS Access files get corrupted (ok, they get corrupted a lot), and occasional the only fix is to start with a whole new fresh container. And make backups all the time! I do it several times a day when I'm in heavy development mode so i don't lose my work if Access goes crazy. Which it will do.