browsing centre

7/31/2019 browsing centre

1/34

1. INTRODUCTION

The world is witnessing a dramatic change in the computer and information technology sectors. There is a never before increase in the need for computerized system in the organization. Almost all of once human dominated areas have been taken over by the computer .So to maintain a proper computerized network proper software and hardware are needed.

There are many softwares specially designed for this purpose, out of which Visual basic stands number one due its user friendliness. Any user finds easyto work with visual basic than any other software.

To develop a user friendly and secure computerized system I have selected Ms Visual Basic as Front-End and Ms Access as Back-End.

1.2 SYSTEM STUDY

The project entitled Cyber cafe Management System is done by using the softwareVisual Basic as Front End and Ms Access as Back End.

This Project has the following Modules

1) Form:This forms keeps track of the billing table this form is responsible for the various user information like the time for which the user gets the login and the am

ount that he paid for it. It also keeps track of the user name and starting timethis is the base table that is going to be used further.2) Create user form :This form is used to get the detail data of the user who used the system Administrator is the main actor in this system he do the various job the brief detail is given as :3) Entry form:The administrator does the entry of the various machines by name and the code no. And at the same time the starting date is also added to the database. He can also extract the list of the different machines Billing for the whole day or thewhole month or the whole year. This form extracts the data from the data base.4) Exit :By clicking the exit the control again go back to the main user form.

2. ANALYSIS OF THE PROBLEM

2.1 SYSTEM ANALYSIS

Analysis is a detailed study of various operations performed by a systemand their relationship within and outside the system. One aspect of analysis isdefining the boundaries of the system and determining whether a candidate system should consider other related system.


2/34


3/34

Technical feasibility

Before going deep into the system analysis, it is important to make sure whether the project is feasible. There are three steps to be consideredin feasibility analysis. They are1. Technical Feasibility

2. Economic Feasibility

3. Operational Feasibility

OPERATIONAL FEASIBILITY

Operational feasibility deals with if the system is developed, will it be useful for the organization. Since it is connected in the Local Area Network, it is easy for anyone to operate on the system from any part of the organization. And if we need, any details about the entities. Those can be viewed by clicking the search buttons.ECONOMICAL FEASIBILITY

Studying about money spent on this project and whether it is rea

lly worth. The organizational point of view of this project is, How much profit that they can earn from the projects? money incurred in the project development isnot very high and so this project is economically feasible.

TECHNICAL FEASIBILITYStudying what are all the technical needs of the system and whet

her they are affordable to the project. This project needs VB 6.0 as front-end Ms Access as a backend which are already available in the Organization.

2.2ANALYSIS TOOLS

2.2.1 DATA FLOW DIAGRAM

2.2.2 E-R Diagram

2.3 HARDWARE AND SOFTWARE CONFIGURATION

2.3.1 HARDWARE REQUIREMENTS

Monitor : Samsung 56V

Processor : PENTIUM IV 2.66 GHz


4/34


5/34

3. SYSTEM DESIGN

The first step in the system design is to design the input and output wi

thin predefined guidelines. In input design user originated inputs are convertedto a computer- based format. It also includes determining the record media, method of input, speed of capture, and entry into the system. In output design theemphasis is on producing a hard copy of the information requested, or displayingthe output on a CRT monitor screen in a predefined format3.1 INPUT DESIGN

In information systems the input data are entered according to the format, which is already defined. Inaccurate input data are the most common cause oferrors in data entry. These can be controlled by proper input design.

Input design is a process of conversion user organized inputs to a computer base format input data are controlled and organized into groups of similar data. The goal of designing input data is to make data entry as easy, logical & f

ree from errors as possible in visual basic input design is made through forms.

3.2 OUTPUT DESIGN

Computer output is the most vital and direct source of information to the user. A clear-cut output design improves the system relationships with the user and helps in decision-making. A major form of output is a hard copy from the p


6/34

rinter. The printout should be designed around the output requirements of the user. In addition to deciding on the output devices, the system analyst should perform the editing of the file printout. The task of output preparation is critical, requiring skill and ability to align user requirements with the capacities ofthe system in operation.The output of the project is done in such a way that one can view unaltered values of all the records through the forms on the monitor. Navigation is also provided such that one can transverse from one record to another. Another method is also provided which will enable the user to view the current record entered different forms as reports and take a printout of the currently typed record.An application is successful only when it can produce efficient reports. The reports generated must be useful to management and future reference. For the user and management, reports provide a source of information. Reports also provide a permanent hard copy of transactions occurred. Careful consideration has to be given in designing as it helps in decision making.Reports show the monthly and yearly details of the organization. The reports arevery essential to obtain a well-structured project.

