DD's Stats

Total Members: 114
Latest: kokowawa0100@yahoo.com
New This Month: 8
New This Week: 0
New Today: 0
Total Posts: 727
Total Topics: 351
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: 754
Posts: 51
Posts: 12
Posts: 8
Posts: 8
Posts: 5
Posts: 5

Author Topic: User Manual  (Read 178 times)

0 Members and 0 Guests are viewing this topic.

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 754
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 15
User Manual
« on: March 16, 2019, 05:30:48 pm »
Gobal Features
  • Once you have used one search screen then you will be able to use all as they are all designed arount the same templete just each has different option
  • As with the Search screen once you have used A Print screen you should be able to use all others
  • This program has been designed for household use and as such has not been designed with servers in mind
  • Main sections are Accounts, Works Costings and Household Inventory this will be explained in other posts
  • As this is designed as a personal accounts and not a bussiness system only 10 reports have been provided but all these can be filtered which gives them a massive amount of scope
  • Over 100 default chart or accounts will be included
  • This program is also used by me to help keep track of my accounts,I hope you find in as helpful as me
  • The search/Print screens will not be covered as these are objects that you can experiment with without causing any damage to your data

Login Name: Admin
Password: Admin

You will See the screen below after loggin in


You should add your bank accounts plus a cash account as below
As you can see there is a default GL Account Attached To this bank called cash you should attach  a chart of accounts account to all banks these should be on an asset type or sub account of an asset type.

These are added by clicking the button next to the Defaullt GL Account which will diplay the following screen.
I will include a cash bank account along with the other chart or accounts included.

Adding any chart of accounts account can be done in the same way all you need do is add a Name, Description (This should be kept brief) then you should select the type of account Aset, Income or expence that relates to your account, should you wish to add your new account as a sub account click the sub account label then select a main account from the list as below:


« Last Edit: March 24, 2019, 09:56:58 am by Michael »

Share on Facebook Share on Twitter

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 754
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 15
Re: User Manual
« Reply #1 on: March 22, 2019, 05:17:07 pm »
So to add you own bank account add the details then select or add an asset type account as in Image below:

As you can see there are a number of bank accounts attached to the chart of accounts to add a new one add the details like in image 2 above including the openning balance this should be you current bank balance ofter any purchases have been been added to the account.

Adding users and passwords


when you add a new users name the password entry screen will open allowing you to add a password then click save password
The password will only prevent others from accessing the program, it is not used to record who did what.

should you wish to change a password click the button next to the name to be edited then follow same procedure as above.

« Last Edit: March 22, 2019, 05:50:27 pm by Michael »

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 754
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 15
Re: User Manual
« Reply #2 on: March 22, 2019, 05:57:11 pm »

Customers are people or bussiness like your employer who will make payments to you.
Add the details like below image as a minimum you should add a name but the more you can add the better.

To go to a new line in the address box use [CTRL] + Enter

Suppliers are places you spend money you only need to add a supplier name and it is recormended you add a default account this will speed up bills entries wihich will be covered later.

follow the same process as you did for adding bank default GL Accounts but select an expns type or subtype
« Last Edit: May 26, 2019, 07:14:09 pm by Michael »

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 754
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 15
Re: User Manual
« Reply #3 on: March 23, 2019, 08:43:16 am »

To Add Bills you first need to add or select a supplier, You can either select a supplier from the list or a new supplier can be added though the dropdown list of supplers by adding their name as in image below (NOTE You can add new suppliers/customers the same way with other dropdown lists)

In the image below I have added a new suppler to the dropdown list called "Test"

Once you click enter or tab to go to the next field the message below will be displayed

Clicking yes will display the supplier entry screen with your new suppliers details allowing you to add any other details you have and attach a default Account as below

Note you can add as many supplers to this screen as you want you will see the navigation buttons in the image below clicking the furthest right button will allow you to add another supplier name etc.

Now you can add the Bill Date, Total Amount and a short description

