suddenly unable to make any design changes to more than one forms in my .accdb

[lweis]

db has been used daily for 2+ years; db has been compacted/repaired; no locks on db; user is admin; can't import or export affected forms to/from a new blank db; can't rename the forms; only errors are attached and occur when I try to import forms into a blank db. All other access object will import except for a handful of forms. Worked with access intermittently or 12+ years and have never seen this

[rpeare]

I have seen this before, at least twice.

one time I had a duplicate public function declared
one time I had to re-import all objects into a blank database

have you got public functions declared in your database?

[lweis]

not that I am aware....are you talking about digital certificates?

[lweis]

it's not all forms that I can't make design changes to, just a small select number.....these are then the forms that I can't import, export, or rename

[rpeare]

No, I'm not talking about digital certificates.

If you designed this database you should know though. Any time you do something like click a button to perform an action you have an event (ON CLICK event for example) if you are running vba in any of these events and you have a public function name that conflicts with any other function name you can get this error

for instance if you had something like

Private Sub cmdButton_Click()
dim sTest

sTest = getmessage

End sub

Private Function GetMessage()
GetMessage = "OMG THIS IS MY MESSAGE"
End Function

on one of your forms, but then you had a public function

Public Function GetMessage()
GetMessage = "THIS IS AN ENTIRELY DIFFERENT MESSAGE"
End Function

the two functions have the same name which can cause the error you're getting.

If you did not design the database I would encourage you to go through the code for each object (form, report, module) and search for duplicate function names.

If that yields no results I would attempt importing the objects 1 at a time into a blank database until you get an error, that might give you the object that has the offending code.

[lweis]

I did not design.....I will search code for duplicate function names. Have already tried one-at-a-time import into blank db and I am getting the error on 8 different forms. Thanks for the help

[rpeare]

once you hit a problem form try creating another blank database and importing 1 and only one of those problem objects too. No forms/modules nothing, just the object causing the problem.

[lweis]

The name Command2 was showing up repeatedly across the offending forms.....after changing code to a unique name, the form became editable/importable/exportable again. Can't figure out how the name became duplicated across so many forms. It was not designed that way and db has been functioning without fault for years. Thanks again