.

3.3 SOFTWARE SPECIFICATION

ABOUT THE SOFTWAREMicrosoft Visual Basic 6.0

Visual basic is the fastest and easiest way to create applications for Microsoft windows. Visual basic provides complete set of tools to simplify rapid application development both for experience professional and new windows programmers.

In the same Visual part refers to the method used to create the graphicaluser interface (GUI). Visual basic provides pre-built objects that can be used to form the GUI. The BASIC part refers to the BASIC language and its syntax of statements retained by visual basic.

Features of visual basic

Multiple windows on a screen are possible. Access to clipboard and to the information in the most other windows applicatio Running at a same time is possible. It provides dynamic data exchange. It provides object linking and embedding. It was client-server concept .So any FOXPRO, DBASE,

ACCESS, ORACLE DATABASE can be connected.


7/34

Basic Features

Intelligence

A new feature that Microsoft calls intelligence enables the system to react in real time during encoding.

There are five basic intelligence features:1) Quick Info2) Complete word3) Data Tips4) List members5) List constant

1. Quick info is a feature that presents syntax of the procedure, which is beingtyped, in a loop like window.2. Complete word is a feature that automatically completes the word, which is typed in real time.3. Data tips are very useful feature that simply shows the value of the variable

in yellow tip format at run time.4. List members are the feature is used to simply list the entire properties ormethods available to given object.5. List content is a feature that works the same as the list members feature, except that with these feature available constant values for given property is listed.

Other Features Break Point can be toggled simply with a mouse click. Bookmarks can be placed fr quick location.

Properties in the property window can be manipulated or even by Category.

An interesting feature is block statement and uncomments.

With a click of a mouse button, all highlighted code will be commented or uncmmented.

Designing and formatting can easily be applied to one or more controls


8/34

3.3.2 MS Access (Back-End)

A database is a collection of information related to a particular subject or purpose such as tracking customer orders or maintaining a music collection. If ourdatabase is not stored on a computer or only parts of it are we may be trackinginformation from a variety of sources.

Using Microsoft access we can manage all our information from a single databasefile. Within the file, divide our data using online forms. We can find and retrieve just the data we want using queries.

To store data create one table to for each type of information we track. To bring the data from multiple table together queries, form or report we define relationship between the tables.To find and retrieve just the data that needs conditions we specify including data from multiple tables create a query. A query can also be updated or deleted multiple records at the same time, and perform build-in or custom calculations onour data.

A table is a collection of data of about a specific topic such as products or suppliers or employees. Using a separate table for each topic means we store that data only once, which makes our database more efficient and reduces data-entry errors. Tables organize data into columns called fields and rows called records.

FEATURESMicrosoft Access offers some significant performance improvements.

Improved wizards that sense relationship and automatically create relationship Lightweight forms and reports. Improved compiled-state management data. Active x control speed.

4. Testing and Maintenance

SYSTEM TESTING

System Testing is the process of checking the developed system in working according to the original objectives and requirements. Initially the system should be tested experimentally with the test data so as to ensure that software is working according to the specification, and the way the user expect if to work. When it is found to be working in the right manner then the actual data is fedand the whole system is tested to check its performance. It is also important that system correctly identifies the errors.


9/34

UNIT TESTING

This type of testing deals with the testing of different modules of thesoftware. It checks for any errors in each of these modules in the software.

INTEGRATION TESTING

During this phase of testing all the modules in the software are combined or integrated together and they are tested for the overall performance of thesystem.

ACCEPTANCE TESTING

This phase of testing deals with the acceptance part of the system software. It checks for the proper functioning of all the given validations (i.e.) rules.

CONTROL STRUCTURE TESTING

The basic path testing technique is one of the numbers of technique forcontrol structure testing. These broaden testing coverage and improve the quality of white box testing. Control Structure Testing performs the following. Condition testing Data flow testing

Loop testing Simple testing Nested loops

WHITE BOX TESTING

White box testing is a test case design method that uses the control structure of the procedure design to derive test cases.In the testing approach of testing tests are made with the complete knowledge about internal working of the transportation system. Test can be conducted to allinternal operations of the transportation system.

BLACK BOX TESTING

In this testing approach to testing test case are prepared with the knowledge about the functions that the transportation system is designed to perform.This approach saves time and energy. Mainly this test concentrates the logicalmethods of the entire system.The attributes both white box testing and black box testing can be combined to provide an approach that validates the software interface and selectivity ensuresthat the internal working of the software and correct.


10/34

5. APPENDIX

5.1 TABLES

