DD's Stats

Total Members: 160
Latest: drakopp
New This Month: 10
New This Week: 3
New Today: 1
Total Posts: 888
Total Topics: 452
Most Online Today: 1
Most Online Ever: 52
(May 02, 2020, 05:24:19 pm)
Users Online
Members: 0
Guests: 1
Total: 1

Recommended Posts

DD Approved Members group Added by DD Admin
05-06-2020, 12:48:35

Posting Additions or alterations rules by DD Admin
27-02-2020, 10:33:01

A Trip Down Memory Lane by DD Admin
24-08-2019, 14:17:16

Todays Birthdays

DD's Top Posters

DD Admin
Posts: 923
Posts: 70
Posts: 12
Posts: 8
Posts: 8
Posts: 5
Posts: 5

Author Topic: Code Library Manual  (Read 94 times)

0 Members and 0 Guests are viewing this topic.

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 923
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 16
Code Library Manual
« on: April 25, 2020, 11:40:36 pm »

Thanks to crystal from ms access gurus 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

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

« Last Edit: December 24, 2020, 12:20:15 pm by DD Admin »

Share on Facebook Share on Twitter


Related Topics

  Subject / Started by Replies Last post
0 Replies
Last post April 17, 2020, 05:38:21 pm
by DD Admin
6 Replies
Last post April 25, 2020, 07:49:18 pm
by DD Admin
0 Replies
Last post April 25, 2020, 11:04:10 pm
by DD Admin
0 Replies
Last post April 26, 2020, 06:58:36 pm
by DD Admin
0 Replies
Last post April 27, 2020, 03:15:47 pm
by DD Admin

DD's Social Media

DD's Programs

Development Schedule

DD's Freeware


DJ 2020

Chart Tracker Elite

Works Manager

Contact Manager

Simple Home Accounts

Book Library

Picture Library

Project Manager (accde)

Developer Tools

Project Manager (accdb)

Style Manager

Code Library

Open Code Templates

Master Template

Task Management

Charitable Contributions

Bug Tracker Template

Time And Billing Template

Real Estate Template

Household Inventory V1

Open Code Examples

DD's Northwind V1

Employee Example V5

Grid Demo Example V1

Employee Example V4

Small Examples

Recent Topics

Apollo Project Status by DD Admin
January 20, 2021, 05:42:43 pm

Please welcome drakopp to DD by DD Admin
January 20, 2021, 03:06:42 pm

UK Singles/Albums Charts 08 Jan 2021 to 14 Jan 2021 Analysis by borobutch
January 20, 2021, 02:58:50 pm

Apollo Manual: Other Items by DD Admin
January 19, 2021, 09:46:46 am

Please welcome aaronsql2019@ to DD by DD Admin
January 18, 2021, 09:09:47 pm

Apollo Manual: Recordings by DD Admin
January 18, 2021, 01:40:58 pm

Apollo Manual: Preferences by DD Admin
January 18, 2021, 11:36:26 am

Database Dreams is not affiliated with Microsoft