AccessUserGroups.org launched a new tool that will convert your Access queries over to TSQL. If you specialize in converting Access to SQL Server, this tool will be a real time saver! But it gets better with the ability to also create a string you can paste into your code. Juan Soto of AccessExperts has a great description at: https://accessusergroups.org/blog/accesssqltool/
Please note it’s still in BETA and we are looking for feedback, which you can provide by clicking on the feedback button. Read the post and head on over to the tool to learn more!
If you on a form decide to move some controls into a tab control, you normally do a cut and paste of these controls - from the form into a page of the tab control. Then all the events of the controls get cleared; the [Event Procedure] markings are gone and the code behind is detached though still present.
To restore these settings, open the code module of the form. Then do:
Mark all code with Ctrl+A
Cut it away with Ctrl-X
Select menu Debug, Compile
Paste all the code back into the empty module with Ctrl-V