Transferring VBA functions from one database to another?

[hlcarlin]

Hey,

I just had some sort of critical error while loading my database and I seem to have lost all VBA functions that were programmed and made the forms I had function properly. I have not lost any tables, queries, forms or reports, simply the code that powers form buttons.

I have these VBA functions backed up on another (much older) version of the database I am working on and was wondering if there is a way I can export all of them to the newer version of my database?

Thank you

[RuralGuy]

Start by *importing* everything into a fresh new db and see if the problem follows: http://www.btabdevelopment.com/ts/impnew

[hlcarlin]

Hello and thank you for your reply.

I have tried doing what you recommended and everything works as it did on the file I have but the action buttons remain non-functional. When I right click on one and select Build Event, Microsoft Visual Basic opens up and the function is empty as opposed to my backup file where the function is still there and the buttons work properly.

[RuralGuy]

You should be able to *import* the form from a prior backup.

[hlcarlin]

yes I believe that is the best solution thank you very much!

[RuralGuy]

You can also open both db's and copy and paste the Form's Class code if you want. You may then need to go through the Ecent tab and put in the [Event Procedure] to activate the code.