DJ 2020 Navigation


 Home Page

 Forum

 Gallery

 User Links

 Downloads


DD's Stats

Members
Total Members: 160
Latest: drakopp
New This Month: 10
New This Week: 3
New Today: 1
Stats
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
borobutch
Posts: 70
Carol
Posts: 12
Ram
Posts: 8
Clarissa
Posts: 8
richardsoj
Posts: 5
ComputerTech
Posts: 5

Author Topic: DJ 2020 Manual: Address Book  (Read 48 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
DJ 2020 Manual: Address Book
« on: August 28, 2020, 08:02:34 pm »
Please note this system uses the Style Manager I have shown some objects using different styles to give you an idear of what each style looks like

Address Book Entry Screen


Starting from top
  • Delete Customer Button: You can only Delete a customer who has not been used in the system
  • Search Button: This will open the search screen
  • Close Button:Closeing this screen will return you to the main control unless you have used a button or double clicked on the Customers Name in other objects

Main Form Controls
  • Customer #: This item is required and cannot be editited Once you add a customer Name the field will be updated from a function in ModCodeIDFunctions called GenCode
  • Entry Type: This item is required Select an item from the list  or add a new Entry Type into the list you will then be asked if you wish to add it, or you can Double Click the field to open the Entry Type Editor where you can add one or more items or delete any unused Entry Types
  • Customer Name: This item is required Enter the Customer name or the persons Name.
  • Address Line: This item is required Enter Key will add a new line
  • Town/City: This item is required Select an item from the list  or add a new town/city into the list you will then be asked if you wish to add it, or you can Double Click the field to open the town/City Editor where you can add one or more items or delete any unused Towns/Cities
  • Region: Select an item from the list  or add a new Region into the list you will then be asked if you wish to add it, or you can Double Click the field to open the Region Editor where you can add one or more items or delete any unused Region
  • Country: Select an item from the list  or add a new country into the list you will then be asked if you wish to add it, or you can Double Click the field to open the country Editor where you can add one or more items or delete an unused countries
  • Postcode: This item is required This uses a postcode format function fValidUKPostcode I have set it so if you add a number or a zip code containing a "-" These will disable the uk postcode chacker
  • Email Address: Add an email address if known, If you have added a email address you can use the button next the the field to open you default email program and create a blank message setup for the address in the field
  • Website: add a website if known, If you have added a Website you can use the button next to the field to open your default browser and navigate to the website.
  • Company Type: Select an item from the list  or add a new Company Type into the list you will then be asked if you wish to add it, or you can Double Click the field to open the Company Type Editor where you can add one or more items or delete any unused Company Types
  • Short Notes: You can only add comments upto 255 characters long

Contacts List
  • Delete Button: Ths will give a warning then remove the contact
  • Phone Button:This will open the autodialer with the number displayed Note: You will need to setup the autodialer to be able to make use of it.
  • Phone Type: Select an item from the list  or add a new Phone Type into the list you will then be asked if you wish to add it, or you can Double Click the field to open the Phone Type Editor where you can add one or more items or delete an unused phone Type
  • Contact: This is the name of the contact
  • Number:enter the full number including country code if outside your country code

The Attaching Files
Starting from Left
  • Delete File Button: You can Delete any file record NOTE: this will not delete the file stored on your computer or server
  • Add File: This will open a dialog where you can navigate to your file and select it
  • View File Button:This will open any attached file if it has a valid path "I.E. it has not been moved or deleted.
  • You cannot edit the File Name, Type or Added by, these are all created from functions or links in the query

Function Rooms
These values can be Feet or metres
You can only enter numbers and a . into the Weight, Height and Depth fields and numbers into the capacity field
  • Room Name: Required What is the room called If there is no name the you can give ityour own name
  • Stage Width: Whats The Width Available
  • Stage Height: Whats The Height Available
  • Stage Depth: Whats The Depth Available
  • Capacity: How many can this venue room hold

The search screen


  • Customer Is Like: You can type part of a Customer name LIke Data this will return database dreams plus any other that include Data you can also use * anywhere in between like Da*ba this would return database dreams.
  • Town/City Is: Note you cannot add new items into this list you can only select items already in the list Selecting this item will display all entries for the town/city you selected.
  • Region Is: Note you cannot add new items into this list you can only select items already in the list Selecting this item will display all entries for the Region you selected.
  • Country Is: Note you cannot add new items into this list you can only select items already in the list Selecting this item will display all entries for the Country you selected
  • Postcode Is Like: You can type part of a Postcode Like CC this will return any  postcodes that have CC as part of the postcode you can also use * anywhere in between like C*T this would return database dreams
  • Search Button:Once you have made your selection update the list with the results by clicking this button.
  • Search Results List:After you click the search button this list will display the results of the search by clicking an item in the results list you will then be taken to that item on the Customers screen and the search screen will close
  • Close Button:To exit without doing anything click this button
  • Additional Information: NOTE: you can select more that one item to limit the search results this could be: All entries from a town and also a region, you could if you wanted add/select all items

Should you have questions related to this object please post a reply and we will be happy to help solve your issue.
« Last Edit: January 03, 2021, 08:45:16 am by DD Admin »

Share on Facebook Share on Twitter


 

Related Topics

  Subject / Started by Replies Last post
0 Replies
22 Views
Last post August 28, 2020, 08:06:40 pm
by DD Admin
0 Replies
35 Views
Last post August 28, 2020, 08:07:39 pm
by DD Admin
0 Replies
29 Views
Last post December 04, 2020, 10:56:08 pm
by DD Admin
0 Replies
22 Views
Last post December 04, 2020, 11:03:02 pm
by DD Admin
0 Replies
32 Views
Last post December 25, 2020, 09:59:22 am
by DD Admin

DD's Social Media

DD's Programs


Development Schedule

DD's Freeware

Apollo

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