After I've taken a course I like to copy all the objects within that DataBase to my own database, rename each object to reflect my naming convention and see if I can reproduce the same results.
Most of the time, this works fine but every once in a while odd things happen. The first indicator is usually an error message saying 'Variable not defined' then the object in question is a Form.
Are there cautions I should be observing when I rename and copy Forms or Reports?
Matt Hall
@Reply 55 days ago
Any VBA that refers to one of the old object or control names will need to be updated to reflect the new names. Otherwise, it may assume that the old name is an variable that you forgot to declare.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 25.