Sno Fieldname Datatype Size Constraint Description1 VoucherNo Number - Primary Voucher Number2 Name Text - Name Of TheCustomer3 PermanentAddress Text - Permanent Address4 PhoneNo Text - Phone Number5 Nationality Text - Nationality6 EMailId Text - E-MailId7 ArrivalDate Date/Time - Arrival Date8 DepartureDate Date/Time - Departure Date9 NoOfDaysStayed Number - Number Of Days Stayed

TABLENAME: CUSTOMER DETAILS

TABLENAME: EMPLOYEE DETAILS

Sno Fieldname Datatype Size Constraint Description1 EID Number - Employee Id2 EName Text - Employee Name3 Address Text - Address4 Qualification Text - Qualification5 Designation Text - Designation6 DOJ Date/Time - Date of Joining7 DepName Text - Department Name

8 PhoneNo Text - Phone Number9 Specialization Text - Place10 SOP Currency - Scale Of Pay11 YIncrement Currency - Yearly Increment12 HRA Currency - Allowance13 DA Currency - DA14 PF Currency - Provident Fund

TABLENAME: MASTER DETAILS

Sno Fieldname Datatype Size Constraint Description1 CustomerName Text - Customer Name2 System No Text - System Number3 InTime Text - In Time4 Out Time Text - Out Time5 TotalTime Text - Total Time6 TotalRs Text - Total Rs7 Signature Text - Signature8 Date Text - Date9 PRRate Text - PR Rate


11/34

10 NOPR Currency - NO Pr11 ScanAmt Currency - Scan Amount12 Total Currency - Total

TABLENAME: CUSTOMER DETAILS

Sno Fieldname Datatype Size Constraint Description1 CustomerName Text - Customer Name2 System Number Text - System Number3 LogInTime Text - Log In Time5.2 FORMS

1. WELCOME FORM

2. MDI FORM


12/34

3. ADD CUSTOMER DETAILS FORM

4. PAYMENT FORM

5. PAYMENT RECEIVE DETAILS

6. CALENDER DETAILS


13/34

5.3 REPORTS

1. SHOW ALL RECORD DETAILS

5.4 CODINGS

1. ABOUT FORM:

Private Declare Function sndplaysound Lib "Winmm.dll" Alias "sndPlaySoundA" (ByVal lpszsoundName As String, ByVal uflags As Long) As Long

Dim str As StringDim b As IntegerDim i As IntegerDim PI, Radius, Radians As Double

Private Sub Form_Load()PI = 3.14159265358979Radius = 1680str = "Cyber Master... By Vicky! [email protected]"b = Len(str)i = 1End Sub

Private Sub Timer1_Timer()Me.Caption = Left(str, i)i = i + 1If i = b + 1 ThenTimer1.Interval = 3000

i = 0End IfEnd SubOption Explicit

Dim k As IntegerDim text As StringDim Text2 As StringDim a As String


14/34

Dim str As StringDim b As IntegerDim i As IntegerDim PI, Radius, Radians As Double

Private Sub Form_Click()sndplaysound (App.Path & "\1.wav"), 1Main.ShowUnload MeEnd Sub

Private Sub Form_KeyPress(KeyAscii As Integer)If KeyAscii = 27 Thensndplaysound (App.Path & "\1.wav"), 1Main.Show

Unload MeEnd If

End Sub

Private Sub Form_Load()PREVENTS FROM MORE THAN ONE INSTANCE RUNNINGIf App.PrevInstance = True Then End>>>>>>>>>>>>>>>>>>>>>

k = 0text = "Programmer Writer" & vbCrLf & " from India " & vbCrLf & "Cyber Master(Version 1.0)!" & vbCrLf & "Perfect Cyber Cafe Manager Programme Specially designedfor Cyber Cafe s" & vbCrLf & " Vote me on"Text2 = "Browsing Centre Management System"

SetWindowPos Me.hwnd, -1, Me.Left / 15, _Me.Top / 15, Me.Width / 15, _

Me.Height / 15, &H10 Or &H40

PI = 3.14159265358979Radius = 1680str = "Cyber Master (Version 1.0)"b = Len(str)i = 1

End Sub

Private Sub Form_Unload(Cancel As Integer)sndplaysound (App.Path & "\1.wav"), 1Main.ShowEnd Sub

Private Sub Label1_Click()Unload MeEnd Sub

Private Sub Label2_Click()


15/34

Unload MeEnd Sub

Private Sub Timer1_Timer()Me.Caption = left(str, i)i = i + 1If i = b + 1 ThenTimer1.Interval = 3000i = 0End IfEnd Sub

