near east university faculty of economics …docs.neu.edu.tr/library/6258429450.pdf · near east...
TRANSCRIPT
NEAR EAST UNIVERSITY
FACULTY OF ECONOMICS AND ADMINISTRATIVE SCIENCES
DEPARTMENT OF COMPUTER INFORMATION SYSTEMS
2005/2006 FALL TERM CIS 400
(Graduation Project)
CAMERA STORE SYSTEM
Submitted To: Dept. Of CIS
Submitted By: MOHMMAD FADIL RABI (20002143)
Nicosia, 2005
NEAR EAST UNIVERSITY
FACULTY OF ECONOMICS AND ADMINISTRATIVE SCIENCES
DEPARTMENT OF COMPUTER INFORMATION SYSTEMS
2005/2006 FALL TERM CIS 400
(Graduation Project)
CAMERA STORE SYSTEM
Submitted To: Dept. Of CIS
Submitted By: MOHMMAD FADIL RABI (20002143)
Nicosia, 2005
CONTENTS
,;\~l ,, !·' r, /
ii ,·3 . ,,,··' \ ,~ <:>
~
" 'v 6. ' /. ~. ·.i;,, ,' /(• \.,-/ ~, 9~&-~
~
Page
I. ACKNOWLEbGEM13NTS ........................................ 2
II. ABSTRACT ........................................ 3
nt.tNTRODUCTION ........................................ 4
IV. DESIGN OF THE SYSTEM ......................................... 5
- Data Flow Diagram ......................................... 6
- Database Design ......................................... 11
V. USER MANUAL ......................................... 18
- User Guidelines ......................................... 18
- User Flow Charts · 34
IV.REFRENCES ......................................... 46
• Screen Output ......................................... 47
......................................... 59 • Source Code
0
I. ACKNOWLEDGEMENTS
The longest day has an end"
My primary debt of gratitude, of course, goes to God.
I'm profoundly grateful to my parents and my siblings for their endless support,
understanding, patience, prayers and love.
I highly appreciate the academic stuff of the CIS department in Near East University
especially My chairman .Dr. Yalcin Akcali, And my Super Advisor Asst. Proof. Dr Ilham
Huseyinov, Ms. Nadire Cavus and Mr. Mustafa Menekay for their guide ness, excellent
corporation and encouragement.
I'm deeply indebted to my father Fadil Mohammad Rabi for getting me back on track.
Many thanks to my friends, Abdulmajeed, Samer Abu Halemeh , Samer Hattab for
standing beside me through the good days and the bad.
2
0
ABSTRACT
This software is an application program is used for some of stores which their sales are depend on selling small figures of products such my project subject which is selling deferent kind of camera . Which that makes business do their transactions easy and connection between the customers and the business to make fewer efforts on the accountants to keep record and preparing Payments tables in advance ... The Camera store system is divided into four main processes for better user interface and friendly environment.
My solution to the problem I guess is to understand the way I divided the system into main four processes, such as Stock, Sales, purchase, Reports and payments , Each of the section I designed is easy to understand and learn fast. There are used command buttons were preferred so all is in front of the user for quick access.
I added user messages as well for the correspondence with the program so user may understand a bit the inside logic of the program how his process is handled.
I hope this software will help the Camera stores or any store similar of business manager keep close eye on his business accounts performance, As there are hundreds of ways to solve any problem so if you find any suggestions about my program please do not hesitate telling me bout them.
3
0
Introduction.
With the huge technology and easy transportation the number of travelers and visitors increase around the world and the nice days com with. nice memories kept in pictures which our cameras take tij~se pictures while our traveling so number of camera store in tourists places increase arid the need for system manage arid control any store to make the business more profitable and easy to classify the catekory, mark, model of that camera. This system is divided to four inrlih processes.
1. Purchase. , 1
This: ptobess is where the business order amount of products and keep it stock. 2. Saies. This process is where the customer making order to buy this product forms our stock.
3. Accounting. Accounting process is one of the most important processes where this process we ~ail keep records df purchasing the products'aritl where selling the product and the do tH~:'falculation needed for management reporting. · ', ·
, , ,
4. Reports. :it~porting process :i~ important as well because reporting process help the managetherit tb decision makihg and printing receipts fut the customet and supplier payments.
The aiirt 'of this project is try to solve the keeping record problems ahd devolve a system and decrees the system errors bun make our business more profitable tl.tt,d fuor~ elastic to be close, ~th the huge developments of this world. I will develop this system by using Access arid VB languages. I am using these languages because it is dsy to maintain and useful with my ability to deal \VIth such this software.
4
0
Design of the system
I designed my system upon of business knowledge and to develop of business transaction system by database program that can solve the time, cost, errors, missing files, and communication between departments.
My system designed on database where keeping data and process it to get formatted information to inform the management about the our business transactions and more process.
The system dealing with easy and friendly interface to give the user more power to enter and get the information easy.
The main menu connect the user with four departments of the system.
1. The purchase department or form which allows the user to keep info about our product supplier and about the product entity.
1.1 The payment form which allows the user to enter how much payment mad to supplier and the system will inform the user by the result of payment by the payment balance.
2. The sales department which allow the user to deal with selling products to customer and customer orders and the customer payments.
3. the reports department which inform the management by the all purchase and sales by date and more to allow the management to take the necessary action because of business transactions.
5
Data Flow Diagram
Customer
(*) 1. Report of Customer 2. Report of Supplier 3. Report of Account 4. Report of Products 5. Report of Order
Controlling System process
6
Camera store System Context Level D.F.D
Management
NOT: Know= knowledge Cust = Customer Supp = Supplier
~~cc: Accounts r.fo: information
Camera store system Top level DFD
Customer file
I ~I
Ti / -; '
!I V El c., ;-g 'ri C)
I ,::i ____§: Cust. Acc. file supp. Acc. file
· Cust. Acc. Know
3 Account Control process
7
0
Camera Store System Details level DFD
l.Sales control process
Customer
Customer File Orders File Products file
Camera Store System Details level DFD
2.Purchase Control process
Products file Supplier file
0
Camera Store System Details level DFD
3. Account control process
~ l Addsupp
&,0mQ
Supplier file -y- ~~
~
Customer File
Q!g. Acc. File Supp. AllJm:
Camera Store System Details level DFD
4.report Control process
Supp. Acc. File -"-'b\
~O'; C,•
~o
Order file Products file Cust. Acc. File
~ .sY
Supplier file Order file
9
Relationship
CotactName Address City Country Phone
,_. -~-~=~- Orders
OrderD> Customer ID OrderDate RequairdDate
~ DateOf Purchase QuantityPurchased PurchasePrice _Unit Product id
Customer ID OrderDetailsID Order ID
City Country Phone
J]
JO
Supplier Table
Suppli_erName s;omi:ia_r,yName __ CotactName Address 5=ity - Country Phone Fax
Text Text
l...Text Text ----- -r- --··~-
----- __ __,Text_ __ Text
Field Prol)erties
-Gener al T Lookup l Field Size tone Inteaer New Values Increment Format Caption Indexed Yes (No Duplicates) Smart Tags
l1
0
Purchase Details Table.
DateOf Purchase QuantityPurchas-ed PurchasePrlce _Unit Product Id
AutoNum_beJ _ Date/Time ._J. Numbe_r __ -+ -- -, Number - . r - __ r- - -- . -t-
Field Properties
General I Lookup I Field Size Long Integer New Values Increment Format Caption Indexed Yes (No Duolicates) Smart Tags
11
Nl.lmber --1=:--- Nu_rnber_ __ --- Number - - Number - l
Order ID ProductID Discount Quantitl,'Ordered - -- Intrest Type _
Number ,Number
--- Field Proi::ierties
Gener al I Lookup J Field Size Lona Inteaer New Values Increment Format Caption Indexed Yes (No Duolicates) Smart Tags
0
Customer ID Order Date RequairdDa!e
AutoN~er_ t- -- = Num~er ---l...-
1 Dat~/Time __ ,. - - - -roate/Tim~ _ . !
-1 -1 --; t-=- .. __ 1=--·
I Field Proe_19rties
-Gener af I Lookup J Field Size Lona Inteaer New Values Increment Format Caption Indexed Yes (No Duolicates) Smart Tags
14
0
f'i'orlnds Table
Data Type AutoNumber - -- -- uext -- •Number . _ t Number
-- · LText LN~ber ·- L
- --- --"--~~-I - - - - - fl. -1 . ---- --l - -- - -- - I
-- - - --- ~ -- • f, I -1-. _LV:,
ProductName ~upi:,lierID SellingPrice Mark - Stocklevel
Field Pro1J_erties
General I Lookup J Field Size Long Integer New Values Increment Format Caption Indexed Yes (No Duolicates) Smart Tags
15
0
Customer Payment
Payment Type IssuedDate -- Paid -- Customer ID OrderDetailsID Order ID Balance
Text I Date/Time
-- 1Number ~Nurnl~.EL _ Number
+Num~er_ Number 1-- l
Field Prop_erties
General I Lookup l Field Size Lona Inteaer New Values Increment Format Caption Indexed Yes (No Duolicates) Smart Tags
~ '
16
, V
Supplier Pavment
____ ./1uto~~ PaymentType Text DateOf PaY._~e,t _ =--. f:Da_telTirre -::_ Paid Number SUpplierID - - -- - - Number Product:i.D · Number PurchaseDetalID tNumber - -I -
----- _L_-_· t--·- 1
_J
--+----- Fi91d Properties
Ge,eral I Looh1p j Fiek::I Size .ono Inteaer New Values [ncrement Format Caption Inli9xed '(es (No Duoicates) Smart Tags
-
17
0
0
Customer Table
a Customer : Table Field Name Data Type
AutoNumber -r--- CustomerNar:ne _ _ 1 ~~t __ ~Oll)panyNam,e __J_~_)(t _ Address Text City_ ~ -=- _ ~-- .. - -Tex_t f=__ - Country . Text Phone ·· ~4 -· _ Fax I Text E-Mail- - ·-- . lTe_x~t-- -_-_-::
--,---
t- t ---
+--- l
Field Pro~rties
Gener al I Lookup ] Field Size Lona lnteoer New Values Increment Format Caption Indexed Yes {No Duolicates) Smart Tags
0
V. User Manual
-user guidelines
1. Main menu
COi.era store ~lttm
_,
l .Main menu consist of five command buttons.
1.1 purchase button which open supplier and product sub from to perform registry of supplier entry and products data entry. 2.1 Customer button which open the customer form to perform the customer data registry. 3.1 Customer Sales which open form of customer orders and orders details sub form. To perform the customer orders and maintain its product ordering data entry. 4.1 Find/reports button which open search and reporting form which has tow process to search the seals and the purchase between tow days. And daily sales, daily purchase product reports and the revenue reports.
19
0
1.. Customer uata Entry
'ol'm View NUM
Customer form allow user to keep information about the customer entry and to keep contact with this customP:t
20
0
3. Customer Sales Form
'orm View NUM
Customer sales form allows the user to keep records about the customer order and information about the product which such: 1.3 quantitv and the id of product and how the customer will pays cash or credit.
~ 21
• I
0
4. Customer navment bv credit Form - - -
Customer Payment By credit form is showing result of transaction mad by the customer resultinz of orcennz nroducts rrom our stocs,
n
0
4.1 Customer Pavment bv Credit Form.
This form allow the user to select number of order details id and iust write down the amount navment with date of navment of customer from selling nroduct. Then click ~"'""' button. 4.1.1 Save button oerfonn the check total reauired from the customer and comoare the oavmertt if it less then or zrater than zero the will zive us messaze that the navment done - -
successfullv. In case he navment more than the total monev reauired or nezative value the svstem will - - -
inform the user bv messaze tell him the oavment not satisfied and return to oavment field to reenter the correct navment,
0
This form inform the user bv details of oavment and total monev and the balance that remain on customer to be oaid.
'l4
0
6. Customer Pavment bv Cash Form.
This form such report inform the user by the required money from the total sales has mad result of customer ordering a product.
'25
NEAR EAST UNIVERSITY
FACULTY OF ECONOMICS AND ADMINISTRATIVE SCIENCES
DEPARTMENT OF COMPUTER INFORMATION SYSTEMS
2005/2006 FALL TERM CIS 400
(Graduation Project)
CAMERA STORE SYSTEM
Submitted To: Dept. Of CIS
Submitted By: MOHMMAD FADIL RABI (20002143)
Nicosia, 2005
CONTENTS
,;\~l ,, !·' r, /
ii ,·3 . ,,,··' \ ,~ <:>
~
" 'v 6. ' /. ~. ·.i;,, ,' /(• \.,-/ ~, 9~&-~
~
Page
I. ACKNOWLEbGEM13NTS ........................................ 2
II. ABSTRACT ........................................ 3
nt.tNTRODUCTION ........................................ 4
IV. DESIGN OF THE SYSTEM ......................................... 5
- Data Flow Diagram ......................................... 6
- Database Design ......................................... 11
V. USER MANUAL ......................................... 18
- User Guidelines ......................................... 18
- User Flow Charts · 34
IV.REFRENCES ......................................... 46
• Screen Output ......................................... 47
......................................... 59 • Source Code
0
I. ACKNOWLEDGEMENTS
The longest day has an end"
My primary debt of gratitude, of course, goes to God.
I'm profoundly grateful to my parents and my siblings for their endless support,
understanding, patience, prayers and love.
I highly appreciate the academic stuff of the CIS department in Near East University
especially My chairman .Dr. Yalcin Akcali, And my Super Advisor Asst. Proof. Dr Ilham
Huseyinov, Ms. Nadire Cavus and Mr. Mustafa Menekay for their guide ness, excellent
corporation and encouragement.
I'm deeply indebted to my father Fadil Mohammad Rabi for getting me back on track.
Many thanks to my friends, Abdulmajeed, Samer Abu Halemeh , Samer Hattab for
standing beside me through the good days and the bad.
2
0
ABSTRACT
This software is an application program is used for some of stores which their sales are depend on selling small figures of products such my project subject which is selling deferent kind of camera . Which that makes business do their transactions easy and connection between the customers and the business to make fewer efforts on the accountants to keep record and preparing Payments tables in advance ... The Camera store system is divided into four main processes for better user interface and friendly environment.
My solution to the problem I guess is to understand the way I divided the system into main four processes, such as Stock, Sales, purchase, Reports and payments , Each of the section I designed is easy to understand and learn fast. There are used command buttons were preferred so all is in front of the user for quick access.
I added user messages as well for the correspondence with the program so user may understand a bit the inside logic of the program how his process is handled.
I hope this software will help the Camera stores or any store similar of business manager keep close eye on his business accounts performance, As there are hundreds of ways to solve any problem so if you find any suggestions about my program please do not hesitate telling me bout them.
3
0
Introduction.
With the huge technology and easy transportation the number of travelers and visitors increase around the world and the nice days com with. nice memories kept in pictures which our cameras take tij~se pictures while our traveling so number of camera store in tourists places increase arid the need for system manage arid control any store to make the business more profitable and easy to classify the catekory, mark, model of that camera. This system is divided to four inrlih processes.
1. Purchase. , 1
This: ptobess is where the business order amount of products and keep it stock. 2. Saies. This process is where the customer making order to buy this product forms our stock.
3. Accounting. Accounting process is one of the most important processes where this process we ~ail keep records df purchasing the products'aritl where selling the product and the do tH~:'falculation needed for management reporting. · ', ·
, , ,
4. Reports. :it~porting process :i~ important as well because reporting process help the managetherit tb decision makihg and printing receipts fut the customet and supplier payments.
The aiirt 'of this project is try to solve the keeping record problems ahd devolve a system and decrees the system errors bun make our business more profitable tl.tt,d fuor~ elastic to be close, ~th the huge developments of this world. I will develop this system by using Access arid VB languages. I am using these languages because it is dsy to maintain and useful with my ability to deal \VIth such this software.
4
0
Design of the system
I designed my system upon of business knowledge and to develop of business transaction system by database program that can solve the time, cost, errors, missing files, and communication between departments.
My system designed on database where keeping data and process it to get formatted information to inform the management about the our business transactions and more process.
The system dealing with easy and friendly interface to give the user more power to enter and get the information easy.
The main menu connect the user with four departments of the system.
1. The purchase department or form which allows the user to keep info about our product supplier and about the product entity.
1.1 The payment form which allows the user to enter how much payment mad to supplier and the system will inform the user by the result of payment by the payment balance.
2. The sales department which allow the user to deal with selling products to customer and customer orders and the customer payments.
3. the reports department which inform the management by the all purchase and sales by date and more to allow the management to take the necessary action because of business transactions.
5
Data Flow Diagram
Customer
(*) 1. Report of Customer 2. Report of Supplier 3. Report of Account 4. Report of Products 5. Report of Order
Controlling System process
6
Camera store System Context Level D.F.D
Management
NOT: Know= knowledge Cust = Customer Supp = Supplier
~~cc: Accounts r.fo: information
Camera store system Top level DFD
Customer file
I ~I
Ti / -; '
!I V El c., ;-g 'ri C)
I ,::i ____§: Cust. Acc. file supp. Acc. file
· Cust. Acc. Know
3 Account Control process
7
0
Camera Store System Details level DFD
l.Sales control process
Customer
Customer File Orders File Products file
Camera Store System Details level DFD
2.Purchase Control process
Products file Supplier file
0
Camera Store System Details level DFD
3. Account control process
~ l Addsupp
&,0mQ
Supplier file -y- ~~
~
Customer File
Q!g. Acc. File Supp. AllJm:
Camera Store System Details level DFD
4.report Control process
Supp. Acc. File -"-'b\
~O'; C,•
~o
Order file Products file Cust. Acc. File
~ .sY
Supplier file Order file
9
Relationship
CotactName Address City Country Phone
,_. -~-~=~- Orders
OrderD> Customer ID OrderDate RequairdDate
~ DateOf Purchase QuantityPurchased PurchasePrice _Unit Product id
Customer ID OrderDetailsID Order ID
City Country Phone
J]
JO
Supplier Table
Suppli_erName s;omi:ia_r,yName __ CotactName Address 5=ity - Country Phone Fax
Text Text
l...Text Text ----- -r- --··~-
----- __ __,Text_ __ Text
Field Prol)erties
-Gener al T Lookup l Field Size tone Inteaer New Values Increment Format Caption Indexed Yes (No Duplicates) Smart Tags
l1
0
Purchase Details Table.
DateOf Purchase QuantityPurchas-ed PurchasePrlce _Unit Product Id
AutoNum_beJ _ Date/Time ._J. Numbe_r __ -+ -- -, Number - . r - __ r- - -- . -t-
Field Properties
General I Lookup I Field Size Long Integer New Values Increment Format Caption Indexed Yes (No Duolicates) Smart Tags
11
Nl.lmber --1=:--- Nu_rnber_ __ --- Number - - Number - l
Order ID ProductID Discount Quantitl,'Ordered - -- Intrest Type _
Number ,Number
--- Field Proi::ierties
Gener al I Lookup J Field Size Lona Inteaer New Values Increment Format Caption Indexed Yes (No Duolicates) Smart Tags
0
Customer ID Order Date RequairdDa!e
AutoN~er_ t- -- = Num~er ---l...-
1 Dat~/Time __ ,. - - - -roate/Tim~ _ . !
-1 -1 --; t-=- .. __ 1=--·
I Field Proe_19rties
-Gener af I Lookup J Field Size Lona Inteaer New Values Increment Format Caption Indexed Yes (No Duolicates) Smart Tags
14
0
f'i'orlnds Table
Data Type AutoNumber - -- -- uext -- •Number . _ t Number
-- · LText LN~ber ·- L
- --- --"--~~-I - - - - - fl. -1 . ---- --l - -- - -- - I
-- - - --- ~ -- • f, I -1-. _LV:,
ProductName ~upi:,lierID SellingPrice Mark - Stocklevel
Field Pro1J_erties
General I Lookup J Field Size Long Integer New Values Increment Format Caption Indexed Yes (No Duolicates) Smart Tags
15
0
Customer Payment
Payment Type IssuedDate -- Paid -- Customer ID OrderDetailsID Order ID Balance
Text I Date/Time
-- 1Number ~Nurnl~.EL _ Number
+Num~er_ Number 1-- l
Field Prop_erties
General I Lookup l Field Size Lona Inteaer New Values Increment Format Caption Indexed Yes (No Duolicates) Smart Tags
~ '
16
, V
Supplier Pavment
____ ./1uto~~ PaymentType Text DateOf PaY._~e,t _ =--. f:Da_telTirre -::_ Paid Number SUpplierID - - -- - - Number Product:i.D · Number PurchaseDetalID tNumber - -I -
----- _L_-_· t--·- 1
_J
--+----- Fi91d Properties
Ge,eral I Looh1p j Fiek::I Size .ono Inteaer New Values [ncrement Format Caption Inli9xed '(es (No Duoicates) Smart Tags
-
17
0
0
Customer Table
a Customer : Table Field Name Data Type
AutoNumber -r--- CustomerNar:ne _ _ 1 ~~t __ ~Oll)panyNam,e __J_~_)(t _ Address Text City_ ~ -=- _ ~-- .. - -Tex_t f=__ - Country . Text Phone ·· ~4 -· _ Fax I Text E-Mail- - ·-- . lTe_x~t-- -_-_-::
--,---
t- t ---
+--- l
Field Pro~rties
Gener al I Lookup ] Field Size Lona lnteoer New Values Increment Format Caption Indexed Yes {No Duolicates) Smart Tags
0
V. User Manual
-user guidelines
1. Main menu
COi.era store ~lttm
_,
l .Main menu consist of five command buttons.
1.1 purchase button which open supplier and product sub from to perform registry of supplier entry and products data entry. 2.1 Customer button which open the customer form to perform the customer data registry. 3.1 Customer Sales which open form of customer orders and orders details sub form. To perform the customer orders and maintain its product ordering data entry. 4.1 Find/reports button which open search and reporting form which has tow process to search the seals and the purchase between tow days. And daily sales, daily purchase product reports and the revenue reports.
19
0
1.. Customer uata Entry
'ol'm View NUM
Customer form allow user to keep information about the customer entry and to keep contact with this customP:t
20
0
3. Customer Sales Form
'orm View NUM
Customer sales form allows the user to keep records about the customer order and information about the product which such: 1.3 quantitv and the id of product and how the customer will pays cash or credit.
~ 21
• I
0
4. Customer navment bv credit Form - - -
Customer Payment By credit form is showing result of transaction mad by the customer resultinz of orcennz nroducts rrom our stocs,
n
0
4.1 Customer Pavment bv Credit Form.
This form allow the user to select number of order details id and iust write down the amount navment with date of navment of customer from selling nroduct. Then click ~"'""' button. 4.1.1 Save button oerfonn the check total reauired from the customer and comoare the oavmertt if it less then or zrater than zero the will zive us messaze that the navment done - -
successfullv. In case he navment more than the total monev reauired or nezative value the svstem will - - -
inform the user bv messaze tell him the oavment not satisfied and return to oavment field to reenter the correct navment,
0
This form inform the user bv details of oavment and total monev and the balance that remain on customer to be oaid.
'l4
0
6. Customer Pavment bv Cash Form.
This form such report inform the user by the required money from the total sales has mad result of customer ordering a product.
'25
0
7. Searching Data And Reporting Svstem From.
This form has six reports such as; i .6 dailv sales reoorts tell the user by daily product sold. 2.6 dailv purchase reports tell the user bv the daily product has purchased and detail about that product. 3.6 delivery reminder reports are remind the user day by dav about the product which shonlrl hP. <:11hm1ttP.rl to customer and information about the customer to could contact n· . un.
26
0
8. Search Seals Between to dates Form.
This form allow the user to make simple search about product by id within or lie between two davs.
'27
0
';).Sales Between Tow Dates Bv Name Form.
This from is similar to previous form by search by name to find a product sold between to d:nP.,
28
0
10. Find Purchase Form.
This from finding a purchased product lie between two dates. bv searching product ID.
0
11~ Find Purchase by name.
This form searching purchased product by name to find the product purchased within zivinz tow dates.
J
12. Sunnlier and Stock Form.
In this form where we keep information about the supplier and about the product such name. and selling price and more details in the next form 13.
·n
I I
"'
0
13. Purchasing Product Details.
This form allow us to add more quantity and any time we order new quantity form the same nroduct to add new quantity and cost price and date of purchase.
J
14. Suoolier navment, - - .
· Ihis torm allow the user to select the customer order detans and eater the payment tc, supplier that has mad and entering: the tvne of navment naid to sunnlier.
Main Menu
J
J
Supplier
ENTEi'! Suppll•ro.rta S _Id. Name .etc.
1Sa111 2Edlt :::JOt loll! Hl•CI '5 Nt., 6 ,..,~
ENTEi'! clc,c~ -<Cl'""
0
Product D~a Entry
1Salll! :2 E<llt :JDtln Hl•d 5NHI 6B~t
ENTEfi!CIOC<I: -e c •.•.
run
37
j
Pm.duct Purchase Details
!Sana '2!:dlt ;iou• Hl1(1 5 Nt 11 6 llEk
38
Customer
• .,,1.ostotm,~ dat.a :2..C'Ll:S101l1CT'Si:ilc!!:
ENTER Yo, rc•Q~ <.Cl>
J
0
Customer Data Entry
1Saw 2E!Jtt :JS<i1le Hl•ll 5Ntll 16 I a::k
fillt
,1 ()
J
Customer Sales
~
1-.slc £.edit 3.frcd 4.'CCW s .oi<{p,aymctit) l>.b.oc~
ENTEl'lclot·,;, -<Cl;,-
,11 J
Cash Payment
J
NEAR EAST UNIVERSITY
FACULTY OF ECONOMICS AND ADMINISTRATIVE SCIENCES
DEPARTMENT OF COMPUTER INFORMATION SYSTEMS
2005/2006 FALL TERM CIS 400
(Graduation Project)
CAMERA STORE SYSTEM
Submitted To: Dept. Of CIS
Submitted By: MOHMMAD FADIL RABI (20002143)
Nicosia, 2005
CONTENTS
,;\~l ,, !·' r, /
ii ,·3 . ,,,··' \ ,~ <:>
~
" 'v 6. ' /. ~. ·.i;,, ,' /(• \.,-/ ~, 9~&-~
~
Page
I. ACKNOWLEbGEM13NTS ........................................ 2
II. ABSTRACT ........................................ 3
nt.tNTRODUCTION ........................................ 4
IV. DESIGN OF THE SYSTEM ......................................... 5
- Data Flow Diagram ......................................... 6
- Database Design ......................................... 11
V. USER MANUAL ......................................... 18
- User Guidelines ......................................... 18
- User Flow Charts · 34
IV.REFRENCES ......................................... 46
• Screen Output ......................................... 47
......................................... 59 • Source Code
0
I. ACKNOWLEDGEMENTS
The longest day has an end"
My primary debt of gratitude, of course, goes to God.
I'm profoundly grateful to my parents and my siblings for their endless support,
understanding, patience, prayers and love.
I highly appreciate the academic stuff of the CIS department in Near East University
especially My chairman .Dr. Yalcin Akcali, And my Super Advisor Asst. Proof. Dr Ilham
Huseyinov, Ms. Nadire Cavus and Mr. Mustafa Menekay for their guide ness, excellent
corporation and encouragement.
I'm deeply indebted to my father Fadil Mohammad Rabi for getting me back on track.
Many thanks to my friends, Abdulmajeed, Samer Abu Halemeh , Samer Hattab for
standing beside me through the good days and the bad.
2
0
ABSTRACT
This software is an application program is used for some of stores which their sales are depend on selling small figures of products such my project subject which is selling deferent kind of camera . Which that makes business do their transactions easy and connection between the customers and the business to make fewer efforts on the accountants to keep record and preparing Payments tables in advance ... The Camera store system is divided into four main processes for better user interface and friendly environment.
My solution to the problem I guess is to understand the way I divided the system into main four processes, such as Stock, Sales, purchase, Reports and payments , Each of the section I designed is easy to understand and learn fast. There are used command buttons were preferred so all is in front of the user for quick access.
I added user messages as well for the correspondence with the program so user may understand a bit the inside logic of the program how his process is handled.
I hope this software will help the Camera stores or any store similar of business manager keep close eye on his business accounts performance, As there are hundreds of ways to solve any problem so if you find any suggestions about my program please do not hesitate telling me bout them.
3
0
Introduction.
With the huge technology and easy transportation the number of travelers and visitors increase around the world and the nice days com with. nice memories kept in pictures which our cameras take tij~se pictures while our traveling so number of camera store in tourists places increase arid the need for system manage arid control any store to make the business more profitable and easy to classify the catekory, mark, model of that camera. This system is divided to four inrlih processes.
1. Purchase. , 1
This: ptobess is where the business order amount of products and keep it stock. 2. Saies. This process is where the customer making order to buy this product forms our stock.
3. Accounting. Accounting process is one of the most important processes where this process we ~ail keep records df purchasing the products'aritl where selling the product and the do tH~:'falculation needed for management reporting. · ', ·
, , ,
4. Reports. :it~porting process :i~ important as well because reporting process help the managetherit tb decision makihg and printing receipts fut the customet and supplier payments.
The aiirt 'of this project is try to solve the keeping record problems ahd devolve a system and decrees the system errors bun make our business more profitable tl.tt,d fuor~ elastic to be close, ~th the huge developments of this world. I will develop this system by using Access arid VB languages. I am using these languages because it is dsy to maintain and useful with my ability to deal \VIth such this software.
4
0
Design of the system
I designed my system upon of business knowledge and to develop of business transaction system by database program that can solve the time, cost, errors, missing files, and communication between departments.
My system designed on database where keeping data and process it to get formatted information to inform the management about the our business transactions and more process.
The system dealing with easy and friendly interface to give the user more power to enter and get the information easy.
The main menu connect the user with four departments of the system.
1. The purchase department or form which allows the user to keep info about our product supplier and about the product entity.
1.1 The payment form which allows the user to enter how much payment mad to supplier and the system will inform the user by the result of payment by the payment balance.
2. The sales department which allow the user to deal with selling products to customer and customer orders and the customer payments.
3. the reports department which inform the management by the all purchase and sales by date and more to allow the management to take the necessary action because of business transactions.
5
Data Flow Diagram
Customer
(*) 1. Report of Customer 2. Report of Supplier 3. Report of Account 4. Report of Products 5. Report of Order
Controlling System process
6
Camera store System Context Level D.F.D
Management
NOT: Know= knowledge Cust = Customer Supp = Supplier
~~cc: Accounts r.fo: information
Camera store system Top level DFD
Customer file
I ~I
Ti / -; '
!I V El c., ;-g 'ri C)
I ,::i ____§: Cust. Acc. file supp. Acc. file
· Cust. Acc. Know
3 Account Control process
7
0
Camera Store System Details level DFD
l.Sales control process
Customer
Customer File Orders File Products file
Camera Store System Details level DFD
2.Purchase Control process
Products file Supplier file
0
Camera Store System Details level DFD
3. Account control process
~ l Addsupp
&,0mQ
Supplier file -y- ~~
~
Customer File
Q!g. Acc. File Supp. AllJm:
Camera Store System Details level DFD
4.report Control process
Supp. Acc. File -"-'b\
~O'; C,•
~o
Order file Products file Cust. Acc. File
~ .sY
Supplier file Order file
9
Relationship
CotactName Address City Country Phone
,_. -~-~=~- Orders
OrderD> Customer ID OrderDate RequairdDate
~ DateOf Purchase QuantityPurchased PurchasePrice _Unit Product id
Customer ID OrderDetailsID Order ID
City Country Phone
J]
JO
Supplier Table
Suppli_erName s;omi:ia_r,yName __ CotactName Address 5=ity - Country Phone Fax
Text Text
l...Text Text ----- -r- --··~-
----- __ __,Text_ __ Text
Field Prol)erties
-Gener al T Lookup l Field Size tone Inteaer New Values Increment Format Caption Indexed Yes (No Duplicates) Smart Tags
l1
0
Purchase Details Table.
DateOf Purchase QuantityPurchas-ed PurchasePrlce _Unit Product Id
AutoNum_beJ _ Date/Time ._J. Numbe_r __ -+ -- -, Number - . r - __ r- - -- . -t-
Field Properties
General I Lookup I Field Size Long Integer New Values Increment Format Caption Indexed Yes (No Duolicates) Smart Tags
11
Nl.lmber --1=:--- Nu_rnber_ __ --- Number - - Number - l
Order ID ProductID Discount Quantitl,'Ordered - -- Intrest Type _
Number ,Number
--- Field Proi::ierties
Gener al I Lookup J Field Size Lona Inteaer New Values Increment Format Caption Indexed Yes (No Duolicates) Smart Tags
0
Customer ID Order Date RequairdDa!e
AutoN~er_ t- -- = Num~er ---l...-
1 Dat~/Time __ ,. - - - -roate/Tim~ _ . !
-1 -1 --; t-=- .. __ 1=--·
I Field Proe_19rties
-Gener af I Lookup J Field Size Lona Inteaer New Values Increment Format Caption Indexed Yes (No Duolicates) Smart Tags
14
0
f'i'orlnds Table
Data Type AutoNumber - -- -- uext -- •Number . _ t Number
-- · LText LN~ber ·- L
- --- --"--~~-I - - - - - fl. -1 . ---- --l - -- - -- - I
-- - - --- ~ -- • f, I -1-. _LV:,
ProductName ~upi:,lierID SellingPrice Mark - Stocklevel
Field Pro1J_erties
General I Lookup J Field Size Long Integer New Values Increment Format Caption Indexed Yes (No Duolicates) Smart Tags
15
0
Customer Payment
Payment Type IssuedDate -- Paid -- Customer ID OrderDetailsID Order ID Balance
Text I Date/Time
-- 1Number ~Nurnl~.EL _ Number
+Num~er_ Number 1-- l
Field Prop_erties
General I Lookup l Field Size Lona Inteaer New Values Increment Format Caption Indexed Yes (No Duolicates) Smart Tags
~ '
16
, V
Supplier Pavment
____ ./1uto~~ PaymentType Text DateOf PaY._~e,t _ =--. f:Da_telTirre -::_ Paid Number SUpplierID - - -- - - Number Product:i.D · Number PurchaseDetalID tNumber - -I -
----- _L_-_· t--·- 1
_J
--+----- Fi91d Properties
Ge,eral I Looh1p j Fiek::I Size .ono Inteaer New Values [ncrement Format Caption Inli9xed '(es (No Duoicates) Smart Tags
-
17
0
0
Customer Table
a Customer : Table Field Name Data Type
AutoNumber -r--- CustomerNar:ne _ _ 1 ~~t __ ~Oll)panyNam,e __J_~_)(t _ Address Text City_ ~ -=- _ ~-- .. - -Tex_t f=__ - Country . Text Phone ·· ~4 -· _ Fax I Text E-Mail- - ·-- . lTe_x~t-- -_-_-::
--,---
t- t ---
+--- l
Field Pro~rties
Gener al I Lookup ] Field Size Lona lnteoer New Values Increment Format Caption Indexed Yes {No Duolicates) Smart Tags
0
V. User Manual
-user guidelines
1. Main menu
COi.era store ~lttm
_,
l .Main menu consist of five command buttons.
1.1 purchase button which open supplier and product sub from to perform registry of supplier entry and products data entry. 2.1 Customer button which open the customer form to perform the customer data registry. 3.1 Customer Sales which open form of customer orders and orders details sub form. To perform the customer orders and maintain its product ordering data entry. 4.1 Find/reports button which open search and reporting form which has tow process to search the seals and the purchase between tow days. And daily sales, daily purchase product reports and the revenue reports.
19
0
1.. Customer uata Entry
'ol'm View NUM
Customer form allow user to keep information about the customer entry and to keep contact with this customP:t
20
0
3. Customer Sales Form
'orm View NUM
Customer sales form allows the user to keep records about the customer order and information about the product which such: 1.3 quantitv and the id of product and how the customer will pays cash or credit.
~ 21
• I
0
4. Customer navment bv credit Form - - -
Customer Payment By credit form is showing result of transaction mad by the customer resultinz of orcennz nroducts rrom our stocs,
n
0
4.1 Customer Pavment bv Credit Form.
This form allow the user to select number of order details id and iust write down the amount navment with date of navment of customer from selling nroduct. Then click ~"'""' button. 4.1.1 Save button oerfonn the check total reauired from the customer and comoare the oavmertt if it less then or zrater than zero the will zive us messaze that the navment done - -
successfullv. In case he navment more than the total monev reauired or nezative value the svstem will - - -
inform the user bv messaze tell him the oavment not satisfied and return to oavment field to reenter the correct navment,
0
This form inform the user bv details of oavment and total monev and the balance that remain on customer to be oaid.
'l4
0
6. Customer Pavment bv Cash Form.
This form such report inform the user by the required money from the total sales has mad result of customer ordering a product.
'25
0
7. Searching Data And Reporting Svstem From.
This form has six reports such as; i .6 dailv sales reoorts tell the user by daily product sold. 2.6 dailv purchase reports tell the user bv the daily product has purchased and detail about that product. 3.6 delivery reminder reports are remind the user day by dav about the product which shonlrl hP. <:11hm1ttP.rl to customer and information about the customer to could contact n· . un.
26
0
8. Search Seals Between to dates Form.
This form allow the user to make simple search about product by id within or lie between two davs.
'27
0
';).Sales Between Tow Dates Bv Name Form.
This from is similar to previous form by search by name to find a product sold between to d:nP.,
28
0
10. Find Purchase Form.
This from finding a purchased product lie between two dates. bv searching product ID.
0
11~ Find Purchase by name.
This form searching purchased product by name to find the product purchased within zivinz tow dates.
J
12. Sunnlier and Stock Form.
In this form where we keep information about the supplier and about the product such name. and selling price and more details in the next form 13.
·n
I I
"'
0
13. Purchasing Product Details.
This form allow us to add more quantity and any time we order new quantity form the same nroduct to add new quantity and cost price and date of purchase.
J
14. Suoolier navment, - - .
· Ihis torm allow the user to select the customer order detans and eater the payment tc, supplier that has mad and entering: the tvne of navment naid to sunnlier.
Main Menu
J
J
Supplier
ENTEi'! Suppll•ro.rta S _Id. Name .etc.
1Sa111 2Edlt :::JOt loll! Hl•CI '5 Nt., 6 ,..,~
ENTEi'! clc,c~ -<Cl'""
0
Product D~a Entry
1Salll! :2 E<llt :JDtln Hl•d 5NHI 6B~t
ENTEfi!CIOC<I: -e c •.•.
run
37
j
Pm.duct Purchase Details
!Sana '2!:dlt ;iou• Hl1(1 5 Nt 11 6 llEk
38
Customer
• .,,1.ostotm,~ dat.a :2..C'Ll:S101l1CT'Si:ilc!!:
ENTER Yo, rc•Q~ <.Cl>
J
0
Customer Data Entry
1Saw 2E!Jtt :JS<i1le Hl•ll 5Ntll 16 I a::k
fillt
,1 ()
J
Customer Sales
~
1-.slc £.edit 3.frcd 4.'CCW s .oi<{p,aymctit) l>.b.oc~
ENTEl'lclot·,;, -<Cl;,-
,11 J
Cash Payment
J
Payment By Credit
ENTEi'!. \fl! 1aorCol@
)
IV.REFRENCES
. Even Callahan, Microsoft Access 2002 Visual Basic, First Edition, 2003
. O'reilly, Access Cookbook, 2000
. www.m1crosoft.com/mspress/developer
. www.Oreilly.com
. www.M1crosoftAccess.com .
. www.MAVBA.com.
46
J
-Screen Output
2. Customer Data l!;ntry
'orm View NUM
47
0
1.rm:tome:r Sales Form
48
0
4.Customer payment by credit Form
4.1 Customer Payment by Credit Form.
J
5. Customer balance Details Form
50
J
6. Customer Payment by Cash Form.
7. Searching Data And Reporting System From.
Sl.
0
8. Search Seals Between to dates Form.
52
NEAR EAST UNIVERSITY
FACULTY OF ECONOMICS AND ADMINISTRATIVE SCIENCES
DEPARTMENT OF COMPUTER INFORMATION SYSTEMS
2005/2006 FALL TERM CIS 400
(Graduation Project)
CAMERA STORE SYSTEM
Submitted To: Dept. Of CIS
Submitted By: MOHMMAD FADIL RABI (20002143)
Nicosia, 2005
CONTENTS
,;\~l ,, !·' r, /
ii ,·3 . ,,,··' \ ,~ <:>
~
" 'v 6. ' /. ~. ·.i;,, ,' /(• \.,-/ ~, 9~&-~
~
Page
I. ACKNOWLEbGEM13NTS ........................................ 2
II. ABSTRACT ........................................ 3
nt.tNTRODUCTION ........................................ 4
IV. DESIGN OF THE SYSTEM ......................................... 5
- Data Flow Diagram ......................................... 6
- Database Design ......................................... 11
V. USER MANUAL ......................................... 18
- User Guidelines ......................................... 18
- User Flow Charts · 34
IV.REFRENCES ......................................... 46
• Screen Output ......................................... 47
......................................... 59 • Source Code
0
I. ACKNOWLEDGEMENTS
The longest day has an end"
My primary debt of gratitude, of course, goes to God.
I'm profoundly grateful to my parents and my siblings for their endless support,
understanding, patience, prayers and love.
I highly appreciate the academic stuff of the CIS department in Near East University
especially My chairman .Dr. Yalcin Akcali, And my Super Advisor Asst. Proof. Dr Ilham
Huseyinov, Ms. Nadire Cavus and Mr. Mustafa Menekay for their guide ness, excellent
corporation and encouragement.
I'm deeply indebted to my father Fadil Mohammad Rabi for getting me back on track.
Many thanks to my friends, Abdulmajeed, Samer Abu Halemeh , Samer Hattab for
standing beside me through the good days and the bad.
2
0
ABSTRACT
This software is an application program is used for some of stores which their sales are depend on selling small figures of products such my project subject which is selling deferent kind of camera . Which that makes business do their transactions easy and connection between the customers and the business to make fewer efforts on the accountants to keep record and preparing Payments tables in advance ... The Camera store system is divided into four main processes for better user interface and friendly environment.
My solution to the problem I guess is to understand the way I divided the system into main four processes, such as Stock, Sales, purchase, Reports and payments , Each of the section I designed is easy to understand and learn fast. There are used command buttons were preferred so all is in front of the user for quick access.
I added user messages as well for the correspondence with the program so user may understand a bit the inside logic of the program how his process is handled.
I hope this software will help the Camera stores or any store similar of business manager keep close eye on his business accounts performance, As there are hundreds of ways to solve any problem so if you find any suggestions about my program please do not hesitate telling me bout them.
3
0
Introduction.
With the huge technology and easy transportation the number of travelers and visitors increase around the world and the nice days com with. nice memories kept in pictures which our cameras take tij~se pictures while our traveling so number of camera store in tourists places increase arid the need for system manage arid control any store to make the business more profitable and easy to classify the catekory, mark, model of that camera. This system is divided to four inrlih processes.
1. Purchase. , 1
This: ptobess is where the business order amount of products and keep it stock. 2. Saies. This process is where the customer making order to buy this product forms our stock.
3. Accounting. Accounting process is one of the most important processes where this process we ~ail keep records df purchasing the products'aritl where selling the product and the do tH~:'falculation needed for management reporting. · ', ·
, , ,
4. Reports. :it~porting process :i~ important as well because reporting process help the managetherit tb decision makihg and printing receipts fut the customet and supplier payments.
The aiirt 'of this project is try to solve the keeping record problems ahd devolve a system and decrees the system errors bun make our business more profitable tl.tt,d fuor~ elastic to be close, ~th the huge developments of this world. I will develop this system by using Access arid VB languages. I am using these languages because it is dsy to maintain and useful with my ability to deal \VIth such this software.
4
0
Design of the system
I designed my system upon of business knowledge and to develop of business transaction system by database program that can solve the time, cost, errors, missing files, and communication between departments.
My system designed on database where keeping data and process it to get formatted information to inform the management about the our business transactions and more process.
The system dealing with easy and friendly interface to give the user more power to enter and get the information easy.
The main menu connect the user with four departments of the system.
1. The purchase department or form which allows the user to keep info about our product supplier and about the product entity.
1.1 The payment form which allows the user to enter how much payment mad to supplier and the system will inform the user by the result of payment by the payment balance.
2. The sales department which allow the user to deal with selling products to customer and customer orders and the customer payments.
3. the reports department which inform the management by the all purchase and sales by date and more to allow the management to take the necessary action because of business transactions.
5
Data Flow Diagram
Customer
(*) 1. Report of Customer 2. Report of Supplier 3. Report of Account 4. Report of Products 5. Report of Order
Controlling System process
6
Camera store System Context Level D.F.D
Management
NOT: Know= knowledge Cust = Customer Supp = Supplier
~~cc: Accounts r.fo: information
Camera store system Top level DFD
Customer file
I ~I
Ti / -; '
!I V El c., ;-g 'ri C)
I ,::i ____§: Cust. Acc. file supp. Acc. file
· Cust. Acc. Know
3 Account Control process
7
0
Camera Store System Details level DFD
l.Sales control process
Customer
Customer File Orders File Products file
Camera Store System Details level DFD
2.Purchase Control process
Products file Supplier file
0
Camera Store System Details level DFD
3. Account control process
~ l Addsupp
&,0mQ
Supplier file -y- ~~
~
Customer File
Q!g. Acc. File Supp. AllJm:
Camera Store System Details level DFD
4.report Control process
Supp. Acc. File -"-'b\
~O'; C,•
~o
Order file Products file Cust. Acc. File
~ .sY
Supplier file Order file
9
Relationship
CotactName Address City Country Phone
,_. -~-~=~- Orders
OrderD> Customer ID OrderDate RequairdDate
~ DateOf Purchase QuantityPurchased PurchasePrice _Unit Product id
Customer ID OrderDetailsID Order ID
City Country Phone
J]
JO
Supplier Table
Suppli_erName s;omi:ia_r,yName __ CotactName Address 5=ity - Country Phone Fax
Text Text
l...Text Text ----- -r- --··~-
----- __ __,Text_ __ Text
Field Prol)erties
-Gener al T Lookup l Field Size tone Inteaer New Values Increment Format Caption Indexed Yes (No Duplicates) Smart Tags
l1
0
Purchase Details Table.
DateOf Purchase QuantityPurchas-ed PurchasePrlce _Unit Product Id
AutoNum_beJ _ Date/Time ._J. Numbe_r __ -+ -- -, Number - . r - __ r- - -- . -t-
Field Properties
General I Lookup I Field Size Long Integer New Values Increment Format Caption Indexed Yes (No Duolicates) Smart Tags
11
Nl.lmber --1=:--- Nu_rnber_ __ --- Number - - Number - l
Order ID ProductID Discount Quantitl,'Ordered - -- Intrest Type _
Number ,Number
--- Field Proi::ierties
Gener al I Lookup J Field Size Lona Inteaer New Values Increment Format Caption Indexed Yes (No Duolicates) Smart Tags
0
Customer ID Order Date RequairdDa!e
AutoN~er_ t- -- = Num~er ---l...-
1 Dat~/Time __ ,. - - - -roate/Tim~ _ . !
-1 -1 --; t-=- .. __ 1=--·
I Field Proe_19rties
-Gener af I Lookup J Field Size Lona Inteaer New Values Increment Format Caption Indexed Yes (No Duolicates) Smart Tags
14
0
f'i'orlnds Table
Data Type AutoNumber - -- -- uext -- •Number . _ t Number
-- · LText LN~ber ·- L
- --- --"--~~-I - - - - - fl. -1 . ---- --l - -- - -- - I
-- - - --- ~ -- • f, I -1-. _LV:,
ProductName ~upi:,lierID SellingPrice Mark - Stocklevel
Field Pro1J_erties
General I Lookup J Field Size Long Integer New Values Increment Format Caption Indexed Yes (No Duolicates) Smart Tags
15
0
Customer Payment
Payment Type IssuedDate -- Paid -- Customer ID OrderDetailsID Order ID Balance
Text I Date/Time
-- 1Number ~Nurnl~.EL _ Number
+Num~er_ Number 1-- l
Field Prop_erties
General I Lookup l Field Size Lona Inteaer New Values Increment Format Caption Indexed Yes (No Duolicates) Smart Tags
~ '
16
, V
Supplier Pavment
____ ./1uto~~ PaymentType Text DateOf PaY._~e,t _ =--. f:Da_telTirre -::_ Paid Number SUpplierID - - -- - - Number Product:i.D · Number PurchaseDetalID tNumber - -I -
----- _L_-_· t--·- 1
_J
--+----- Fi91d Properties
Ge,eral I Looh1p j Fiek::I Size .ono Inteaer New Values [ncrement Format Caption Inli9xed '(es (No Duoicates) Smart Tags
-
17
0
0
Customer Table
a Customer : Table Field Name Data Type
AutoNumber -r--- CustomerNar:ne _ _ 1 ~~t __ ~Oll)panyNam,e __J_~_)(t _ Address Text City_ ~ -=- _ ~-- .. - -Tex_t f=__ - Country . Text Phone ·· ~4 -· _ Fax I Text E-Mail- - ·-- . lTe_x~t-- -_-_-::
--,---
t- t ---
+--- l
Field Pro~rties
Gener al I Lookup ] Field Size Lona lnteoer New Values Increment Format Caption Indexed Yes {No Duolicates) Smart Tags
0
V. User Manual
-user guidelines
1. Main menu
COi.era store ~lttm
_,
l .Main menu consist of five command buttons.
1.1 purchase button which open supplier and product sub from to perform registry of supplier entry and products data entry. 2.1 Customer button which open the customer form to perform the customer data registry. 3.1 Customer Sales which open form of customer orders and orders details sub form. To perform the customer orders and maintain its product ordering data entry. 4.1 Find/reports button which open search and reporting form which has tow process to search the seals and the purchase between tow days. And daily sales, daily purchase product reports and the revenue reports.
19
0
1.. Customer uata Entry
'ol'm View NUM
Customer form allow user to keep information about the customer entry and to keep contact with this customP:t
20
0
3. Customer Sales Form
'orm View NUM
Customer sales form allows the user to keep records about the customer order and information about the product which such: 1.3 quantitv and the id of product and how the customer will pays cash or credit.
~ 21
• I
0
4. Customer navment bv credit Form - - -
Customer Payment By credit form is showing result of transaction mad by the customer resultinz of orcennz nroducts rrom our stocs,
n
0
4.1 Customer Pavment bv Credit Form.
This form allow the user to select number of order details id and iust write down the amount navment with date of navment of customer from selling nroduct. Then click ~"'""' button. 4.1.1 Save button oerfonn the check total reauired from the customer and comoare the oavmertt if it less then or zrater than zero the will zive us messaze that the navment done - -
successfullv. In case he navment more than the total monev reauired or nezative value the svstem will - - -
inform the user bv messaze tell him the oavment not satisfied and return to oavment field to reenter the correct navment,
0
This form inform the user bv details of oavment and total monev and the balance that remain on customer to be oaid.
'l4
0
6. Customer Pavment bv Cash Form.
This form such report inform the user by the required money from the total sales has mad result of customer ordering a product.
'25
0
7. Searching Data And Reporting Svstem From.
This form has six reports such as; i .6 dailv sales reoorts tell the user by daily product sold. 2.6 dailv purchase reports tell the user bv the daily product has purchased and detail about that product. 3.6 delivery reminder reports are remind the user day by dav about the product which shonlrl hP. <:11hm1ttP.rl to customer and information about the customer to could contact n· . un.
26
0
8. Search Seals Between to dates Form.
This form allow the user to make simple search about product by id within or lie between two davs.
'27
0
';).Sales Between Tow Dates Bv Name Form.
This from is similar to previous form by search by name to find a product sold between to d:nP.,
28
0
10. Find Purchase Form.
This from finding a purchased product lie between two dates. bv searching product ID.
0
11~ Find Purchase by name.
This form searching purchased product by name to find the product purchased within zivinz tow dates.
J
12. Sunnlier and Stock Form.
In this form where we keep information about the supplier and about the product such name. and selling price and more details in the next form 13.
·n
I I
"'
0
13. Purchasing Product Details.
This form allow us to add more quantity and any time we order new quantity form the same nroduct to add new quantity and cost price and date of purchase.
J
14. Suoolier navment, - - .
· Ihis torm allow the user to select the customer order detans and eater the payment tc, supplier that has mad and entering: the tvne of navment naid to sunnlier.
Main Menu
J
J
Supplier
ENTEi'! Suppll•ro.rta S _Id. Name .etc.
1Sa111 2Edlt :::JOt loll! Hl•CI '5 Nt., 6 ,..,~
ENTEi'! clc,c~ -<Cl'""
0
Product D~a Entry
1Salll! :2 E<llt :JDtln Hl•d 5NHI 6B~t
ENTEfi!CIOC<I: -e c •.•.
run
37
j
Pm.duct Purchase Details
!Sana '2!:dlt ;iou• Hl1(1 5 Nt 11 6 llEk
38
Customer
• .,,1.ostotm,~ dat.a :2..C'Ll:S101l1CT'Si:ilc!!:
ENTER Yo, rc•Q~ <.Cl>
J
0
Customer Data Entry
1Saw 2E!Jtt :JS<i1le Hl•ll 5Ntll 16 I a::k
fillt
,1 ()
J
Customer Sales
~
1-.slc £.edit 3.frcd 4.'CCW s .oi<{p,aymctit) l>.b.oc~
ENTEl'lclot·,;, -<Cl;,-
,11 J
Cash Payment
J
Payment By Credit
ENTEi'!. \fl! 1aorCol@
)
IV.REFRENCES
. Even Callahan, Microsoft Access 2002 Visual Basic, First Edition, 2003
. O'reilly, Access Cookbook, 2000
. www.m1crosoft.com/mspress/developer
. www.Oreilly.com
. www.M1crosoftAccess.com .
. www.MAVBA.com.
46
J
-Screen Output
2. Customer Data l!;ntry
'orm View NUM
47
0
1.rm:tome:r Sales Form
48
0
4.Customer payment by credit Form
4.1 Customer Payment by Credit Form.
J
5. Customer balance Details Form
50
J
6. Customer Payment by Cash Form.
7. Searching Data And Reporting System From.
Sl.
0
8. Search Seals Between to dates Form.
52
0
9.Sales Between Tow Dates By Name Form.
FormYiew Nl.JM
53
J
10. Find Purchase Form.
Form \liew NlJM
,..4
J
11. Find Purchase by name.
55
0
12. Supplier and Stock Form.
56
V
13. Purchasing Product Details.
57
14. Supplier payment.
J
Source Code
.supplier Payment
Private Sub Command 15 _ Click()
Dim fldEx Dim fel
If IsNull(Me.Text7) Or Me.Text?="" Then
Else Set rs= db.OpenRecordset("SupplierPayment") Set rs= db.OpenRecordset("SELECT * FROM SupplierPayment where
S_Payment=" + "147", Type:=dbOpenDynaset)
Me.Text25 = rs.Fields("Productld").Value Set fldEx = Me.Text25 Set fel = Me.Text? My Int= Cint(fldEx) Mylnt2 = Clnt(fel)
If (Mylnt2 > My Int) Then MsgBox "The payment is more than balance try less payment"
Else rs.AddNew rs.Fields("PaymentType").Value = Me.Combo36 rs.Fields("DateOfPayment").Value = Me.Text2 rs.Fields("paid").Value = Me.Text? rs.Fields("PurchaseDetailID").Value = Me.Text9 rs.Update MsgBox " .. your payment done seccessfuly .. Record Saved .. "
End If Me.Text7.SetFocus
End If
.search and customer Payment
Private Sub Command 11 _ Click() Dim fldEx Dim fel
If IsNull(Me.Text6) Or Me.Text6 =""Then
59
)
•
•
Else 3ci n, - <lh.OµeuRe(;uidsei:("Cus _Paymem ') Set rs= db.OpenRecordset("SELECT * FROM Cus_Payment where PaymentNo=" +
"139", Type=dbfrpenfrynaset)
Me.Textl2 = rs.Fields("Balance").Value Set fldEx = Me.Texti2 Set fol= Me.Text8
Myint= Cint(fldEx)
If (Mylnt2 <> My Int) Or Mylnt2 <= 0 Then MsgBox "The payment is Unequalivent with Total's Order Cost Or Nigative."
Else rs.Ad<lNew rs.Fieldsr'Tssuedlrate'tj.Value = Me.text4 rs.Fieids("OrderDetailsID").Value = Me.Te:x-t6 rs.Fields("Paid").Value = Me.Text8 ___ TT __ J _..!.._ 1:s.upuate Ms1IB0x "vour navment done successfulv .. record saved .. "
End If Me.Text8.SetFocus Endlf
End Sub
Private Sub Form_Load() ("'._...t. _.J"'L - ~----------=-~·?_/'>. .:)t.ll UU - \...,Ullt.lllll.JU\}
End Sub Private Sub Con11nand 14 _ Click() ~-- n ,,_'T"'_ n .r, ..1, .-! .r·q_; __ ·L vu rzrrur \.JU I U LU x.ouuuauu l '-t \...,111,.;K.
DoCmd.Close
Exit Commandl4 Click: Exit Sub
•. Err Command 14 Click: Msglsox Err.Description Resume Exit Command 14 Click
60
End Sub P.riv-ate Sub Commandl7 _Click() On Error Go To En Commandl 7 Click
• Dim stDocName As String Dim stl.inkf.riteria As String
• stDocName = "Cust , Creditf Ayment_ Balance"
• stLinkCriteria = "[OrderDetailsID]=" & Me![Text8] DoCmd.OpenForm stDocName,,, stl..inkf.riteria
Exit Command 17 Click: Exit Sub
• Err Commandl 7 Click: - -
NlsgBox Err.Description Resume Exit Commandi7 Click
• End SUb Private Sub Commandl8 Click() On EITor Go To Err Commandi8 Click •
• Dim stDocName As String Dim stl.inkCriteria As String
stDocName = "Cust_ Creditf Ayment_ Balance"
• stLinkCriteria = "[OrderDetailsID]=" & Me! [Text6J Dof.md.Openf'orm stDocName, , , stLink:Criteria
Exit Command 18 Click: - -
Exit Sub
Err Commandl 8 Click: M-sgBox Err.Description Resume Exit Command 18 Click
End Sub
.Unit In Stock
Ootion Comnare Database - -
Public db As DAO.Database Public rs As DAO.Recordset
61
Private Sub Commandl 1 _ Click() On Brro:r GoTo Err Cornmandl 1 Click - -
Dim stDocName As String Dim stLinkCriteria As String
stDocName = "UnitslnStock"
stLinkCriteria = "[ProductID ]=" & Me! [ProductID) DoCmd.OpenForm stDocName,,, stLinkCriteria
Exit Command 11 Click: - - Exit Sub
Err Command 11 Click: - - Msglsox Err.Description Resume Exit Commandl I Click
End Sub Private Silb Command12_Click() On Error OoTo Err Command12 Click
Dim stOocName As String Dim stLirlkC1iteria As Suing
• stDocName = "Unitslnxtock"
• stLinkCriteria = "[ProductID]=" & Me![ProductID] DoCmd.OpenFonn stDocName,,, stLinkCriteria
Exit Commandl2 Click: - - Exit Sub
Err Commandl2 Click: - - MsgBox Err.Description Resume Exit Command12 Click
End Sub Private Sub Commandl3 Click() On Error Go To Err Command 13 Click
Dim stDocName As String Dim stl.inkf.riteria As String
stDocName = "Test UnitlnStock"
• 62
I
J
stLinkCriteria = "(ProductID]=" & Me![ProductID] Doefflff".~orm stDocName,,, stLinkCriteria
Exit Command 13 Click: - - Exit Sub
Err Command13 Click: - - MsgBox Err.Description Resume Exit Commandl3 Click
End Sub Private Sub Commandl4_Click() On Error GoTo Err Commandl4 Click - - •
Dim stDocN~~ As String Dim stl.inkflriteria As String
•
.. stDocName = "Newf.usPaymehtQ''
stLink.Ctiteria = "[OrderDetailsID]=" & Me![OrderDetailsID] DoCml::l.OpenForm stDocName,,, stLinkCriteria
Exit Command 14 Click: - -
Exit Sub
• Err Command I 4 Click: - -
•
:t\isgBox Err .Description Resume Exit_ Command 14 _ Click
End Sub Private Sub Command 16 _ Click() On Error Go To Err Commandl6 Click - -
Dim stDocName As String Dim stLinkCriteria As String
•• stDocNan1e = "Cus Sub totalCost" - -
stLinkCriteria = " [ OrderDetailsID ]=" & Me! [ OrderDetailsID] DoCmd.Openf'orm stDocNan1e,,, stLinkCriteria
Exit Command 16 Click: - - Exit Sub
Err Commandl6 Click: - - MsgBox Err .Description
63
0
R~'tfe'Extr 'Cornmandl S Click - -
End Sub Private Sub Commandl 7 _ Click() On Error Go To Err Command 17 Click
Dim stDocName As String Dim stLinkCriteria As String
stDocName = "New UnitlnStock"
stLinkCriteria = "[Productllfl=" & Me![ProductlP] DoCmd.Openf'orm stDocN"'1Il-e,,, stLinkCriteria
Exit_ Command l? _ Click: Exit Sub
Err Commandl 7 Click: MsgBox Err.Description Resume Exit Command 17 Click - -
Ends.uh Private Sub Command 18 _ Click() On Error Go Tb Err Command 18 Click
Dim stbocNathe As String Dim stLinkCtiteria As. String
stDocName = "UnitlnStockl"
stl.inkflriteria = 11 [ CdtintOfdrdetD~tailsID ]=11 & Me! [ OrderDetailsID]
DoCmd.OpenForm stDocName,,, stl.inkf'riteria
Exit Commandl8 Click: - - Exit Sub
Err Command! 8 Click: - - MsgBox Err.Description Resume Exit Command 18 Click
End Sub Private Sub Command 19 Click() On Error Go To Err Command 19 Click - -
Dim stDocName As String Dim stLinkCriteria As String
64
stLinkCriteria = "[Productld]=" & Me![Product.ID] DoCmd.OpenForm stDocName,,, stLinkCriteri:a
Exit Command19 Click: - - Exit Sub
Err Command19 Click: - -
MsgBox Err.Description Resume Exit Command19 Click
End Sub Private Sub Command20 _ Click() On Error Go To Err Command20 Click - -
Dini stDocName As String Dim stl.inkf'riteria As String
stDocName = "UnitinStock _ Newstfrne"
stLinkCriteria = "[CountOfOrderDetailsiDI]=" & Me![OrderDetailsID] DoCmd.OpenForm stDocName,,, stLinkCrit-eria
Exit Command.20 Click: - - Exit Sub
Err Command20 Click: - - MsgBox Err.Description Resume Exit Command20 Click - -
EruiSllb Private Sub Command21 _ Click() On Error Go To Err Command2 l Click - -
Dim stDocName As String Dim stLinkCriteria As String
stDocName = "UnitinStock NewstOne"
stLinkCriteria = "[ProductID]=" & Me![ProductID} DoCrnd.Openf'orrn stDocName,,, stLinkCriteria
Exit Cornmand21 Click: - -
Exit Sub
Err_~d2l_Click: \.r~~~ ~V:~--errption Resume Exit Command21 Click
End Sub Private Sub Command22 _ Click() On Error Go To Err Command22 Click - -
Dim stDocName As String Dim stl.inkCriteria As String
stDocName = "Unitlnstock"
stLinkCriteria = "[Productld]=" & Me![Productll)] DoCmd.OpenForm stDocName,,, stLinkCriteria
Exit Command22 Click: - - Exit Sub
Err Commantl:22 Click: Msg-Box Erl.bescription Reshlri.e Exit Command22 Click - -
End sub Private Sub Command23 _ Click() On Error Go To Err Command23 Click - -
Dim stDocName As String Dim stLink:Criteria As String
stDocName = "Un In Stock NEwst2"
stLinkCriteria == "[Productld]=" & Me![ProductID] DoCmd.OpenForm stDocName,,, stLinkCriteria
Exit Cornmand23 Click: - -
Exit Sub
Err Command23 Click: - Ms:gBox Err.Description Resume Exit Command23 Click
End.Sub Frivate Sub Command25 _ Click() On Error Go To Err Command25 Click - -
66
Dim stD.o.cNarne As String Dtm~~i"i:Wfkl' As String
stDocName = "Unitlnxtock"
• stLink:Criteria = "[Productldj=" & Me![ProductID] DoCrnd.OpenForrn stDocName,,, stl.inkCriteria
Exit Command25 Click: - - Exit Sub
• Err Coinmand25 Click: - - MsgBo~ Err.Description Resume Exit Conunand25 Click
End Sub Private Sub Connnand26 _ Clickf) On Ertot Go To Err Command26 Click
._ Dith stbocNarne As String Dim stLinkCriteria As String
stDocNarhe = "UnitlnStock"
stLink:Criteria = "[ProductID]=" & Me![ProductID] DoCmd.OpenFom1 stDocName,,, stLinkCriteria
Exit Command26 Click: - -
Exit Sub
Err Cornrnand26 Click: Msg-Box Err.Description Resume Exit Connnand26 Click
End Sub Private Sub Command27 _ Clickt) On Error Go To Err Command27 Click - -
Dim .stDocNarne As String Dim stLinkCriteria As String
stDocName = "UnitlnStock1"
stLink:Criteria = "[ProductID]=" & Me![ProductIDJ Dof'md.Openj-orm stDocNrune,,, stLink:Criteria
67
Exit C'Offlhlat1d27 Click: xit~~
Err Command27 Click: - - MsgBox Ert.Desef't~-fi Resume Exit Command27 Click
End Sub Private Sub Command28 _ ClickO On Error GoTo Err Command28 Click - -
Dim stDocName As String Dim stLinkCriteria As String
s1D0cName = "Up.itlnStock"
stLinkCriteria = "[Productlfrj=" & Me!tProductlDJ DoCmd.OpenForm stDocName,,, stLinkCriteria
Exit Cotnmand28 Click: - Exit Sub
Err Comfuand28 Click: MsgBox Ett.D;,cripmm Resume Exit Command28 Click
End&ub Private Sub Command29 _ ClickO On Error Go To Err Comma:nd29 Click
Dim stDocName As String Dim stl.inkCriteria As String
stDocName = "UnitlnStock"
stLinkCriteria = "[ProductID]=" & Me![ProductIDJ DoCmd.OpenForm stDocName,,, stLinkCriteria
Exit Command29 Click: - - Exit Sub
Err Command29 Click: - MsgBox Err.Descriptien Resume Exit Command29 Click - -
68
J
End.W1 ?~_~,,,. aab:Cmt1mand10:.__ Clickf) On Error Go To Err Command30 Click - -
Dim stDocName As String Dim stLinkCriteria As String
stDocName = "Invintory"
stLinkCriteria = "[ProductID]=" & Me![ProductID] DoCmd.OpenForm stDocName,,, stLinkCriteria
Exit Command30 Click: - - Exit Sub
Err Command30 Click: - - MsgBox Err.Description Resume Exit Commandsu Click - -
End.Sub Private Sub Command31 _ Clickt) On Error GoTo Err Command31 Click - -
Dim stDocName As String Dim stLinkCriteria As String
stDocName = "UnitlnStock1"
stLinkCriteria = "[ProductID]=" & Me![ProductID] DoCmd.OpenFom1 stDocName,,, stl.inkCriteria
Exit Command3 l Click: - - Exit Sub
Err Command3 l Click: - - Ms:gBox Err.Description Resume Exit Command3 l Click
Md Suh Private Sub Command33 _ Clickt) On Error Go To Err Command33 Click - -
lmn. stDocName As String Dim stLinkCriteria As String
stDocNrune = "Cus_Payment"
69
J
stLink:Criteria = "fOrderDetailsIDl=" & Me!fOrderDetailsIDl DoCmd. OpenF 01111 stDocName, , , stl.inkx'riteria
Exit Command B Click: - -
Exit Sub
Err Command33 Click: - - Msgfsox Err.Description Resume Exit Command.B Ciick
End Sub Private Sub Conunand34 _ Ciick() On Error Go To Err Command34 Click
u!m stDocNwn~ As Stririg Dim stLinkCriteria As String
stbocNrtine = "Installment" I
s~ptik,Criteria = "[OrderDetailsID]=" & tv1e![OrderDetailsID] D6Cri1d.OpenForm stDocName,,, stLinkCriteria
Exit Coni±hand34 Click: - -
Exit Sub
Err Corhmand34 Click: - - MsgBox Err.Description Resume Exit Command34 Click - -
End Sub Private Sub Command35 _ Click() On Error Go To Err Command35 Click - -
Dim stDocName As String Dim stLink:Criteria As String
stDocName = "Ins OrderDetailsl"
stLink:Criteria = "[OrderDetailsID]=" & Me![OrderDetailsID] DoCmd.OpenFonn stDocName,,, stLink:Criteria
Exit Command35 Click: - -
Exit Sub
Err Conunand35 Click:
70
J
~s.gBox Err.Description Resume Exit Co-mm-and3-:S- Click
- -
End Sub Private Sub Command 100 _ Click() On Error Go To Err Command 100 Click - -
Dim stDocName As String Dim stLinkCriteria As String
stDocN ame = "Installments 1 "
stLinkCriteria = "[OrderDetails_OrderDetailsID]=" & Me![OrderDetailsID] DoCmd.Open.Fonn stDocName,,, stLinkCriteria
Exit Command 100 Click: - - Exit Sub
Eit _ Commartdi OP_ CHclc MsgBox Err.Description Resume Exit Con1111~id 100 Click - -
Ertd Sub Private Sub Conunand3 7 _ Click() On Error Ob To Err Command37 Click - -
Dim sttio~~ame As String Dim stLinkCriteria As String
stfrocblame = "Ins Installments I Subfonn2"
stLinkCriteria = "[OrderDetailsID]=" & Me![OrderDetailsID] DoCmd.OpenFonn stDocName,,, stLinkCriteria
Exit Command37 Click: - -
Exit Sub
Err Command37 Click: - - MsgBox Err.Description Resume Exit Command37 Click
End Sub Private Sub Command38 _ Click() On Error Go To Err Command38 Click - -
Dim stDocName As String
71
D'ifm st't.i?i:ikCriteria As String-
stDocName = "Installment"
stLink:Criteria = "(OrderDetailsID]=" & Me![OrderDetailsID] DoCmd.OpenFonn stDocName,,, stLinkCriteria
Exit Cornmand38 Click: - -
Exit Sub
Err Cornrnand38 Click: - -
MsgBox Err.Description Resuh1e Exit_ Command i 8 _ Click
End $lib Private Sub Co11unai1d39:__ Click() On Error Goto Ert Corrimand'lv Click 1: -
Dim stDocName As String Djm sttinkCriteria As String
stDocName = "Installment" DoCntd.Openform stDocNaine,,, stLinkCriteria
Exit Command.Iv Click: - -
Exit Sub
Err Cominarld39 Click: - - MsgBox Err.Description Resume Exit Command.Iv Click - -
End Sub Private Sub Command40 _ Click() On Error Go To Err Command40 Click - -
IfMe!Tvoe = 0 Then IfMe!Frame56 = 1 Then
Dim stDocName As String Dim stLink:Criteria As String
stDocNaine = "Cus Sub TotalCost"
stLink:Criteria = " [ OrderDetailsID ]=" & Me! [ OrderDetailsID] DoCmd.OpenFonn stDocNaine,,, stLinkCriteria
72
J
NEAR EAST UNIVERSITY
FACULTY OF ECONOMICS AND ADMINISTRATIVE SCIENCES
DEPARTMENT OF COMPUTER INFORMATION SYSTEMS
2005/2006 FALL TERM CIS 400
(Graduation Project)
CAMERA STORE SYSTEM
Submitted To: Dept. Of CIS
Submitted By: MOHMMAD FADIL RABI (20002143)
Nicosia, 2005
CONTENTS
,;\~l ,, !·' r, /
ii ,·3 . ,,,··' \ ,~ <:>
~
" 'v 6. ' /. ~. ·.i;,, ,' /(• \.,-/ ~, 9~&-~
~
Page
I. ACKNOWLEbGEM13NTS ........................................ 2
II. ABSTRACT ........................................ 3
nt.tNTRODUCTION ........................................ 4
IV. DESIGN OF THE SYSTEM ......................................... 5
- Data Flow Diagram ......................................... 6
- Database Design ......................................... 11
V. USER MANUAL ......................................... 18
- User Guidelines ......................................... 18
- User Flow Charts · 34
IV.REFRENCES ......................................... 46
• Screen Output ......................................... 47
......................................... 59 • Source Code
0
I. ACKNOWLEDGEMENTS
The longest day has an end"
My primary debt of gratitude, of course, goes to God.
I'm profoundly grateful to my parents and my siblings for their endless support,
understanding, patience, prayers and love.
I highly appreciate the academic stuff of the CIS department in Near East University
especially My chairman .Dr. Yalcin Akcali, And my Super Advisor Asst. Proof. Dr Ilham
Huseyinov, Ms. Nadire Cavus and Mr. Mustafa Menekay for their guide ness, excellent
corporation and encouragement.
I'm deeply indebted to my father Fadil Mohammad Rabi for getting me back on track.
Many thanks to my friends, Abdulmajeed, Samer Abu Halemeh , Samer Hattab for
standing beside me through the good days and the bad.
2
0
ABSTRACT
This software is an application program is used for some of stores which their sales are depend on selling small figures of products such my project subject which is selling deferent kind of camera . Which that makes business do their transactions easy and connection between the customers and the business to make fewer efforts on the accountants to keep record and preparing Payments tables in advance ... The Camera store system is divided into four main processes for better user interface and friendly environment.
My solution to the problem I guess is to understand the way I divided the system into main four processes, such as Stock, Sales, purchase, Reports and payments , Each of the section I designed is easy to understand and learn fast. There are used command buttons were preferred so all is in front of the user for quick access.
I added user messages as well for the correspondence with the program so user may understand a bit the inside logic of the program how his process is handled.
I hope this software will help the Camera stores or any store similar of business manager keep close eye on his business accounts performance, As there are hundreds of ways to solve any problem so if you find any suggestions about my program please do not hesitate telling me bout them.
3
0
Introduction.
With the huge technology and easy transportation the number of travelers and visitors increase around the world and the nice days com with. nice memories kept in pictures which our cameras take tij~se pictures while our traveling so number of camera store in tourists places increase arid the need for system manage arid control any store to make the business more profitable and easy to classify the catekory, mark, model of that camera. This system is divided to four inrlih processes.
1. Purchase. , 1
This: ptobess is where the business order amount of products and keep it stock. 2. Saies. This process is where the customer making order to buy this product forms our stock.
3. Accounting. Accounting process is one of the most important processes where this process we ~ail keep records df purchasing the products'aritl where selling the product and the do tH~:'falculation needed for management reporting. · ', ·
, , ,
4. Reports. :it~porting process :i~ important as well because reporting process help the managetherit tb decision makihg and printing receipts fut the customet and supplier payments.
The aiirt 'of this project is try to solve the keeping record problems ahd devolve a system and decrees the system errors bun make our business more profitable tl.tt,d fuor~ elastic to be close, ~th the huge developments of this world. I will develop this system by using Access arid VB languages. I am using these languages because it is dsy to maintain and useful with my ability to deal \VIth such this software.
4
0
Design of the system
I designed my system upon of business knowledge and to develop of business transaction system by database program that can solve the time, cost, errors, missing files, and communication between departments.
My system designed on database where keeping data and process it to get formatted information to inform the management about the our business transactions and more process.
The system dealing with easy and friendly interface to give the user more power to enter and get the information easy.
The main menu connect the user with four departments of the system.
1. The purchase department or form which allows the user to keep info about our product supplier and about the product entity.
1.1 The payment form which allows the user to enter how much payment mad to supplier and the system will inform the user by the result of payment by the payment balance.
2. The sales department which allow the user to deal with selling products to customer and customer orders and the customer payments.
3. the reports department which inform the management by the all purchase and sales by date and more to allow the management to take the necessary action because of business transactions.
5
Data Flow Diagram
Customer
(*) 1. Report of Customer 2. Report of Supplier 3. Report of Account 4. Report of Products 5. Report of Order
Controlling System process
6
Camera store System Context Level D.F.D
Management
NOT: Know= knowledge Cust = Customer Supp = Supplier
~~cc: Accounts r.fo: information
Camera store system Top level DFD
Customer file
I ~I
Ti / -; '
!I V El c., ;-g 'ri C)
I ,::i ____§: Cust. Acc. file supp. Acc. file
· Cust. Acc. Know
3 Account Control process
7
0
Camera Store System Details level DFD
l.Sales control process
Customer
Customer File Orders File Products file
Camera Store System Details level DFD
2.Purchase Control process
Products file Supplier file
0
Camera Store System Details level DFD
3. Account control process
~ l Addsupp
&,0mQ
Supplier file -y- ~~
~
Customer File
Q!g. Acc. File Supp. AllJm:
Camera Store System Details level DFD
4.report Control process
Supp. Acc. File -"-'b\
~O'; C,•
~o
Order file Products file Cust. Acc. File
~ .sY
Supplier file Order file
9
Relationship
CotactName Address City Country Phone
,_. -~-~=~- Orders
OrderD> Customer ID OrderDate RequairdDate
~ DateOf Purchase QuantityPurchased PurchasePrice _Unit Product id
Customer ID OrderDetailsID Order ID
City Country Phone
J]
JO
Supplier Table
Suppli_erName s;omi:ia_r,yName __ CotactName Address 5=ity - Country Phone Fax
Text Text
l...Text Text ----- -r- --··~-
----- __ __,Text_ __ Text
Field Prol)erties
-Gener al T Lookup l Field Size tone Inteaer New Values Increment Format Caption Indexed Yes (No Duplicates) Smart Tags
l1
0
Purchase Details Table.
DateOf Purchase QuantityPurchas-ed PurchasePrlce _Unit Product Id
AutoNum_beJ _ Date/Time ._J. Numbe_r __ -+ -- -, Number - . r - __ r- - -- . -t-
Field Properties
General I Lookup I Field Size Long Integer New Values Increment Format Caption Indexed Yes (No Duolicates) Smart Tags
11
Nl.lmber --1=:--- Nu_rnber_ __ --- Number - - Number - l
Order ID ProductID Discount Quantitl,'Ordered - -- Intrest Type _
Number ,Number
--- Field Proi::ierties
Gener al I Lookup J Field Size Lona Inteaer New Values Increment Format Caption Indexed Yes (No Duolicates) Smart Tags
0
Customer ID Order Date RequairdDa!e
AutoN~er_ t- -- = Num~er ---l...-
1 Dat~/Time __ ,. - - - -roate/Tim~ _ . !
-1 -1 --; t-=- .. __ 1=--·
I Field Proe_19rties
-Gener af I Lookup J Field Size Lona Inteaer New Values Increment Format Caption Indexed Yes (No Duolicates) Smart Tags
14
0
f'i'orlnds Table
Data Type AutoNumber - -- -- uext -- •Number . _ t Number
-- · LText LN~ber ·- L
- --- --"--~~-I - - - - - fl. -1 . ---- --l - -- - -- - I
-- - - --- ~ -- • f, I -1-. _LV:,
ProductName ~upi:,lierID SellingPrice Mark - Stocklevel
Field Pro1J_erties
General I Lookup J Field Size Long Integer New Values Increment Format Caption Indexed Yes (No Duolicates) Smart Tags
15
0
Customer Payment
Payment Type IssuedDate -- Paid -- Customer ID OrderDetailsID Order ID Balance
Text I Date/Time
-- 1Number ~Nurnl~.EL _ Number
+Num~er_ Number 1-- l
Field Prop_erties
General I Lookup l Field Size Lona Inteaer New Values Increment Format Caption Indexed Yes (No Duolicates) Smart Tags
~ '
16
, V
Supplier Pavment
____ ./1uto~~ PaymentType Text DateOf PaY._~e,t _ =--. f:Da_telTirre -::_ Paid Number SUpplierID - - -- - - Number Product:i.D · Number PurchaseDetalID tNumber - -I -
----- _L_-_· t--·- 1
_J
--+----- Fi91d Properties
Ge,eral I Looh1p j Fiek::I Size .ono Inteaer New Values [ncrement Format Caption Inli9xed '(es (No Duoicates) Smart Tags
-
17
0
0
Customer Table
a Customer : Table Field Name Data Type
AutoNumber -r--- CustomerNar:ne _ _ 1 ~~t __ ~Oll)panyNam,e __J_~_)(t _ Address Text City_ ~ -=- _ ~-- .. - -Tex_t f=__ - Country . Text Phone ·· ~4 -· _ Fax I Text E-Mail- - ·-- . lTe_x~t-- -_-_-::
--,---
t- t ---
+--- l
Field Pro~rties
Gener al I Lookup ] Field Size Lona lnteoer New Values Increment Format Caption Indexed Yes {No Duolicates) Smart Tags
0
V. User Manual
-user guidelines
1. Main menu
COi.era store ~lttm
_,
l .Main menu consist of five command buttons.
1.1 purchase button which open supplier and product sub from to perform registry of supplier entry and products data entry. 2.1 Customer button which open the customer form to perform the customer data registry. 3.1 Customer Sales which open form of customer orders and orders details sub form. To perform the customer orders and maintain its product ordering data entry. 4.1 Find/reports button which open search and reporting form which has tow process to search the seals and the purchase between tow days. And daily sales, daily purchase product reports and the revenue reports.
19
0
1.. Customer uata Entry
'ol'm View NUM
Customer form allow user to keep information about the customer entry and to keep contact with this customP:t
20
0
3. Customer Sales Form
'orm View NUM
Customer sales form allows the user to keep records about the customer order and information about the product which such: 1.3 quantitv and the id of product and how the customer will pays cash or credit.
~ 21
• I
0
4. Customer navment bv credit Form - - -
Customer Payment By credit form is showing result of transaction mad by the customer resultinz of orcennz nroducts rrom our stocs,
n
0
4.1 Customer Pavment bv Credit Form.
This form allow the user to select number of order details id and iust write down the amount navment with date of navment of customer from selling nroduct. Then click ~"'""' button. 4.1.1 Save button oerfonn the check total reauired from the customer and comoare the oavmertt if it less then or zrater than zero the will zive us messaze that the navment done - -
successfullv. In case he navment more than the total monev reauired or nezative value the svstem will - - -
inform the user bv messaze tell him the oavment not satisfied and return to oavment field to reenter the correct navment,
0
This form inform the user bv details of oavment and total monev and the balance that remain on customer to be oaid.
'l4
0
6. Customer Pavment bv Cash Form.
This form such report inform the user by the required money from the total sales has mad result of customer ordering a product.
'25
0
7. Searching Data And Reporting Svstem From.
This form has six reports such as; i .6 dailv sales reoorts tell the user by daily product sold. 2.6 dailv purchase reports tell the user bv the daily product has purchased and detail about that product. 3.6 delivery reminder reports are remind the user day by dav about the product which shonlrl hP. <:11hm1ttP.rl to customer and information about the customer to could contact n· . un.
26
0
8. Search Seals Between to dates Form.
This form allow the user to make simple search about product by id within or lie between two davs.
'27
0
';).Sales Between Tow Dates Bv Name Form.
This from is similar to previous form by search by name to find a product sold between to d:nP.,
28
0
10. Find Purchase Form.
This from finding a purchased product lie between two dates. bv searching product ID.
0
11~ Find Purchase by name.
This form searching purchased product by name to find the product purchased within zivinz tow dates.
J
12. Sunnlier and Stock Form.
In this form where we keep information about the supplier and about the product such name. and selling price and more details in the next form 13.
·n
I I
"'
0
13. Purchasing Product Details.
This form allow us to add more quantity and any time we order new quantity form the same nroduct to add new quantity and cost price and date of purchase.
J
14. Suoolier navment, - - .
· Ihis torm allow the user to select the customer order detans and eater the payment tc, supplier that has mad and entering: the tvne of navment naid to sunnlier.
Main Menu
J
J
Supplier
ENTEi'! Suppll•ro.rta S _Id. Name .etc.
1Sa111 2Edlt :::JOt loll! Hl•CI '5 Nt., 6 ,..,~
ENTEi'! clc,c~ -<Cl'""
0
Product D~a Entry
1Salll! :2 E<llt :JDtln Hl•d 5NHI 6B~t
ENTEfi!CIOC<I: -e c •.•.
run
37
j
Pm.duct Purchase Details
!Sana '2!:dlt ;iou• Hl1(1 5 Nt 11 6 llEk
38
Customer
• .,,1.ostotm,~ dat.a :2..C'Ll:S101l1CT'Si:ilc!!:
ENTER Yo, rc•Q~ <.Cl>
J
0
Customer Data Entry
1Saw 2E!Jtt :JS<i1le Hl•ll 5Ntll 16 I a::k
fillt
,1 ()
J
Customer Sales
~
1-.slc £.edit 3.frcd 4.'CCW s .oi<{p,aymctit) l>.b.oc~
ENTEl'lclot·,;, -<Cl;,-
,11 J
Cash Payment
J
Payment By Credit
ENTEi'!. \fl! 1aorCol@
)
IV.REFRENCES
. Even Callahan, Microsoft Access 2002 Visual Basic, First Edition, 2003
. O'reilly, Access Cookbook, 2000
. www.m1crosoft.com/mspress/developer
. www.Oreilly.com
. www.M1crosoftAccess.com .
. www.MAVBA.com.
46
J
-Screen Output
2. Customer Data l!;ntry
'orm View NUM
47
0
1.rm:tome:r Sales Form
48
0
4.Customer payment by credit Form
4.1 Customer Payment by Credit Form.
J
5. Customer balance Details Form
50
J
6. Customer Payment by Cash Form.
7. Searching Data And Reporting System From.
Sl.
0
8. Search Seals Between to dates Form.
52
0
9.Sales Between Tow Dates By Name Form.
FormYiew Nl.JM
53
J
10. Find Purchase Form.
Form \liew NlJM
,..4
J
11. Find Purchase by name.
55
0
12. Supplier and Stock Form.
56
V
13. Purchasing Product Details.
57
14. Supplier payment.
J
Source Code
.supplier Payment
Private Sub Command 15 _ Click()
Dim fldEx Dim fel
If IsNull(Me.Text7) Or Me.Text?="" Then
Else Set rs= db.OpenRecordset("SupplierPayment") Set rs= db.OpenRecordset("SELECT * FROM SupplierPayment where
S_Payment=" + "147", Type:=dbOpenDynaset)
Me.Text25 = rs.Fields("Productld").Value Set fldEx = Me.Text25 Set fel = Me.Text? My Int= Cint(fldEx) Mylnt2 = Clnt(fel)
If (Mylnt2 > My Int) Then MsgBox "The payment is more than balance try less payment"
Else rs.AddNew rs.Fields("PaymentType").Value = Me.Combo36 rs.Fields("DateOfPayment").Value = Me.Text2 rs.Fields("paid").Value = Me.Text? rs.Fields("PurchaseDetailID").Value = Me.Text9 rs.Update MsgBox " .. your payment done seccessfuly .. Record Saved .. "
End If Me.Text7.SetFocus
End If
.search and customer Payment
Private Sub Command 11 _ Click() Dim fldEx Dim fel
If IsNull(Me.Text6) Or Me.Text6 =""Then
59
)
•
•
Else 3ci n, - <lh.OµeuRe(;uidsei:("Cus _Paymem ') Set rs= db.OpenRecordset("SELECT * FROM Cus_Payment where PaymentNo=" +
"139", Type=dbfrpenfrynaset)
Me.Textl2 = rs.Fields("Balance").Value Set fldEx = Me.Texti2 Set fol= Me.Text8
Myint= Cint(fldEx)
If (Mylnt2 <> My Int) Or Mylnt2 <= 0 Then MsgBox "The payment is Unequalivent with Total's Order Cost Or Nigative."
Else rs.Ad<lNew rs.Fieldsr'Tssuedlrate'tj.Value = Me.text4 rs.Fieids("OrderDetailsID").Value = Me.Te:x-t6 rs.Fields("Paid").Value = Me.Text8 ___ TT __ J _..!.._ 1:s.upuate Ms1IB0x "vour navment done successfulv .. record saved .. "
End If Me.Text8.SetFocus Endlf
End Sub
Private Sub Form_Load() ("'._...t. _.J"'L - ~----------=-~·?_/'>. .:)t.ll UU - \...,Ullt.lllll.JU\}
End Sub Private Sub Con11nand 14 _ Click() ~-- n ,,_'T"'_ n .r, ..1, .-! .r·q_; __ ·L vu rzrrur \.JU I U LU x.ouuuauu l '-t \...,111,.;K.
DoCmd.Close
Exit Commandl4 Click: Exit Sub
•. Err Command 14 Click: Msglsox Err.Description Resume Exit Command 14 Click
60
End Sub P.riv-ate Sub Commandl7 _Click() On Error Go To En Commandl 7 Click
• Dim stDocName As String Dim stl.inkf.riteria As String
• stDocName = "Cust , Creditf Ayment_ Balance"
• stLinkCriteria = "[OrderDetailsID]=" & Me![Text8] DoCmd.OpenForm stDocName,,, stl..inkf.riteria
Exit Command 17 Click: Exit Sub
• Err Commandl 7 Click: - -
NlsgBox Err.Description Resume Exit Commandi7 Click
• End SUb Private Sub Commandl8 Click() On EITor Go To Err Commandi8 Click •
• Dim stDocName As String Dim stl.inkCriteria As String
stDocName = "Cust_ Creditf Ayment_ Balance"
• stLinkCriteria = "[OrderDetailsID]=" & Me! [Text6J Dof.md.Openf'orm stDocName, , , stLink:Criteria
Exit Command 18 Click: - -
Exit Sub
Err Commandl 8 Click: M-sgBox Err.Description Resume Exit Command 18 Click
End Sub
.Unit In Stock
Ootion Comnare Database - -
Public db As DAO.Database Public rs As DAO.Recordset
61
Private Sub Commandl 1 _ Click() On Brro:r GoTo Err Cornmandl 1 Click - -
Dim stDocName As String Dim stLinkCriteria As String
stDocName = "UnitslnStock"
stLinkCriteria = "[ProductID ]=" & Me! [ProductID) DoCmd.OpenForm stDocName,,, stLinkCriteria
Exit Command 11 Click: - - Exit Sub
Err Command 11 Click: - - Msglsox Err.Description Resume Exit Commandl I Click
End Sub Private Silb Command12_Click() On Error OoTo Err Command12 Click
Dim stOocName As String Dim stLirlkC1iteria As Suing
• stDocName = "Unitslnxtock"
• stLinkCriteria = "[ProductID]=" & Me![ProductID] DoCmd.OpenFonn stDocName,,, stLinkCriteria
Exit Commandl2 Click: - - Exit Sub
Err Commandl2 Click: - - MsgBox Err.Description Resume Exit Command12 Click
End Sub Private Sub Commandl3 Click() On Error Go To Err Command 13 Click
Dim stDocName As String Dim stl.inkf.riteria As String
stDocName = "Test UnitlnStock"
• 62
I
J
stLinkCriteria = "(ProductID]=" & Me![ProductID] Doefflff".~orm stDocName,,, stLinkCriteria
Exit Command 13 Click: - - Exit Sub
Err Command13 Click: - - MsgBox Err.Description Resume Exit Commandl3 Click
End Sub Private Sub Commandl4_Click() On Error GoTo Err Commandl4 Click - - •
Dim stDocN~~ As String Dim stl.inkflriteria As String
•
.. stDocName = "Newf.usPaymehtQ''
stLink.Ctiteria = "[OrderDetailsID]=" & Me![OrderDetailsID] DoCml::l.OpenForm stDocName,,, stLinkCriteria
Exit Command 14 Click: - -
Exit Sub
• Err Command I 4 Click: - -
•
:t\isgBox Err .Description Resume Exit_ Command 14 _ Click
End Sub Private Sub Command 16 _ Click() On Error Go To Err Commandl6 Click - -
Dim stDocName As String Dim stLinkCriteria As String
•• stDocNan1e = "Cus Sub totalCost" - -
stLinkCriteria = " [ OrderDetailsID ]=" & Me! [ OrderDetailsID] DoCmd.Openf'orm stDocNan1e,,, stLinkCriteria
Exit Command 16 Click: - - Exit Sub
Err Commandl6 Click: - - MsgBox Err .Description
63
0
R~'tfe'Extr 'Cornmandl S Click - -
End Sub Private Sub Commandl 7 _ Click() On Error Go To Err Command 17 Click
Dim stDocName As String Dim stLinkCriteria As String
stDocName = "New UnitlnStock"
stLinkCriteria = "[Productllfl=" & Me![ProductlP] DoCmd.Openf'orm stDocN"'1Il-e,,, stLinkCriteria
Exit_ Command l? _ Click: Exit Sub
Err Commandl 7 Click: MsgBox Err.Description Resume Exit Command 17 Click - -
Ends.uh Private Sub Command 18 _ Click() On Error Go Tb Err Command 18 Click
Dim stbocNathe As String Dim stLinkCtiteria As. String
stDocName = "UnitlnStockl"
stl.inkflriteria = 11 [ CdtintOfdrdetD~tailsID ]=11 & Me! [ OrderDetailsID]
DoCmd.OpenForm stDocName,,, stl.inkf'riteria
Exit Commandl8 Click: - - Exit Sub
Err Command! 8 Click: - - MsgBox Err.Description Resume Exit Command 18 Click
End Sub Private Sub Command 19 Click() On Error Go To Err Command 19 Click - -
Dim stDocName As String Dim stLinkCriteria As String
64
stLinkCriteria = "[Productld]=" & Me![Product.ID] DoCmd.OpenForm stDocName,,, stLinkCriteri:a
Exit Command19 Click: - - Exit Sub
Err Command19 Click: - -
MsgBox Err.Description Resume Exit Command19 Click
End Sub Private Sub Command20 _ Click() On Error Go To Err Command20 Click - -
Dini stDocName As String Dim stl.inkf'riteria As String
stDocName = "UnitinStock _ Newstfrne"
stLinkCriteria = "[CountOfOrderDetailsiDI]=" & Me![OrderDetailsID] DoCmd.OpenForm stDocName,,, stLinkCrit-eria
Exit Command.20 Click: - - Exit Sub
Err Command20 Click: - - MsgBox Err.Description Resume Exit Command20 Click - -
EruiSllb Private Sub Command21 _ Click() On Error Go To Err Command2 l Click - -
Dim stDocName As String Dim stLinkCriteria As String
stDocName = "UnitinStock NewstOne"
stLinkCriteria = "[ProductID]=" & Me![ProductID} DoCrnd.Openf'orrn stDocName,,, stLinkCriteria
Exit Cornmand21 Click: - -
Exit Sub
Err_~d2l_Click: \.r~~~ ~V:~--errption Resume Exit Command21 Click
End Sub Private Sub Command22 _ Click() On Error Go To Err Command22 Click - -
Dim stDocName As String Dim stl.inkCriteria As String
stDocName = "Unitlnstock"
stLinkCriteria = "[Productld]=" & Me![Productll)] DoCmd.OpenForm stDocName,,, stLinkCriteria
Exit Command22 Click: - - Exit Sub
Err Commantl:22 Click: Msg-Box Erl.bescription Reshlri.e Exit Command22 Click - -
End sub Private Sub Command23 _ Click() On Error Go To Err Command23 Click - -
Dim stDocName As String Dim stLink:Criteria As String
stDocName = "Un In Stock NEwst2"
stLinkCriteria == "[Productld]=" & Me![ProductID] DoCmd.OpenForm stDocName,,, stLinkCriteria
Exit Cornmand23 Click: - -
Exit Sub
Err Command23 Click: - Ms:gBox Err.Description Resume Exit Command23 Click
End.Sub Frivate Sub Command25 _ Click() On Error Go To Err Command25 Click - -
66
Dim stD.o.cNarne As String Dtm~~i"i:Wfkl' As String
stDocName = "Unitlnxtock"
• stLink:Criteria = "[Productldj=" & Me![ProductID] DoCrnd.OpenForrn stDocName,,, stl.inkCriteria
Exit Command25 Click: - - Exit Sub
• Err Coinmand25 Click: - - MsgBo~ Err.Description Resume Exit Conunand25 Click
End Sub Private Sub Connnand26 _ Clickf) On Ertot Go To Err Command26 Click
._ Dith stbocNarne As String Dim stLinkCriteria As String
stDocNarhe = "UnitlnStock"
stLink:Criteria = "[ProductID]=" & Me![ProductID] DoCmd.OpenFom1 stDocName,,, stLinkCriteria
Exit Command26 Click: - -
Exit Sub
Err Cornrnand26 Click: Msg-Box Err.Description Resume Exit Connnand26 Click
End Sub Private Sub Command27 _ Clickt) On Error Go To Err Command27 Click - -
Dim .stDocNarne As String Dim stLinkCriteria As String
stDocName = "UnitlnStock1"
stLink:Criteria = "[ProductID]=" & Me![ProductIDJ Dof'md.Openj-orm stDocNrune,,, stLink:Criteria
67
Exit C'Offlhlat1d27 Click: xit~~
Err Command27 Click: - - MsgBox Ert.Desef't~-fi Resume Exit Command27 Click
End Sub Private Sub Command28 _ ClickO On Error GoTo Err Command28 Click - -
Dim stDocName As String Dim stLinkCriteria As String
s1D0cName = "Up.itlnStock"
stLinkCriteria = "[Productlfrj=" & Me!tProductlDJ DoCmd.OpenForm stDocName,,, stLinkCriteria
Exit Cotnmand28 Click: - Exit Sub
Err Comfuand28 Click: MsgBox Ett.D;,cripmm Resume Exit Command28 Click
End&ub Private Sub Command29 _ ClickO On Error Go To Err Comma:nd29 Click
Dim stDocName As String Dim stl.inkCriteria As String
stDocName = "UnitlnStock"
stLinkCriteria = "[ProductID]=" & Me![ProductIDJ DoCmd.OpenForm stDocName,,, stLinkCriteria
Exit Command29 Click: - - Exit Sub
Err Command29 Click: - MsgBox Err.Descriptien Resume Exit Command29 Click - -
68
J
End.W1 ?~_~,,,. aab:Cmt1mand10:.__ Clickf) On Error Go To Err Command30 Click - -
Dim stDocName As String Dim stLinkCriteria As String
stDocName = "Invintory"
stLinkCriteria = "[ProductID]=" & Me![ProductID] DoCmd.OpenForm stDocName,,, stLinkCriteria
Exit Command30 Click: - - Exit Sub
Err Command30 Click: - - MsgBox Err.Description Resume Exit Commandsu Click - -
End.Sub Private Sub Command31 _ Clickt) On Error GoTo Err Command31 Click - -
Dim stDocName As String Dim stLinkCriteria As String
stDocName = "UnitlnStock1"
stLinkCriteria = "[ProductID]=" & Me![ProductID] DoCmd.OpenFom1 stDocName,,, stl.inkCriteria
Exit Command3 l Click: - - Exit Sub
Err Command3 l Click: - - Ms:gBox Err.Description Resume Exit Command3 l Click
Md Suh Private Sub Command33 _ Clickt) On Error Go To Err Command33 Click - -
lmn. stDocName As String Dim stLinkCriteria As String
stDocNrune = "Cus_Payment"
69
J
stLink:Criteria = "fOrderDetailsIDl=" & Me!fOrderDetailsIDl DoCmd. OpenF 01111 stDocName, , , stl.inkx'riteria
Exit Command B Click: - -
Exit Sub
Err Command33 Click: - - Msgfsox Err.Description Resume Exit Command.B Ciick
End Sub Private Sub Conunand34 _ Ciick() On Error Go To Err Command34 Click
u!m stDocNwn~ As Stririg Dim stLinkCriteria As String
stbocNrtine = "Installment" I
s~ptik,Criteria = "[OrderDetailsID]=" & tv1e![OrderDetailsID] D6Cri1d.OpenForm stDocName,,, stLinkCriteria
Exit Coni±hand34 Click: - -
Exit Sub
Err Corhmand34 Click: - - MsgBox Err.Description Resume Exit Command34 Click - -
End Sub Private Sub Command35 _ Click() On Error Go To Err Command35 Click - -
Dim stDocName As String Dim stLink:Criteria As String
stDocName = "Ins OrderDetailsl"
stLink:Criteria = "[OrderDetailsID]=" & Me![OrderDetailsID] DoCmd.OpenFonn stDocName,,, stLink:Criteria
Exit Command35 Click: - -
Exit Sub
Err Conunand35 Click:
70
J
~s.gBox Err.Description Resume Exit Co-mm-and3-:S- Click
- -
End Sub Private Sub Command 100 _ Click() On Error Go To Err Command 100 Click - -
Dim stDocName As String Dim stLinkCriteria As String
stDocN ame = "Installments 1 "
stLinkCriteria = "[OrderDetails_OrderDetailsID]=" & Me![OrderDetailsID] DoCmd.Open.Fonn stDocName,,, stLinkCriteria
Exit Command 100 Click: - - Exit Sub
Eit _ Commartdi OP_ CHclc MsgBox Err.Description Resume Exit Con1111~id 100 Click - -
Ertd Sub Private Sub Conunand3 7 _ Click() On Error Ob To Err Command37 Click - -
Dim sttio~~ame As String Dim stLinkCriteria As String
stfrocblame = "Ins Installments I Subfonn2"
stLinkCriteria = "[OrderDetailsID]=" & Me![OrderDetailsID] DoCmd.OpenFonn stDocName,,, stLinkCriteria
Exit Command37 Click: - -
Exit Sub
Err Command37 Click: - - MsgBox Err.Description Resume Exit Command37 Click
End Sub Private Sub Command38 _ Click() On Error Go To Err Command38 Click - -
Dim stDocName As String
71
D'ifm st't.i?i:ikCriteria As String-
stDocName = "Installment"
stLink:Criteria = "(OrderDetailsID]=" & Me![OrderDetailsID] DoCmd.OpenFonn stDocName,,, stLinkCriteria
Exit Cornmand38 Click: - -
Exit Sub
Err Cornrnand38 Click: - -
MsgBox Err.Description Resuh1e Exit_ Command i 8 _ Click
End $lib Private Sub Co11unai1d39:__ Click() On Error Goto Ert Corrimand'lv Click 1: -
Dim stDocName As String Djm sttinkCriteria As String
stDocName = "Installment" DoCntd.Openform stDocNaine,,, stLinkCriteria
Exit Command.Iv Click: - -
Exit Sub
Err Cominarld39 Click: - - MsgBox Err.Description Resume Exit Command.Iv Click - -
End Sub Private Sub Command40 _ Click() On Error Go To Err Command40 Click - -
IfMe!Tvoe = 0 Then IfMe!Frame56 = 1 Then
Dim stDocName As String Dim stLink:Criteria As String
stDocNaine = "Cus Sub TotalCost"
stLink:Criteria = " [ OrderDetailsID ]=" & Me! [ OrderDetailsID] DoCmd.OpenFonn stDocNaine,,, stLinkCriteria
72
J
- -
-
- -
j
]
Exit Command40 Click: - -
Err Command40 Click: - - MsgBox Err.Description Resume Exit Command40 Click
Else
stDocName = "Cus Sub TotalCostl"
stLinkCriteria = "[OrderDetailsID]=" & Me![Qn:lerDetailslp] D0Cmd.Ope11F01m stDocNanie,,, stl.inkf'riteria
Exit Command.B _ Click: Exit SUb
Ett torlunand13 cii~k: MsgBox Eit.b;scripHb11 Resume Exit Command'[ 3 Click E4<l If .
End If
IfMe!tytje = 1 Then
stDocN"arhe;,, "Cus Sub TotalCost" - -
stl..inkCriteria ± "[OrderDetailsID]=" & Me![OiderDetailsID] DoCmd.OpenFtmn stDocNrune,,, stLinkCriteria
Exit Sub
MggBox Err.Description Resume Exit Command-lu Click
Else IfMe!Type = 2 Then
stDocName = "Cus Sub TotalCostl" - -
stLinkCriteria = "[OrderDetailsID]=" & Me! [OrderDetailsID] DoCmd.OpenFonn stDocName,,, stLink:Criteria
73
J
Exrt Sub-
End If End If
End Sub
Private Sub Frame43 BeforeUpdate(Cancel As Integer) ' -
End.Sub Private Sub Command5 l Click()
' - On Error GoTo Err Command51 Click - -
Dim stDocName As String Dim stLinkCriteria As String
stDocName = "Installmentsl"
· stLinkCriteria = "[OrderIDJ=" & Me![OrderIDJ DoCmd.OpenForm stDocNruue,,, stLinkCriteria
Exit Command5 l Click: - -
Exit Sub
En Command5 l Click: - MsgBox Err.Description Resume Exit Command5 l Click
End Sub Private Sub Command'Sz _ Click() On Error Go To Err Command52 Click - -
Dim stDocName As String Dim stLinkCriteria As String
stDocName = "Installments2"
stLinkCriteria = "[OrderDetailsIDJ=" & Me![OrderDetailsIDJ DoCmd.OpenFonn stDocNruue,,, stLinkCriteria
Exit Command52 Click: - -
Exit Sub
14
0
J
Err Command52 Click: - - 1v1sgBox E1T.Desc1ipt1011 Resume Exit Comrna:nd52 Click
End Sub Private Sub Cornmand53 _ Click() On Error Go To ElT Command5 3 Click - -
Dim stDocName As String Dim stLink:Criteria As String
stDocName = "Installments I"
stLirlkCriteria = "[OtderbetailsID]=" & Me![OrderDetailsID] DoCmd.OpenForm stDocName,,, stLink:Criteria
Exit Cornmand53 Click: - -
Exit Sub
Err Commandfi'I Click: - MsgBox Err.Description Resume Exit Command53 Click
End Sub Private Sub Command55 _ Click() On Error Go To En Command55 Click - -
DoCmd.DoMenultem acFormBar, acRecordsMenu, acSaveRecord,, acMenuVer70
Exit Cornmand55 Click: - -
Exit Sub
Err Cornmand55 Click: - -
MsgBox Err.Description Resume Exit Command55 Click
End Sub Private Sub Command63 _ Click() On En-or Go To Err Command63 Click
DoCmd.GoToRecord,, acNewRec
Exit Command63 Click:
75
0
Exit Sufr
Err Command63 Click: - MsgBox Err.Description Resume Exit Command63 Click
End Sub
Private Sub Cornmando-l _ Click()
Me.AllowEdits = True
End Sub
Private Sub Command70 Clickt) Dim fldEx Dim fel If IsNull(Me.QuantityOrdered) Or Me.QuantityOrdered = "" Then
Else Set rs= db.OpenRecordset("OrderDetails") Set rs = db.OpenRecordset("SELECT * FROM OrderDetails where
OrderDetailsID=" + "124", Type:=dbOpenDynaset)
Me.Text71 = rs.Fields("Intrest").Value Set fldEx = Me.QuantityOrdered Set fel = Me.Text71
Myint= Cint(fldEx) Myint2 = Cint(fel)
If (Myint> Myint2) Then MsgBox "Sorry Units Order More Than Stock..!!!"
Else
MsgBox " .. Order done successfuly .. " DoCmd.DoMenuitem acForm.Bar, acRecordsMenu, acSaveRecord,, acMenuVer70
End If Me. QuantityOrdered. SetF ocus
End If End Sub
Private Sub Form AfterUpdate()
Me.AllowEdits = False
76
J
~s2:B0x "Record Saved" End Sub
Private Sub Form_CurrentO
Me.AllowEdits = False
End Sub
Private Sub Command66 _ Clickt) On EITor Go To EIT Command66 Click - -
DoCmd.GoToRecord,, acNext
Exit _Command66 _ Click: Exit Sub
Err Command66 Click: - MsgBox Err.Description Resume Exit Command66 Click - -
End Sub Private Sub Command67 _ Click() On Error Go To Err Command67 Click
- -
DoCmd.GoToRecord,, acPrevious
Exit Command67 Click: - -
Exit Sub
Err Command67 Click: - - MsgBox Err.Description Resume Exit Command67 Click
End Sub
Private Sub Form Load() Set db = CurrentDb()
End Sub Private Sub Command75 _ Click() On Error Go To Err Command75 Click
- -
DoCmd.DoMenultem acFormBar, acRecordsMenu, acSaveRecord,, acMenuVer70
77
Exit Cornrnand75 Click: - - Exit Sub·
Err Command75 Click: MsgBox Err.Descriptmn Resume Exit Command75 Click
End Sub
Option Compare Database
Private Sub Cornmandz l _ Click()
Me.Allowlidits = True · OrderDate.SdFocus
End Sub
Private Sub Command22_LostFocus()
End Sub
Private Sub Form Beforel.Jndate/Cancel As Intezer) Me.AllowEdits = False - - Mszbox "Record Saved" End Sub
Sub F01m_ Currentt)
Dim ParentDocName As String
On Error Resume Next ParentDocName = Me.Parent.Name Me.AllowEdits = False
If Err <> 0 Then GoTo Form Current Exit - -
Else On Error Go To Form Current Err - - Me.Parentll OrderDetails Subform l .Reauerv
End If
Form Current Exit: - - Exit Sub
7&
I
I
I I
ub Command9 _ ClickQ On Error Go To Err Command9 Click - -
Dim stDocNarne As Strihg Dim stLinkCriteria As String
stDocName = "OverAUOftust_Paymertt"
stLirikCriteria = " [ Orderib l=" & Me! [ OrderID] DoCmd.OpenForn1 stDocName,,, stLinkCriteria
Exit Cornmand9 Click: - -
Exit Sub
Err Command9 Click: - - MsgBox Err.Description Resume Exit Command9 Click
End Sub Private Sub Commandl2_Click() On Error Go To ErT Commandl2 Click - -
Dim stDocNarne As String Dim stLinkCriteria As String
stDocN ame = "Installments 1"
stLinkCriteria = "[OrderID)=" & Me![OrderID] DoCmd.OpenForm stDocName,,, stLinkCriteria
Exit Command12 Click: - -
Exit Sub
Err Commandl 2 Click: - -
MsgBox Err.Description Resume Exit Commandl2 Click
End Sub Private Sub Command20 _ Click()
79
I
arOf Go To Err 'Commandzf Click - -
'md.Go'Tokecord .. acNewRec Order Date. SetF ocus
Exit Command20 Click: - -
Exit Sub
Err_ Command20 _piclc MsgBox Err.Description Resume Exit_ Command20 _ Click
End Sub Private Sub Command22 _ Clickt) On Error GoTo Err Command22 Click - -
DoCmd.DoMenultem acFormBar, ackecordslvlenu, acSaveRecord,, acMenuVer70
Exit Command22 Click: - - Exit Sub
Err Command22 Click: - -
MsgBox Err.Description Resume Exit Command22 Click
End Sub Private Sub Command23 _ Click() On Error Go To Err Command23 Click - -
DoCmd.GoToRecord,, acNext
Exit Command23 Click: - -
Exit Sub
Err Command23 Click: - MsgBox Err.Description Resume Exit Command23 Click
End Sub Private Sub Command24 _ Click() On Error Go To Err Command24 Click
- -
80
DoCmcb.6o1'oRecbrd,, acl'revious
Exit Command24 Click: - - Exit Sub
Err Command24 Click: - -
MsgBox Err.Description Resume Exit Cdi1unand24 Click
End Sub
Private Sub ReauairdDate Lostf'ocusf) - -
Me. Command22. SetF ocus End Sub
End Sub
Private Sub Form Load() Set db = CurrentDb()
End Sub Private Sub Command27 _ Click() On ErrorGo'To Err Command27 Click - -
DoCmd. Close
Exit Command27 Click: - -
Exit Sub
Err Command27 Click: - -
MsgBox Err.Description Resume Exit Command27 Click
End Sub