DD's Northwind


DD's Northwind Gallery

DD's Northwind Download


DD's Stats

Members
Total Members: 114
Latest: kokowawa0100@yahoo.com
New This Month: 8
New This Week: 0
New Today: 0
Stats
Total Posts: 724
Total Topics: 350
Most Online Today: 1
Most Online Ever: 52
(May 02, 2020, 05:24:19 pm)
Users Online
Members: 0
Guests: 0
Total: 0

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: 750
borobutch
Posts: 50
Carol
Posts: 12
Ram
Posts: 8
Clarissa
Posts: 8
richardsoj
Posts: 5
ComputerTech
Posts: 5

Author Topic: DD's Northwind Example Project Status  (Read 191 times)

0 Members and 0 Guests are viewing this topic.

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 750
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 15
Re: DD's Northwind Example Project Status
« Reply #15 on: July 18, 2020, 05:33:48 pm »
Have been working on the stock system which I still have a bit do do but want to wait until I do work on the po orders as it relates to that object tables.

Stock Screen



Stock showing products screen (All products)

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 750
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 15
Re: DD's Northwind Example Project Status
« Reply #16 on: July 19, 2020, 11:45:42 am »
I have now completed the list of products from the original MS Northwind Db, Plus have done a sort of stock take by using the original as the initial Stock Numbers "See Previous Post"

Stock warnings are complete just waiting for the Po Oder screen.
This screen will be available from the main control>Order Items>Options List


I will do more later today.

mick
« Last Edit: July 19, 2020, 11:51:20 am by DD Admin »

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 750
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 15
Re: DD's Northwind Example Project Status
« Reply #17 on: July 20, 2020, 12:23:49 pm »
Did A lot more yeasterday but wasn't able to post.

I have now Completed Works On:
  • Products Screen
  • PoOrder Screen
  • Stock Screen

I will be moving on to the order screen later today.
Products Screen Final


PoOrder Screen Final


Stock Screen final

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 750
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 15
Re: DD's Northwind Example Project Status
« Reply #18 on: July 20, 2020, 06:46:14 pm »
Decided to play with the lists and make them more useful which I think I achieved.

These screens will be covered fully in the manual

Purchase Orders Showing The Supplier List


PoOrders Showing The Products List


Stock Showing The Products List



Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 750
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 15
Re: DD's Northwind Example Project Status
« Reply #19 on: July 21, 2020, 10:39:57 pm »
Made a very good start On the Orders screen



I still have work to do on it but it shouldn't change much,I have also started adding data from the original Northwind.

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 750
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 15
Re: DD's Northwind Example Project Status
« Reply #20 on: July 23, 2020, 09:45:06 pm »
Have completed works on both the orders and Po Order All I have now is to build a report for each which will be added as soon as I have created a invoice Outstanding screen.

I;m continuing to add data from the 2k northwind and intend to randomise the dates between 2015 and today so I can use them for Crosstab queries etc.

Below A the 2 search screens added today.

Search PoOrders


Search Orders

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 750
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 15
Re: DD's Northwind Example Project Status
« Reply #21 on: July 24, 2020, 12:58:02 pm »
I have imported the Quarterly Orders Form from the 2k version of northwind and updated it so it is more dynamic so now you can select a customer and year an display the results.



I'll be moving on to the next section.

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 750
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 15
Re: DD's Northwind Example Project Status
« Reply #22 on: July 24, 2020, 08:44:30 pm »
Been updating the ERD while bilding the db.

you will notice there are a lot of tables not used these are for other versions/updates I have planned.


Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 750
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 15
Re: DD's Northwind Example Project Status
« Reply #23 on: July 25, 2020, 07:49:30 pm »
Have now completed all screens except print screens.

You will notice I haven't added a payments screen in this version but the table is included should you wish to add one before I decide on what will be included in version 2.

I'm still adding data but will start work on the reports tomorrow.




Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 750
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 15
Re: DD's Northwind Example Project Status
« Reply #24 on: July 26, 2020, 06:12:38 pm »
Have been adding more data plus done a bit more work on the order radomiser which now added a random employeeID to each order.

I will be leaving this module in the project and expect to have added other functions for things like PoOrders and stock in/out so the whole system is ballanced hopefully ;)

@DD Admin
« Last Edit: July 30, 2020, 12:46:34 pm by DD Admin »

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 750
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 15
Re: DD's Northwind Example Project Status
« Reply #25 on: August 01, 2020, 09:35:01 pm »
Got a lot done today Added more data plus built a calendar for use with the style manager.

Calendar Style 1


Calendar Style 2


Calendar Style 3

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 750
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 15
Re: DD's Northwind Example Project Status
« Reply #26 on: August 06, 2020, 09:48:25 pm »
I have updated the calendar so that dates displayed befor and after the current month can be displayed.
I Have also created a custom sub for the calendar as It was taking a second to open I have reduced that by half by creating a style sub just for it.

I will be adding the calender tool to the downloads over the weekend.



Also been adding more data to the complete system but still only about 3 quarters still to do.

Added 4 reports
  • RptCustomersAddressBook
  • RptCustomersTelephoneListing
  • RptSummaryOfSalesByQuarter
  • RptSummaryOfSalesByYear
« Last Edit: August 06, 2020, 10:09:14 pm by DD Admin »

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 750
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 15
Re: DD's Northwind Example Project Status
« Reply #27 on: August 11, 2020, 09:21:59 pm »
Been adding data which I have about 50% complete, I am adding the date manually as I am also adding Po Orders plus the inventory transactions, It is taking longer than expected but I need the data added correctly for follow on items that will be added should the project become popular.


Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 750
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 15
Re: DD's Northwind Example Project Status
« Reply #28 on: August 14, 2020, 07:38:29 pm »
I have over the last few days finalising each object and adding missing features.

I have added the search for the suppliers#


I have started te print system this will be a completly new system that I have itended building so the system will be redesigned  from the tables up.


The Purchase Order has been completed as below.


Sales By Category Chart


Products By Category


Supplier Telephone Listing


Suppliers Address Book



« Last Edit: August 15, 2020, 12:24:55 am by DD Admin »

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 750
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 15
Re: DD's Northwind Example Project Status
« Reply #29 on: August 15, 2020, 05:24:54 pm »
Added a number of reports plus 3 selection Dialogs for the new reports plus one old one.

Please note I still have a large number of reports planned so will be a while yet.

The print selection screen for the sales type reports


Selection screen for below image report




Selection screen for sales by year report as in image below this one




Selection screen for the sales by Date and category report as posted in previous post


 

Related Topics

  Subject / Started by Replies Last post
8 Replies
181 Views
Last post November 20, 2019, 06:01:09 pm
by DD Admin
23 Replies
165 Views
Last post October 10, 2019, 09:24:52 pm
by DD Admin
32 Replies
312 Views
Last post January 17, 2020, 06:34:43 pm
by DD Admin
0 Replies
17 Views
Last post July 03, 2020, 12:28:25 pm
by DD Admin
20 Replies
70 Views
Last post September 20, 2020, 03:56:52 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

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

DJ 2020 Project Status by DD Admin
September 20, 2020, 03:56:52 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

Music Library Database by DD Admin
September 14, 2020, 08:34:12 pm

Database Dreams is not affiliated with Microsoft