Private Sub Timer2_Timer()k = k + 1a = Mid(text, k, 1)Label1.Caption = Label1.Caption + aIf k >= Len(text) Then

Timer2.Enabled = FalseTimer3.Enabled = Truea = ""k = 0

End If

End Sub

Private Sub Timer3_Timer()k = k + 1a = Mid(Text2, k, 1)Label2.Caption = Label2.Caption + aIf k > Len(Text2) Then

Timer3.Enabled = FalseTimer4.Enabled = True

End If

End Sub

2. CALENDER DETAILS


Private Sub Form_Unload(Cancel As Integer)sndplaysound (App.Path & "\1.wav"), 1Main.Show

End Sub

Private Sub MonthView1_MouseMove(Button As Integer, Shift As Integer, x As Single, y As Single)MonthView1.ToolTipText = Time & DateEnd Sub


16/34

3. HEAD DETAILS


Private Sub MDIForm_Unload(Cancel As Integer)sndplaysound (App.Path & "\1.wav"), 1End Sub

Private Sub mnuabout_Click()sndplaysound (App.Path & "\Click.wav"), 1About.ShowMain.HideEnd Sub

Private Sub mnucas_Click()On Error GoTo ErrHandlerMe.Arrange vbCascadeExit Sub

ErrHandler:

Dim ErrNum, ErrDesc, ErrSourceErrNum = Err.NumberErrDesc = Err.DescriptionErrSource = Err.SourceMsgBox "Error# = " & ErrNum & vbCrLf & "Description = " & ErrDesc & vbCrLf &

"Source = " & ErrSource, vbCritical + vbOKOnly, "Program Error!"Err.ClearExit Sub

End Sub

Private Sub mnuexit_Click()sndplaysound (App.Path & "\1.wav"), 1

EndEnd Sub

Private Sub ToolBar_ButtonClick(ByVal Button As MSComctlLib.Button)If Button.Index = 1 Thensndplaysound (App.Path & "\Click.wav"), 1Main.Show

ElseIf Button.Index = 3 Thensndplaysound (App.Path & "\Click.wav"), 1

Main.HideRecord.Show

ElseIf Button.Index = 7 Thensndplaysound (App.Path & "\Click.wav"), 1Main.HideAbout.Show


17/34

ElseIf Button.Index = 5 Thensndplaysound (App.Path & "\Click.wav"), 1Main.HideCalinder.Show

ElseIf Button.Index = 9 Thensndplaysound (App.Path & "\Click.wav"), 1Unload Me

ElseIf Button.Index = 11 Thensndplaysound (App.Path & "\Click.wav"), 1Timer.ShowMain.HideEnd IfEnd Sub

Private Sub ToolBar_ButtonMenuClick(ByVal ButtonMenu As MSComctlLib.ButtonMenu)

sndplaysound (App.Path & "\click.wav"), 1If ButtonMenu.Index = 1 ThenMiddle.Show

sndplaysound (App.Path & "\click.wav"), 1ElseIf ButtonMenu.Index = 2 ThenInfo.Show

sndplaysound (App.Path & "\click.wav"), 1ElseIf ButtonMenu.Index = 3 ThenUnload Me

End IfEnd Sub

4. INFO COUNT DETAILS


Dim dn As New ADODB.ConnectionDim rs As New ADODB.RecordsetDim RS1 As New ADODB.RecordsetDim RS1_COUNT As New ADODB.RecordsetDim in_time As DateDim out_time As DateDim h As DoubleDim m As Double

SCORL FORM TITLEDim x As IntegerDim y As IntegerDim prev As String

Private Sub Command1_KeyPress(Index As Integer, KeyAscii As Integer)If KeyAscii = 27 Then


18/34

Unload MeEnd If

End Sub

Private Sub Command2_Click(Index As Integer)RS1.CloseRS1_COUNT.CloseRS1.Open "select * from CURRENT_CUSTOMER WHERE SYSTEM_NO=" & Index + 1RS1_COUNT.Open "select count(*) from CURRENT_CUSTOMER WHERE SYSTEM_NO=" & Index+ 1

If RS1_COUNT.Fields(0).Value = 1 Then

Last.SYS_NO = Index + 1

in_time = RS1.Fields(2) .Value

out_time = Now

Last.Text1 = RS1.Fields(0).ValueLast.Text2 = RS1.Fields(1).ValueLast.Text3 = RS1.Fields(2).ValueLast.Text4 = out_time

Last.Text9 = Clear

Last.Text9 = DateDiff("n", in_time, out_time)

m = Val(Last.Text9) Mod 60 h = (Last.Text9) / 60

h = Int(h)Last.Text5.text = Val(h)

Last.Text9.text = Val(m)

