DIR Return Create A Forum - Home
---------------------------------------------------------
Database Dreams
HTML https://databasedreams.createaforum.com
---------------------------------------------------------
*****************************************************
DIR Return to: Info Center
*****************************************************
#Post#: 113--------------------------------------------------
Project manangement system Update
By: Michael Date: September 8, 2019, 7:32 am
---------------------------------------------------------
Some projects have been put on hold for an indefinite amount of
time these have been move to a new category.
Because of a change in database dreams bussiness rules a new
section has to be developed within our project managemant system
to be able to handle rentals.
this is currently in the planning stage but the works are not
expected to take more than a month with the current time
available.
Due to this no further updates will be added to the employees
example this will now be turned into a full project and be free
for x users "X to be announced" I am doing this with new
projects so that small stuggling companies can benifit from the
systems.
#Post#: 114--------------------------------------------------
Re: Project manangement system Update
By: Michael Date: September 10, 2019, 3:59 pm
---------------------------------------------------------
Got the main screen format worked out as below.
this has been contructed with automation in mind.
A new invoice will be created on the set day of the month for
all entries in rentals table.
An invoice will then be mailed to each entry, Once payed a
receipt will be mailed.
I still have a lot of work with things like search forms for new
customer/site or searching for rentals, printing.
[attach=1]
As This system is so old their are items that can be tapped into
like the below as the whole system was designed with expansion
in mind all I had to do was tell the other form the new one
existed with a few lines of extra code.
[attach=2]
#Post#: 117--------------------------------------------------
Re: Project manangement system Update
By: Michael Date: September 12, 2019, 1:35 pm
---------------------------------------------------------
Completed works on the forms for the subscriptions but still
have an invoice function to build but thats just a matter of
copying another and altering it for the subscriptions.
Only had to add 2 tables one to hold subscritions and another
for subcrition terms.
each subsription cost will be calculated from the number of
copies and the term of the subscription so the more copies and
longer term will attain a higher discount.
Once the invoice function is completed I will move the tables
and add the preferences items to my working system then replace
the front end accde with the developer one and relink to working
datafile
Main Subscription screen
[attach=1]
Main search screen there are 2 search screens one for adding
customers (buttons next to customer combo) and the one shown
below
[attach=2]
Print selection screen this allows you to filter reports so only
the information you need will be displayed.
[attach=3]
Terms List
[attach=4]
Subscription Products
[attach=5]
#Post#: 121--------------------------------------------------
Re: Project manangement system Update
By: Michael Date: September 15, 2019, 4:55 am
---------------------------------------------------------
Completed the subsriptions screen which now allow me to add new
subscriptions and cancel those I have to plus send a
confirmation email with a converted report as a pdf.
even though I have built this for my own system I have treated
it like i would any program I.E. it has full error handling, and
has a form validation function so should I have need of it
within another project it will be able to be used with only
minor changes or non at all.
I have also included an image of a report used by the print
filter screen I may add more as I require them but This is all I
need for now plus there are a number of invoice reports that
will display information I might require their.
[attach=1]
[attach=2]
[attach=3]
#Post#: 122--------------------------------------------------
Re: Project manangement system Update
By: Michael Date: September 15, 2019, 8:36 am
---------------------------------------------------------
Created the invoice function Just might play with it for a bit
to get it looking better.
Now I need to Create the mail system
[attach=1]
#Post#: 133--------------------------------------------------
Re: Project manangement system Update
By: Michael Date: September 19, 2019, 4:30 pm
---------------------------------------------------------
Continued with the registration system update within project
management system.
Kept it simple as I can but liking the results
Registartion Code email
[attach=1]
Where the code should be entered
[attach=5]
Adding a new customer
[attach=2]
Searching for customers
[attach=3]
Main Registration entry screen
[attach=4]
*****************************************************