(https://databasedreams.createaforum.com/index.php?action=dlattach;topic=259.0;attach=1605;image)
Thanks to crystal from ms access gurus (http://msaccessgurus.com/index.htm) For all her help
Important locations
These Are the locations on my systems yours may be different, I have created shotcuts to mine
Location Of ACCESS.EXE For Office 365
C:\Program Files (x86)\Microsoft Office\root\Office16
Location Of Your Access Addins Folder Replace user for your system user name
C:\Users\USER\AppData\Roaming\Microsoft\AddIns
Installing DD's Code Library as A Addin
- Unzip The folder to the location you wish it.
- Open The Addin "Addin_ DD_Code Library.accda"
- If you have not Unzipped to C:\ the link managaer will start and display the new location request screen select the file "Code Library Data.accdb" In the DD's Code Library Main Folder Then click reconnect
- Open The Preferences screen "Button on the Code Window" And update the Main Folder Location This is only used for the style manager Images at present
- Close DD's Code Library "I normally close all open Access apps"
- Find Your ACCESS.EXE Right click it and Click Run As Administrator once open Select any Access accdb Database
- Open The Database Tools Menu And on the far right you will see the addins click that then select Addin manager, Select Add New Browse to the location of DD's Code Library Folder and select "Addin_ DD_Code Library.accda" then click open you will see the list update and under it text will be added with information.
- Click close and then you should see DD Code Library in the list when you click the addin Option Again you can now run it
- The First Screen you will see is the splash screen looking like the one at the very top of this page
I was going to add a detailed description but Don't think that is really needed as All my Programs use wysiwug
There is only one issue you should Take note of that is when you click Dflt Comments the comments on the preferences screen will be copied to the clip board DO NOT CLICK THE BUTTON PAST this will replace your code for the comments as it is designed so you can copy from your code from another location then past it all in.
To past your comments click the beginning of the line you wish the comments to be added then right click and select past.
I did try coding a sullution but I couldn't get it working well enough for me to feel happy including it but I may add it to a later version along with other items as I have allowed for a few future updates in the tables.
If you would like to create you own addins then I would recommend you watch this Video from Crystal
https://www.youtube.com/watch?v=ljV2vx_r-Bo&t=90s