If DatePart("h", in_time) >= 22 Then MsgBox DatePart("h", in_time)

If DatePart("h", in_time) = 24 Then If Val(Form3.Text9)


19/34

Form3.Text7 = (Val(Form3.Text9) * 15) / 60 End If Form3.Text7 = Val(Form3.Text7) + (Val(Form3.Text5) * 15) End IfIf DatePart("h", in_time) >= 0 Then If DatePart("h", in_time)


20/34

End IfEnd Sub

Private Sub Form_Load()dn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\CAFE_DA

TABASE.mdb;Persist Security Info=False"rs.Open "select * from CURRENT_CUSTOMER", dn, adOpenDynamic, adLockOptimisticRS1.Open "select * from CURRENT_CUSTOMER", dn, adOpenDynamic, adLockOptimisti

cRS1_COUNT.Open "select count(*) from current_customer", dn, adOpenDynamic, ad

LockOptimisticWhile rs.EOF True

Label1(rs.Fields(1).Value - 1).Caption = rs.Fields(0).Valuers.MoveNext

Wend

SCORL FORM TITLE FROM HEREprev = "Information & Collect Customers Payment.. "

x = Len(prev)y = 1

End Sub

Private Sub Form_Unload(Cancel As Integer)sndplaysound (App.Path & "\1.wav"), 1dn.Close

End Sub

Private Sub Timer1_Timer()Info.Caption = Mid$(prev, y, x)y = y + 1If y > x Theny = 1End IfEnd Sub

Private Sub xpButton1_Click(Index As Integer)sndplaysound (App.Path & "\click.wav"), 1

RS1.CloseRS1_COUNT.CloseRS1.Open "select * from CURRENT_CUSTOMER WHERE SYSTEM_NO=" & Index + 1RS1_COUNT.Open "select count(*) from CURRENT_CUSTOMER WHERE SYSTEM_NO=" & Index+ 1

If RS1_COUNT.Fields(0).Value = 1 Then

Last.SYS_NO = Index + 1

in_time = RS1.Fields(2).Value

out_time = Now


21/34

Last.Text1 = RS1.Fields(0).ValueLast.Text2 = RS1.Fields(1).ValueLast.Text3 = RS1.Fields(2).ValueLast.Text4 = out_time

Last.Text9 = Clear

Last.Text9 = DateDiff("n", in_time, out_time)

m = Val(Last.Text9) Mod 60h = (Last.Text9) / 60h = Int(h)

Last.Text5.text = Val(h)Last.Text9.text = Val(m)

If DatePart("h", in_time) >= 22 Then MsgBox DatePart("h", in_time)

If DatePart("h", in_time) = 24 Then If Val(Form3.Text9)


22/34

ElseIf Val(Last.Text9)


23/34


24/34

dn.CloseEnd Sub

Private Sub Text6_LostFocus()If Val(Text9)


25/34

Private Sub Txt2_Change()Txt2.ToolTipText = "The Amount Has been Changed"End Sub

Private Sub Txt2_Click()Txt2.Locked = TrueEnd Sub

Private Sub Txt2_DblClick()Txt2.Locked = FalseEnd Sub

Printer Amt

Private Sub TxtP_Change()On Error GoTo MariaDim Vicky As IntegerDim Jenny As IntegerVicky = Txt1.textJenny = TxtP.textXpAmount.Caption = Vicky * JennyMaria:If Err.Number = 13 Then

MsgBox "Please Enter the Number of prints u have taken", vbInformation, "Cyber Master (Version 1.0)"End IfEnd Sub

Scanner Amt

Private Sub Txts_Change()On Error GoTo VickyDim Britney As IntegerDim Lopez As IntegerBritney = Txt2.textLopez = Txts.text

XpScan.Caption = Britney * LopezVicky:If Err.Number = 13 ThenMsgBox "Please Enter the Number of Scan s u have taken", vbInformation, "Cyber Master (Version 1.0)"End IfEnd Sub

Private Sub xpButton2_Click()On Error GoTo VickyDim i As IntegerDim L As Integeri = Text7.text

L = Txt2.texttxttotal = i + LVicky:If Err.Number = 13 ThenMsgBox "Please Enter Number or Prints and Scan", vbInformation, "Cyber Master"End IfEnd Sub

Private Sub XpCount_Click()Timer2.Enabled = True


26/34

ProgCount.Value = 0End Sub

Private Sub Doing()Dim Num1 As IntegerDim Num2 As IntegerDim Num3 As IntegerNum1 = Text7.textNum2 = XpAmount.CaptionNum3 = XpScan.Captiontxttotal = Num1 + Num2 + Num3End SubPrivate Sub XpAmount_Click()Dim Kadie As IntegerDim Aviril As IntegerKadie = Text7.textAviril = XpAmount.Captiontxttotal = Kadie + AvirilEnd Sub