« Last Edit: March 23, 2019, 08:45:59 am by Michael »

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 754
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 15
Re: User Manual
« Reply #4 on: March 24, 2019, 10:19:37 am »
Now you have added the main bill details you should add the Bill general Ledger Item(s)


You can add as many GL items as required but you will notice two boxes to the middle right called GL Total and Account Total these both have to turn green before you can post the bill so if you are adding more than one GL item View Image below to see how Multiple GL Items Can be added


As you can see GL And Account Totals are green as all "THREE" values are the same.

TIP: once you have added your item(s) to the General Ledger you can TAB to a new entry but I find it works better clicking a new entry this will then turn the totals colours green or red, same will work for the payments list.
« Last Edit: March 24, 2019, 03:58:49 pm by Michael »

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 754
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 15
Re: User Manual
« Reply #5 on: April 05, 2019, 03:15:20 pm »
Scheduled Payments
The scheduled Payments list shows all payments Showing payments closest to payment date at the top of the list.
The list can be filtered buy Schedule "All", "Monthly" or "Yearly" And  by the bank account by secting items form one or both lists.
Their are three buttons to the left og each shedule these are
  • Delete: this will delete the schedule it cannot be recovered after deleting
  • View/Edit Schedule: this will open a screen so you can edit that scheduled Item this screen will be overed below the list image
  • Pay Item: use this to make a payment, depending on the settings it may open the edit screen this will be covered below.

Most details are obvious But there are 2 very important settings that you should make note of.

Irregular first payment: if you tick this once you make the first payment the edit screen will open AFTER THE PAYMENT HAS BEEN MADE allowing you to edit the payment amount

Varible amounts: Will open the edit screen BEFORE THE PAYMENT HAS BEEN MADE Allowing the payment to be edited for that payment

Payment Date: this is the next date the payment is due

Payments: Add 999 for continuous or the number of payments required

# Payed is a system item

Note: the pay amount and the total payments must =

Add the pay expense account(s) like you would with the bills

If the scedule has any free months those months will be missed and the next payment date will be moved forward by the total number of free months


The works costing is a simple tool I built to help me cost different jobs from deacorating to building a gym in my case I included it as I thought it might be of us to some.

  • Enter a name for the works
  • Select or add an item to the Item Type List You can double click the list to display the list editor
  • Add a name for the item
  • Select or add a supplier
  • Add a website if needed you can link to an item on a site use the world button to go to that page
  • The cost, Qty and del are used to calculate the Line amount
  • Click Done if you have obtained the item
  • Add the final cost this has beed added so you can look for better deals


You should now have all the information you need to use this object as it uses the same techniques as all other objects
« Last Edit: April 06, 2019, 10:01:16 am by Michael »


Related Topics

  Subject / Started by Replies Last post
9 Replies
Last post June 15, 2019, 08:34:21 pm
by DD Admin
0 Replies
Last post June 29, 2019, 07:34:33 pm
by DD Admin
0 Replies
Last post November 02, 2019, 10:48:54 am
by DD Admin
1 Replies
Last post April 02, 2020, 09:47:56 pm
by DD Admin
0 Replies
Last post April 28, 2020, 01:56:23 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

Member Examples

Recent Topics

DJ 2020 Project Status by DD Admin
September 22, 2020, 10:45:01 pm

UK Singles/Albums Charts 11 Sep 2020 to 17 Sep 2020 Analysis by borobutch
September 22, 2020, 12:58:29 pm

UK Singles/Albums Charts 04 Sep 2020 to 10 Sep 2020 Analysis by borobutch
September 20, 2020, 07:17:30 pm

New Badge Added by DD Admin
September 19, 2020, 04:02:54 pm

Please welcome kokowawa0100@yahoo.com to DD by DD Admin
September 19, 2020, 03:03:34 am

Please welcome lookforsmt to DD by DD Admin
September 18, 2020, 08:14:13 am

Please welcome dennisbowman to DD by DD Admin
September 15, 2020, 02:34:01 am

Database Dreams is not affiliated with Microsoft