DD's Stats

Members
Total Members: 137
Latest: cbou
New This Month: 9
New This Week: 0
New Today: 0
Stats
Total Posts: 797
Total Topics: 396
Most Online Today: 2
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: 815
borobutch
Posts: 60
Carol
Posts: 12
Ram
Posts: 8
Clarissa
Posts: 8
richardsoj
Posts: 5
ComputerTech
Posts: 5

Author Topic: Code Library Manual  (Read 76 times)

0 Members and 0 Guests are viewing this topic.

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 815
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 15
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
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

« Last Edit: July 19, 2020, 03:09:23 pm by DD Admin »

Share on Facebook Share on Twitter


 

Related Topics

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

DD's Downloads


Development Schedule

DD's Freeware

Chart Tracker Elite 32Bit

Chart Tracker Elite 64Bit

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

DJ 2020 Project Status by DD Admin
November 25, 2020, 06:58:40 pm

UK Singles/Albums Charts 13 Nov 2020 to 19 Nov 2020 Analysis by borobutch
November 24, 2020, 10:36:34 pm

DJ 2020 Manual: Financial System by DD Admin
November 19, 2020, 08:08:45 am

DJ 2020 Manual: Events by DD Admin
November 19, 2020, 08:05:33 am

DJ 2020 Manual: Bookings System by DD Admin
November 19, 2020, 08:04:45 am

DJ 2020 Manual: Music Player by DD Admin
November 19, 2020, 08:01:48 am

Please welcome cbou to DD by DD Admin
November 18, 2020, 09:07:15 am

Database Dreams is not affiliated with Microsoft