Private Sub XpScan_Click()Dim Kadie As IntegerDim Aviril As IntegerKadie = Text7.text

Aviril = XpAmount.Captiontxttotal = Kadie + AvirilEnd Sub

6. LOADING DETAILS


Private Sub Form_Unload(Cancel As Integer)sndplaysound (App.Path & "\1.wav"), 1

End Sub

this will make ur progress bar RunPrivate Sub Timer1_Timer()

On Error GoTo Rani:

With PROGLOAD.Value = .Value + 1

End WithExit SubRani:

If Err.Number = 380 Thensndplaysound (App.Path & "\click.wav"), 1

Unload MeHead.Show vbModal


27/34

Main.ShowEnd If

End Sub7. MAIN DETAILS


scorols form titleDim x As IntegerDim y As IntegerDim prev As String

Private Sub Form_Unload(Cancel As Integer)sndplaysound (App.Path & "\1.wav"), 1End Sub

Private Sub Timer1_Timer()Time1a.Caption = TimeMain.Caption = Mid$(prev, y, x)y = y + 1If y > x Then

y = 1End IfEnd Sub

Private Sub Form_Load()prev = " Cyber Master version (1.0) Perfect management software! Sai softwares Creation. "x = Len(prev)y = 1End Sub

Private Sub CmdAdd_Click()sndplaysound (App.Path & "\click.wav"), 1

Middle.Show vbModalMe.HideEnd Sub

Private Sub CmdEnd_Click()sndplaysound (App.Path & "\1.wav"), 1Unload MeEnd Sub

Private Sub CmdGet_Click()sndplaysound (App.Path & "\click.wav"), 1Info.Show vbModalEnd Sub

Private Sub xPABOUT_Click()sndplaysound (App.Path & "\click.wav"), 1About.Show vbModalMain.HideEnd Sub

Private Sub xpButton1_Click()Record.ShowEnd Sub


28/34

8. CUSTOMER RECORDS AND INFORMATION DETAILS

This will play Wave filesPrivate Declare Function sndplaysound Lib "Winmm.dll" Alias "sndPlaySoundA" (ByVal lpszsoundName As String, ByVal uflags As Long) As Long

This Connects ur DetabaseDim dn As New ADODB.ConnectionDim rs As New ADODB.Recordset

will scorl the form titleDim x As IntegerDim y As IntegerDim prev As String

Private Sub CmdSave_Click()sndplaysound (App.Path & "\click.wav"), 1

If Len(txtName.text) = 0 ThenMsgBox "Please enter the customer name", vbInformation, "Customer name !!!"

ElseIf Len(txtsysno.text) = 0 ThenMsgBox "Please Assign the system number", vbInformation, "System Number !!!"

ElseIf Len(txtnow.text) = 0 ThenMsgBox "Please assign the Incoming time", vbInformation, "In_Time !!!"

Elsers.AddNewrs.Fields(0).Value = txtName.text

rs.Fields(1).Value = txtsysno.textrs.Fields(2).Value = txtnow.textrs.Update

Unload MiddleEnd IfEnd Sub

Private Sub CmdSave_KeyPress(KeyAscii As Integer)If KeyAscii = 27 Thensndplaysound (App.Path & "\click.wav"), 1Unload MeEnd If

End Sub

Private Sub Cmdtime_Click()sndplaysound (App.Path & "\click.wav"), 1

lbltime.Caption = Time & Datetxtnow.text = Time & DateCmdSave.Enabled = TrueEnd Sub


29/34

Private Sub Cmdtime_KeyPress(KeyAscii As Integer)If KeyAscii = 27 Thensndplaysound (App.Path & "\click.wav"), 1Unload MeEnd If

End Sub

Private Sub Form_Load()dn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\CAFE_DATABASE.mdb;Persist Security Info=False"rs.Open "select * from CURRENT_CUSTOMER", dn, adOpenDynamic, adLockOptimistic

While rs.EOF TrueSys1(rs.Fields(1).Value - 1).BackColor = &H808080Sys1(rs.Fields(1).Value - 1).Enabled = Falsers.MoveNextWend

Picture1(0).Visible = FalsePicture1(1).Visible = FalsePicture1(2).Visible = False

Picture1(3).Visible = FalsePicture1(4).Visible = FalsePicture1(5).Visible = FalsePicture1(6).Visible = FalsePicture1(7).Visible = FalsePicture1(8).Visible = FalsePicture1(9).Visible = False

