Stats

Members
Total Members: 93
Latest: Cakadola
New This Month: 1
New This Week: 1
New Today: 0
Stats
Total Posts: 649
Total Topics: 310
Most Online Today: 0
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: 665
borobutch
Posts: 44
Carol
Posts: 12
Clarissa
Posts: 8
Ram
Posts: 8
richardsoj
Posts: 5
ComputerTech
Posts: 5

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

0 Members and 0 Guests are viewing this topic.

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 665
  • Karma: +4/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, Kent, UK
  • Referrals: 15
DD's Northwind Example Project Status
« on: June 30, 2020, 06:15:49 pm »

I will be adding to this topic on a daily basis.

NOTE: This project uses the Style Manager View all the styles available in Th Style Manager Gallery

Examples being used:
« Last Edit: July 15, 2020, 10:31:57 am by DD Admin »

Share on Facebook Share on Twitter


Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 665
  • Karma: +4/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, Kent, UK
  • Referrals: 15
Re: DD's Northwind Example Project Status
« Reply #1 on: July 01, 2020, 08:29:57 pm »
Have spent the day creating the project and started work on the ERD

I have decided to include the grid example as this sort of project was what it was designed for.

Have created the files from the defaults

I allowed 15 hrs for the comcept, project creation and ERD so for I have used 9.49 hrs

Current ERD This is about 50% complete
[/url]
« Last Edit: July 07, 2020, 02:06:40 pm by DD Admin »

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 665
  • Karma: +4/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, Kent, UK
  • Referrals: 15
Re: DD's Northwind Example Project Status
« Reply #2 on: July 03, 2020, 07:58:24 pm »
Got the ERD Done, Have now started work on the tables then I'll start with the object list.

« Last Edit: July 07, 2020, 02:06:56 pm by DD Admin »

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 665
  • Karma: +4/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, Kent, UK
  • Referrals: 15
Re: DD's Northwind Example Project Status
« Reply #3 on: July 06, 2020, 09:21:48 pm »
Completed works on the ERD And have created all the tables, Am creating a list of forms so I can get a time for that section.

will also be creating a list of reports which will be more that normal as this will be a pay to download product.

It will also include a copy of the Grid example setup to work with product Bins.

« Last Edit: July 07, 2020, 02:53:11 pm by DD Admin »

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 665
  • Karma: +4/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, Kent, UK
  • Referrals: 15
Re: DD's Northwind Example Project Status
« Reply #4 on: July 11, 2020, 07:46:58 pm »

NOTE: This project uses the Style Manager View all the styles available in Th Style Manager Gallery

Have now started work on the forms I have completed works on the customers forms

I may need to tweek them as I move along with the project.

Customers Screen


Search Customers


Print Customer Please note This object is untested and will remain that way until I add reports


« Last Edit: July 12, 2020, 10:21:45 pm by DD Admin »

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 665
  • Karma: +4/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, Kent, UK
  • Referrals: 15
Re: DD's Northwind Example Project Status
« Reply #5 on: July 12, 2020, 02:33:23 pm »

NOTE: This project uses the Style Manager View all the styles available in Th Style Manager Gallery

Done a lot of house cleaning and checking objects imported yeasterday

have added a switch user to the main control as I thought it's something newer developers may wish to see working.


Been playing with the employees I haven't decided if I will take the security further as I could create a complete system to handle that at a form/report level.


Each of these screens will be covered in the manual which will be created ones the project is in it's final stages.

« Last Edit: July 12, 2020, 10:22:24 pm by DD Admin »

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 665
  • Karma: +4/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, Kent, UK
  • Referrals: 15
Re: DD's Northwind Example Project Status
« Reply #6 on: July 12, 2020, 10:08:30 pm »

NOTE: This project uses the Style Manager View all the styles available in Th Style Manager Gallery

Been working on the suppliers plus entering all the suppliers from the 2k version I'm using it as a test and tweeking as I go so far I have six but don't think I'll need to play with the sreen any more but itend to complete the dataset from the old  version the hard way.

I am keeping this in line with the orginal 2k example but updating where needed

oe=ne thing I'm thinking of doing is to add a file list like the customers but haven't made up my mind as it wasn't in the ERD

Suppliers screen


Search Supplier
I still have a bit of work on this and mat add a few additional options

until tomorrow

night

« Last Edit: July 12, 2020, 10:23:01 pm by DD Admin »

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 665
  • Karma: +4/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, Kent, UK
  • Referrals: 15
Re: DD's Northwind Example Project Status
« Reply #7 on: July 13, 2020, 01:08:32 pm »
Been playing with a few screens and after recieving the northwind image back from the person I use for all my images i cheated the splash below and have to say it looks amazing.

« Last Edit: July 13, 2020, 06:57:01 pm by DD Admin »

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 665
  • Karma: +4/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, Kent, UK
  • Referrals: 15
