Large no of Files are Being Created after Compiling the Project

[abdullah1038]

Hello,

I don't know it's with me or anyone notices too, large no of files are being created even if a single file is changed after compiling (Debig>>Compile). Is there a way to get only those files which are actually modified?

Best Regards Abdullah

[hecon5]

Hi, do you mean they're created after you export?

The VCS will export all modified files from the Access Database. Oftentimes, if you do "Debug/Compile" (or especially if you do "Compact>Repair"), the VBA IDE will "helpfully" recapitalize routine, function names, variables, etc.

Additionally, if you have Access 2013+, when you export forms the colors may change (apparently randomly) from export to export. This is partially due to how Access's internals are handling it, partially due to your OS's color settings, and how they interact with each-other.

It's a really annoying bug "feature, and one that plagues me, too.

[abdullah1038]

Thanks for reply. Yeah differences show only colors changed and also left/top or height width changes. So, I guess there is no way to get rid of this feature.

Regards

On Fri, May 21, 2021, 18:32 hecon5 @.***> wrote:

Hi, do you mean they're created after you export?

The VCS will export all modified files from the Access Database. Oftentimes, if you do "Debug/Compile" (or especially if you do "Compact>Repair"), the VBA IDE will "helpfully" recapitalize routine, function names, variables, etc.

Additionally, if you have Access 2013+, when you export forms the colors may change (apparently randomly) from export to export. This is partially due to how Access's internals are handling it, partially due to your OS's color settings, and how they interact with each-other.

It's a really annoying bug "feature, and one that plagues me, too.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/joyfullservice/msaccess-vcs-integration/issues/227#issuecomment-845952647, or unsubscribe https://github.com/notifications/unsubscribe-auth/AS7C36IBI3UMOOPFMB7ARLTTOZOGXANCNFSM45JAWPKA .

[hecon5]

There is...if you don't open them between exports. But...that's impractical, obviously.

I've been trying to figure out how to eliminate those changes, especially for forms that are dynamically colored/adjusted/generated where the "base" color makes no difference (or where I've used a theme to define the color), but I'm coming up short.

I was thinking of adding an RD flag, and adding a specialized sanitize routine to "revert" color changes, but I've got so much other stuff on my plate right now, it's just a theory banging around in my head at the moment.

[hecon5]

Since there's nothing we can do about this irritation for now except interrupt the IDE which is far outside the scope of the Addin's purpose, I'd suggest putting this under "Access Bug/Can'tFix".

[abdullah1038]

Yeah sure. Put it under Access Bugs /Can't solve. I was thinking that there is something that I might be doing wrong so it is now clear.

Thanks and regards. Abdullah

On Fri, May 21, 2021, 18:51 hecon5 @.***> wrote:

Since there's nothing we can do about this irritation for now except interrupt the IDE which is far outside the scope of the Addin's purpose, I'd suggest putting this under "Access Bug/Can'tFix".

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/joyfullservice/msaccess-vcs-integration/issues/227#issuecomment-845964822, or unsubscribe https://github.com/notifications/unsubscribe-auth/AS7C36JYLTBAGS5T6E2NGM3TOZQNFANCNFSM45JAWPKA .

[hecon5]

You're doing it correctly; I, too, wish this wasn't how it worked :/

[abdullah1038]

You said if I don't open then between exports then these will not be generated but for me these are. I did export and then imported a module into my project from another project and then use debug/compile and then exported again, there were 93 files (including one newly added module).

On Fri, May 21, 2021, 19:29 hecon5 @.***> wrote:

You're doing it correctly; I, too, wish this wasn't how it worked :/

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/joyfullservice/msaccess-vcs-integration/issues/227#issuecomment-845989447, or unsubscribe https://github.com/notifications/unsubscribe-auth/AS7C36K5BVEBWIPYQVMFD7LTOZU3RANCNFSM45JAWPKA .

[hecon5]

Can you attach a screenshot of what's changing? Perhaps we're discussing different nuances?

An example of what I'm talking about on a form:

[abdullah1038]

These are images from 10 different forms. Please notice, some command is deleted and the same is added again.

On Fri, May 21, 2021, 19:42 hecon5 @.***> wrote:

Can you attach a screenshot of what's changing? Perhaps we're discussing different nuances?

An example of what I'm talking about on a form: [image: image] https://user-images.githubusercontent.com/54177882/119155264-fcec5a80-ba20-11eb-9881-90509e55c2fb.png

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/joyfullservice/msaccess-vcs-integration/issues/227#issuecomment-846000768, or unsubscribe https://github.com/notifications/unsubscribe-auth/AS7C36J3KYNE6FYHXNVH62DTOZWNHANCNFSM45JAWPKA .

[abdullah1038]

[hecon5]

yup, those are VBA's IDE "help".

From your last image, notice the case change on line 71: .Close changed to .close (C => c). Irksome, and adds noise to git, but it's IDE's fault.

There's nothing to do about that, they'll change at random, sometimes they'll stay the same for a while and then strike when you least expect it. Think of it as Monty Python's "Spanish Inquisition": they're fools, they show up randomly, they are definitely not helping you, but they're not "hurting" you either ("NOT THE COMFY CHAIR!").

It's likely you never noticed this before you had a decent VCS (I didn't), but I started noticing it as soon as I started using git and diff tools (several years now, and consistent across all VCS's I've used (hand-built one, the "legacy" version of this Addin, and the addin now).

[abdullah1038]

So nice of you. I had been seeing these from start but lately they increased in number so I asked. Thanks a lot.

On Fri, May 21, 2021, 21:46 hecon5 @.***> wrote:

yup, those are VBA's IDE "help".

There's nothing to do about that, they'll change at random, sometimes they'll stay the same for a while and then strike when you least expect it. Think of it as Monty Python's "Spanish Inquisition": they're fools, they show up randomly, they are definitely not helping you, but they're not "hurting" you either ("NOT THE COMFY CHAIR!").

It's likely you never noticed this before you had a decent VCS (I didn't), but I started noticing it as soon as I started using git and diff tools (several years now, and consistent across all VCS's I've used (hand-built one, the "legacy" version of this Addin, and the addin now).

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/joyfullservice/msaccess-vcs-integration/issues/227#issuecomment-846097106, or unsubscribe https://github.com/notifications/unsubscribe-auth/AS7C36MO2UFTO7X2MU52OBDTO2E5DANCNFSM45JAWPKA .

[joyfullservice]

For more discussion on changes in color values, see #183 I have recently added a FAQ page to the project wiki where some of the other reasons are outlined.

I will go ahead and close this issue out, since the underlying issues are documented elsewhere. Thank you all for the input! 😄