this will scrole the form titleprev = " CUSTOMER RECORD & INFORMATIONS... "x = Len(prev)y = 1

End Sub

Private Sub Form_Unload(Cancel As Integer)sndplaysound (App.Path & "\1.wav"), 1dn.CloseMain.ShowEnd Sub

Private Sub Sys1_Click(Index As Integer)

sndplaysound (App.Path & "\click.wav"), 1

txtsysno.text = Index + 1

If txtsysno.text = 1 ThentxtName.text = "Pc 1"Picture1(0).Visible = TruePicture1(1).Visible = FalsePicture1(2).Visible = FalsePicture1(3).Visible = FalsePicture1(4).Visible = FalsePicture1(5).Visible = False


30/34

Picture1(6).Visible = FalsePicture1(7).Visible = FalsePicture1(8).Visible = FalsePicture1(9).Visible = FalseCmdtime.Enabled = True

ElseIf txtsysno.text = 2 ThentxtName.text = "Pc 2"Picture1(1).Visible = TruePicture1(0).Visible = FalsePicture1(2).Visible = FalsePicture1(3).Visible = FalsePicture1(4).Visible = FalsePicture1(5).Visible = FalsePicture1(6).Visible = FalsePicture1(7).Visible = FalsePicture1(8).Visible = FalsePicture1(9).Visible = FalseCmdtime.Enabled = True

ElseIf txtsysno.text = 3 ThentxtName.text = "Pc 3"Picture1(2).Visible = TruePicture1(0).Visible = False

Picture1(1).Visible = FalsePicture1(3).Visible = FalsePicture1(4).Visible = FalsePicture1(5).Visible = FalsePicture1(6).Visible = FalsePicture1(7).Visible = FalsePicture1(8).Visible = FalsePicture1(9).Visible = FalseCmdtime.Enabled = True

ElseIf txtsysno.text = 4 ThentxtName.text = "Pc 4"Picture1(3).Visible = True

Picture1(0).Visible = FalsePicture1(1).Visible = FalsePicture1(2).Visible = FalsePicture1(4).Visible = FalsePicture1(5).Visible = FalsePicture1(6).Visible = FalsePicture1(7).Visible = FalsePicture1(8).Visible = FalsePicture1(9).Visible = FalseCmdtime.Enabled = True

ElseIf txtsysno.text = 5 ThentxtName.text = "Pc 5"

Picture1(4).Visible = TruePicture1(0).Visible = FalsePicture1(1).Visible = FalsePicture1(2).Visible = FalsePicture1(3).Visible = FalsePicture1(5).Visible = FalsePicture1(6).Visible = FalsePicture1(7).Visible = FalsePicture1(8).Visible = FalsePicture1(9).Visible = False


31/34

Cmdtime.Enabled = True

ElseIf txtsysno.text = 6 ThentxtName.text = "Pc 6"Picture1(5).Visible = TruePicture1(0).Visible = FalsePicture1(1).Visible = FalsePicture1(2).Visible = FalsePicture1(3).Visible = FalsePicture1(4).Visible = FalsePicture1(6).Visible = FalsePicture1(7).Visible = FalsePicture1(8).Visible = FalsePicture1(9).Visible = FalseCmdtime.Enabled = True

ElseIf txtsysno.text = 7 ThentxtName.text = "Pc 7"Picture1(6).Visible = TruePicture1(0).Visible = FalsePicture1(1).Visible = FalsePicture1(2).Visible = FalsePicture1(3).Visible = FalsePicture1(4).Visible = False

Picture1(5).Visible = FalsePicture1(7).Visible = FalsePicture1(8).Visible = FalsePicture1(9).Visible = FalseCmdtime.Enabled = True

ElseIf txtsysno.text = 8 ThentxtName.text = "Pc 8"Picture1(7).Visible = TruePicture1(0).Visible = FalsePicture1(1).Visible = FalsePicture1(2).Visible = FalsePicture1(3).Visible = False

Picture1(4).Visible = FalsePicture1(5).Visible = FalsePicture1(6).Visible = FalsePicture1(8).Visible = FalsePicture1(9).Visible = FalseCmdtime.Enabled = True

ElseIf txtsysno.text = 9 ThentxtName.text = "Pc 9"Picture1(8).Visible = TruePicture1(0).Visible = FalsePicture1(1).Visible = FalsePicture1(2).Visible = False

Picture1(3).Visible = FalsePicture1(4).Visible = FalsePicture1(5).Visible = FalsePicture1(6).Visible = FalsePicture1(7).Visible = FalsePicture1(9).Visible = FalseCmdtime.Enabled = True

