I am in the process of creating a utility for work based on MS Access. The only problem I have as it will not be supported by my companies IT department, it will have to supported by my team and I'm the only one in my team who has VBA programming experience. The only way I think I can get round this is by the following:
- Fully comment the code
- Write documenation explaining what each function does
- Put all non-form based VBA code into seperate modules
- Use fully descriptive variables
Hopefully with some of my colleagues can pick up some programming experience and be able to help me support it although to be honest once I get it up and running, there shouldn't be any need for maintanance once it is working. Does anybody have any ideas or tips to make MS Access VBA code easier to understand for people who have little programming experience?