VBA is case insensitive and as a result over time variable names can become mixed in the repository, but they are modified to a single capitalisation when imported into Access. To make it easier to bring all code modules in line, add an option to export code changes only ie. do not export changes to Form/Report layout (which may be different due to later Access versioning).
To achieve this add an option on the Options form and then when exporting Forms/Reports use the Layout taken from the stored file combined with the code generated by MS Access. For Modules simply output the code as normal.
VBA is case insensitive and as a result over time variable names can become mixed in the repository, but they are modified to a single capitalisation when imported into Access. To make it easier to bring all code modules in line, add an option to export code changes only ie. do not export changes to Form/Report layout (which may be different due to later Access versioning).
To achieve this add an option on the Options form and then when exporting Forms/Reports use the Layout taken from the stored file combined with the code generated by MS Access. For Modules simply output the code as normal.