ElseIf txtsysno.text = 10 ThentxtName.text = "Pc 10"


32/34

Picture1(9).Visible = TruePicture1(0).Visible = FalsePicture1(1).Visible = FalsePicture1(2).Visible = FalsePicture1(3).Visible = FalsePicture1(4).Visible = FalsePicture1(5).Visible = FalsePicture1(6).Visible = FalsePicture1(7).Visible = FalsePicture1(8).Visible = FalseCmdtime.Enabled = True

End IfEnd Sub

Private Sub Sys1_KeyPress(Index As Integer, KeyAscii As Integer)If KeyAscii = 27 Thensndplaysound (App.Path & "\click.wav"), 1Unload MeEnd If

End Sub

Private Sub Timer1_Timer()

Middle.Caption = Mid$(prev, y, x)y = y + 1If y > x Theny = 1End IfEnd Sub

Private Sub txtName_KeyPress(KeyAscii As Integer)If KeyAscii = 27 Thensndplaysound (App.Path & "\click.wav"), 1Unload Me

End IfEnd Sub

9. RECORD DETAILS

Option Explicit


Private Sub Command1_Click()sndplaysound (App.Path & "\Click.wav"), 1

Dim db As New ADODB.ConnectionDim rs As New ADODB.Recordset

MSFlexGrid1.Visible = Falsedb.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\CAFE_DATABASE.mdb;Persist Security Info=False"


33/34

rs.Open "SELECT * FROM MASTER_TABLE", db, adOpenStatic, adLockReadOnlyrs.MoveFirst

MSFlexGrid1.Rows = rs.RecordCount + 1MSFlexGrid1.Cols = rs.Fields.Count - 1MSFlexGrid1.Row = 1MSFlexGrid1.Col = 0MSFlexGrid1.RowSel = MSFlexGrid1.Rows - 1MSFlexGrid1.ColSel = MSFlexGrid1.Cols - 1MSFlexGrid1.Clip = rs.GetString(adClipString, -1, Chr(9), Chr(13), vbNullString)MSFlexGrid1.Row = 1MSFlexGrid1.Visible = True

End Sub

Private Sub Form_Resize()Dim Ctl As Control, CtlCln As New Collection

On Error Resume NextFor Each Ctl In Controls

If Ctl.left < 0 Then CtlCln.Add CtlNext

Add the code to resize the controls:

MSFlexGrid1.Move 0 * ScaleWidth, 0 * ScaleHeight, _1 * ScaleWidth, 0.9 * ScaleHeight

Command1.Move 0.001 * ScaleWidth, 0.9 * ScaleHeight, _0.6 * ScaleWidth, 0.1 * ScaleHeight

XPCLO.Move 0.6 * ScaleWidth, 0.9 * ScaleHeight, _

0.4 * ScaleWidth, 0.1 * ScaleHeight

NOTE: The Height property can t be changed for the DriveListBox control or for the ComboBox control, whose Style property setting is 0 (Dropdown Combo) or 2 (Dropdown List). See the REFERENCES section for an article that discusses how to resize a ComboBox.

For Each Ctl In CtlClnIf Ctl.left > 0 Then Ctl.left = Ctl.left - 75000Next

End Sub

Private Sub Form_Unload(Cancel As Integer)sndplaysound (App.Path & "\1.wav"), 1Main.ShowEnd Sub

Private Sub XPCLO_Click()Unload MeEnd Sub

6. CONCLUSION

In every organization, computerization plays the most important role in


34/34

day-to-day activities. The computerization of inventory system is reliable and very easy to use. It saves a lot of time and is very efficient. The flexibility of the program developed is quite high.

The use of computerization with my project has very little chance of committing any data entry error since it has enough validation check. The systemis flexible and changes can be made without any difficulties. The system is tested with possible sample data before any valid data is inputted.

The system has been developed to do most of the transactions. The manual system resulted in loss of times as well as errors in transactions that resulted in minor loss.

The system has been developed using Visual basic with the help of access, the system was able to process and update the database with more ease. It helped in developing a total integrated system. The successful completion of the resulted in

Elimination of manual processing. The system is user friendly with GUI and tool tipo help. Fast data processing compared to manual processing. Generation of report.

7.BIBLIOGRAPHY

SYSTEM ANALYSIS DESIGN

-Elias M.Awad.

DATABASE MANAGEMENT SYSTEM

-Bipin. C. Desai

PROGRAMMING WITH VISUAL BASIC

-Mohammed Azam

MS ACCESS

-D.P Nagpal

SOFTWARE ENGINEERING

-Roger.S.Pressman

browsing centre

Documents