Can I backup my VBA code?

=========
QUESTION
———
I have been having a lot of trouble lately with my Microsoft Access database files being corrupted and losing all of my code.
(a sometimes fix for this: http://www.anysitesupport.com/error-microsoft-access-has-stopped-working/)

The scary thing is even when I attempt to open the backups, they may work, but the code still disappears!

Is there a way to backup the VBA code from my projects in addition to the file itself?

 

=========
ANSWER
———
Yes –

From the code window (Ctrl + G is the shortcut), go to File, Export.

It saves as a .CLS file, but that can easily be viewed as a plain txt file.

 

=========
EXAMPLES
———
see ANSWER

 

=========
APPLIES TO / KEY WORDS
———
Microsoft Access
VBA
Code Backup
How do I backup my VBA Code

 

=========
REF
———

 


http://www.anysitesupport.com/can-i-backup-my-vba-code/
http://anySiteHosting.com

By | 2017-12-01T23:47:35+00:00 October 26th, 2011|Access, Computers, Documentation, Microsoft, VBA|0 Comments