Re: DD's Northwind Example Project Status
« Reply #8 on: July 13, 2020, 06:55:54 pm »
NOTE: This project uses the Style Manager View all the styles available in Th Style Manager Gallery


I have been working on some exsisting objects plus all objects Comboboxes now have a list double click edtor screen.

I have alterded the customers in a number of ways adding the remaining fields required also have created a function to create a Customer number which will require more testing before i can sign off on it.

I have also been adding data for customers, suppliers and shippers this has all been added from the 2k version

Customers

Main Control
I have updated the main control and will be adding more buttons tomorrow, plus will be ordering them better.

Shippers
« Last Edit: July 13, 2020, 07:15:56 pm by DD Admin »

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 665
  • Karma: +4/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, Kent, UK
  • Referrals: 15
Re: DD's Northwind Example Project Status
« Reply #9 on: July 13, 2020, 10:18:24 pm »
NOTE: This project uses the Style Manager View all the styles available in Th Style Manager Gallery

Thought I would get the options added to the main control, Quite pleased with the look

« Last Edit: July 13, 2020, 10:21:37 pm by DD Admin »

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 665
  • Karma: +4/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, Kent, UK
  • Referrals: 15
Re: DD's Northwind Example Project Status
« Reply #10 on: July 14, 2020, 02:45:48 pm »
Have updated the main control as I wish to show different ways of viewing data and or doing things I have created a popup that I will program so it displays the opens for the calling control this way I don't end up with a mess.


Also added the customers filter which originaly came from the 2k version but I have added a number of additional controls plus have now updated it for the style manager.

Download the example of the Filter Form Example Here


Now I'm back to adding data and tweeking objects

Also decided to deal with this post and use my find and replace tool to correct and issue I have with a customer codes.
https://www.access-programmers.co.uk/forums/threads/remove-special-characters-from-string.312471/

« Last Edit: July 15, 2020, 06:56:44 am by DD Admin »

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 665
  • Karma: +4/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, Kent, UK
  • Referrals: 15
Re: DD's Northwind Example Project Status
« Reply #11 on: July 14, 2020, 10:04:56 pm »
Done more work with the options for main control made it simple and just copied the first and added/edited what I needed, I expect to need at least one more possibly for the products will depend on where I go with the products screens.

This is the design version of the products, I still have a lot of work to do as you can see.

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 665
  • Karma: +4/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, Kent, UK
  • Referrals: 15
Re: DD's Northwind Example Project Status
« Reply #12 on: July 15, 2020, 10:31:43 am »
Moved further along with the products screen Should have it complete later today.



I am now able to open any form even a modal one in the location I wish which will normally be below the combo that the list relates to.


Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 665
  • Karma: +4/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, Kent, UK
  • Referrals: 15
Re: DD's Northwind Example Project Status
« Reply #13 on: July 15, 2020, 07:11:39 pm »
I have now taken the Products screen as far as I can I nor require Other items to be complete before I can test the expressions.


Also completed work on the products search screen


Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 665
  • Karma: +4/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, Kent, UK
  • Referrals: 15
Re: DD's Northwind Example Project Status
« Reply #14 on: July 16, 2020, 12:14:55 pm »
I have now added the categories which has been created like the 2k original but the category picture is linked, I Have also updated the FillListsOneExt so I can open the category screen in the location I Wish.


Will be adding more data for the rest of the day before I move on to the order system.

 

Related Topics

  Subject / Started by Replies Last post
8 Replies
176 Views
Last post November 20, 2019, 06:01:09 pm
by DD Admin
23 Replies
162 Views
Last post October 10, 2019, 09:24:52 pm
by DD Admin
32 Replies
311 Views
Last post January 17, 2020, 06:34:43 pm
by DD Admin
9 Replies
65 Views
Last post April 15, 2020, 02:55:10 pm
by DD Admin
0 Replies
17 Views
Last post July 03, 2020, 12:28:25 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

Employee Example V5

Grid Demo Example V1

Employee Example V4

Small Examples

Member Examples


Recent Topics

Developer Tools Downloads: Style Manager: Calendar by DD Admin
August 07, 2020, 02:59:30 pm

DD's Northwind Example Project Status by DD Admin
August 06, 2020, 09:48:25 pm

Two errors I've spotted in Chart Tracker by borobutch
August 05, 2020, 09:56:59 pm

Member only downloads by DD Admin
August 02, 2020, 03:08:16 pm

Please welcome Cakadola to DD by DD Admin
August 02, 2020, 03:01:25 pm

UK Singles/Albums Charts 24 July 2020 to 30 July 2020 Analysis by borobutch
August 01, 2020, 05:15:40 pm

Members profiles updated by DD Admin
July 30, 2020, 11:09:32 pm

Database Dreams is not affiliated with Microsoft