I have been able to define user-defined properties and set their value and later use them to populate fields on reports and so on. It works very nicely.
However, I would like to be able to check for a specific user-defined property when a databse first starts up or create the property and set its value, but if it is not yet defined I get an error that says it is not a valid property. I set up an "on error" statement that then creates the property, but this does not always work because it says "Cannot append. An object with that name already exists in the collection."
Is it possible that I've named the property the same as a control or some other object and this is the conflict? I've also tried to first delete to property, but as you imagine, this didn't work so well either.
Is there any way I can list all of the object names and then track back to where the objects reside (i.e. in a Table, Form, Query, etc.) in an effort to deconflict the "object already exists" issue?
Any help you can give would be most appreciated!
However, I would like to be able to check for a specific user-defined property when a databse first starts up or create the property and set its value, but if it is not yet defined I get an error that says it is not a valid property. I set up an "on error" statement that then creates the property, but this does not always work because it says "Cannot append. An object with that name already exists in the collection."
Is it possible that I've named the property the same as a control or some other object and this is the conflict? I've also tried to first delete to property, but as you imagine, this didn't work so well either.
Is there any way I can list all of the object names and then track back to where the objects reside (i.e. in a Table, Form, Query, etc.) in an effort to deconflict the "object already exists" issue?
Any help you can give would be most appreciated!
