anjala devi project
Post on 03-Apr-2018
215 Views
Preview:
TRANSCRIPT
-
7/28/2019 Anjala Devi Project
1/97
I G N O U
MINI PROJECT REPORT
ONHOSPITAL MANAGEMENT
SYSTEM
Front End : Microsoft Visual Basic 6.0
Backend : Microsoft Access 2003
Submitted By: Ms. ANJALA DEVI
Enrolment No.: 119206105
MCA 4th Sem. (MCSL-044)
UNDER THE GUIDANCE OF:
SANJAY MANHAS
ASSISTANT PROGRAMMER
DEPARTMENT OF COMPUTER SCIENCE & IT,
UNIVERSITY OF JAMMU
1
-
7/28/2019 Anjala Devi Project
2/97
CONTENTSS.No. Description
1 Acknowledgement
2 Introduction
3 System Environment
5. System Study
6 Software Description
Microsoft Visual basic
Microsoft Access
7 Database Design
8 Source Code
9 Screenshots
10 System Implementation
11 Software Testing
12 Conclusion
14 Bibliography
2
-
7/28/2019 Anjala Devi Project
3/97
ACKNOWLEDGEMENT
I express my deep sense of gratitude and sincere thanks to myrevered project guide Sanjay Manhas, Assistant Programmer
University of Jammu for his able guidance, constant encouragement,
invaluable suggestion and continued interest through out, with out
which the present work not have possible.
ANJALA DEVI
MCA-4th
3
-
7/28/2019 Anjala Devi Project
4/97
Introduction
Project on Hospital Management Information System is
developed by Anjala Devi for providing fully computerized
system of Hospital Management Information System to
users.
With the help of this project, we are making efforts to fullycomputerize the systems of Hospital by providing different
services to the patients.
4
-
7/28/2019 Anjala Devi Project
5/97
Goals to be Achieved
The basic objective of the creation of this project is toprovide best and objective oriented services to the
customers of the Hospital Management
Information System. Some important goals are as
follows:
To develop a form based VB application which
connects to a database.
5
-
7/28/2019 Anjala Devi Project
6/97
To store all information about customers and
transactions in the database.
To print Reports.
To allow online updating of the database whenever
required.
User Level Security.
Customer Friendly Approach.
Computerized bill will cover all expenses of the
services provided to the customers.
Configuration
Hardware Requirement1)RAM 128 MB (Min)
2)HARDDISk 40 GB
3)MONITOR 15
4)PROCESSOR Intel Pentium II
6
-
7/28/2019 Anjala Devi Project
7/97
SOFTWARE REQUIREMENT1) FRONTEND Visual Basis 6.0
2) BACKEND Microsoft Access
2003
3) OPERATING SYSTEM Microsoft XP SP-2
7
-
7/28/2019 Anjala Devi Project
8/97
Languages / Packages Used
The various languages / tools that are used during the
development of the project are:
Visual Basic: The Visual Basic is used as our main tool
for the development of the project. This tool is used as
front-end of the application. The whole application has
been created using this. It is a very powerful object
oriented programming language through which we can
design our application by creating different forms,
modules, reports etc. However, some other tools also
have been used.
Microsoft Access 7.0: This tool is used basically to
work within database. This tool is used as back-end of
the application. It is a Package of Microsoft and we can
create the design of table and can enter the records in
table. As well as, we can create forms, queries, reports,
macros and module by using this package.
Database Connectivity: The project is also having
database connectivity which in turn uses Access for
storing the database.
8
-
7/28/2019 Anjala Devi Project
9/97
ENTITY-RELATIONSHIP DIAGRAM
It is tool for problem analysis often called as E-R diagram.
It was originally proposed by Petersen for the design of
relational database systems and has been extended by
others. Its detailed logical representation of the data from
an organization and uses three main constructs i.e. data
entities, relationships, and their associated attributes.
ENTITIES
An entities is a fundamental thing of an organization about
which data may be maintained. An entity type is the
description of all entities to which a common definition and
common relationships and attributes apply. Entity type is
represented with the help of rectangular, name of entity is
written inside it.
RELATIONSHIPS
9
-
7/28/2019 Anjala Devi Project
10/97
A relationship is a reason for associating two entity types.
These relationships are sometimes called binary relationship
because they involve two entity types. Some forms of data
model allow more than two entity types to be associated.
Relationships are represented by diamond notation in E-R
diagram.
FOLLOWING IS THE E-R DIAGRAM
ASSOCIATED WITH THIS
PROJECT:
10
PATIENTS
-
7/28/2019 Anjala Devi Project
11/97
VISUAL BASIC
Visual basic, is the fastest and easiest way to create
applications for Microsoft Windows. Whether we are an
experienced professional or brand new to windows
programming. Visual basic provides you with a set of tools
to simplify rapid application development.
In visual Basic, visual part refers to the method
used to create the graphical user interface (GUI). Rather
than writing numerous lines of code to describe the
appearance and location of interface elements, we simply
add prebuilt objects into place on screen. If youve ever
used a drawing program such as paint, we already have
11
ENT
DEPART
MENT
EI
B
L
O
GR
A
P
H
Y
S.NO
Name oftheBook
Author
ORTHO
DEPART
MENT
SURGICAL DEPARTMENT
-
7/28/2019 Anjala Devi Project
12/97
most of the skills necessary to create an effective user
interface.
The Basic part refers to he basic (Beginners All Purpose
symbolic Instruction Code) language, a language used by
more programmers than any other language in the history of
computing. Visual Basic has evolved from the original BASIC
language and now contains several hundred statements,
functions and keywords many of which relate directly to the
Windows GUI. Beginners can create useful applications by
learning just a few of the keywords, yet the power of the
language allows professionals to accomplish anything that
can be accomplished using ant other Windows programming
language.
The Visual Basic programming language is not
unique to Visual Basic. The Visual Basic programming
system, Applications Edition included in Microsoft Excel,
Microsoft Access and many other Windows applications uses
the same language. The Visual Basic Scripting Edition
(VBSCRIPT) is a widely used scripting language and a
subject of the Visual Basic language. The investment you
make in learning Visual Basic will carry over to these other
areas.
12
SystemAnalysisandDesign
Awadh
2MS-
Access
R.BPatel
3
Introduction todatabase
BipinC
Managemen
t
-
7/28/2019 Anjala Devi Project
13/97
Data access features allow us to create databases,frontend applications and scalable server-side components
for most popular database formats including Microsoft SQL
Server and other enterprise-level databases.
ActiveX TM technologies allow us to use the functionality
provided by other applications such as Microsoft Word
Processor, Microsoft Excel Spreadsheet and other Windows
applications. We can even automate applications and objects
created using the Professional or Enterprise editions of
Visual Basic.
Internet capabilities make it easy to provide access to
documents and applications across the internet or intranet
from within our application, or to create Internet Server
applications.
Our finished application is a true.exe file that uses
a Virtual Basic Virtual Machine that we can freely distribute.
Visual Basic Concept
In order to understand the application development process,
it is helpful to understand some of the key concepts upon
which Visual Basic is built. Because Visual Basic is a
Windows development language, some familiarity with the
13
ystem
Desai
4
MasteringVisualBasic6.0
Evan
-
7/28/2019 Anjala Devi Project
14/97
Windows environment is necessary. If we are new to
Windows programming, we need to aware of some
fundamental differences between programming for Windows
versus other environment.
system. It is a program that runs over DOS. It enhances
the power and use of a PC running DOS in the following
ways: -
It converts the plain character-based user interfaced
provided by DOS in
to a Graphical User Interface (GUI). It makes the
computers easy as users are not required to
remember and type commands. Instead, users can
click the little picture (called Icons) that represent
commands to run programs.
It provides multitasking capabilities to the PC. A PC
running DOS can run only one program (task) at a
time. For instance, if we are running a word processor
on a DOS based PC, we can not simultaneously run the
Spread-sheet program. However, Windows converts a PC
that could run just one program into a PC that can run
two or more tasks simultaneously. The number of tasks
that our Windows-based PC can run depends on the
amount of RAM available in our PC.
14
Petroutsos
5MasteringDatabaseprogramming
Evangelos
Petroutsos
WithVisualBasic6.0
-
7/28/2019 Anjala Devi Project
15/97
Unlike DOS, that displays information in characters of
the same size, Windows can use different fonts i.e.
different shapes and sizes of characters can be
displayed and printed. True Type fonts introduced in
Windows 3.1 appear the same on the monitor as well
on the printed page.
Windows XP introduced by Microsoft Corporation almost at
the same time, is a complete operating system. Besides
operating system, Windows NT also introduces the
Networking Software. This means that is to connect several
PCs running Window 95, we dont need a separate network
operating system such as NetWare. In 1995, Microsoft
introduces Windows 95. Windows 95 is a full-fledge
operating system. Microsoft came out with an update and
enhanced version of Windows 95 in the form of Windows 98.
Again Windows 98 was a runway success. Microsoft already
released Windows 2000, an update version of Windows 98 in
the beginning of 2000. After Windows 2000, Microsoft
introduces Windows XP series such as Windows XP-SP1,
Windows XP-SP2 etc.
These days most new PCs come with Windows XP-SP2
preinstalled. Besides providing the basic operating
15
-
7/28/2019 Anjala Devi Project
16/97
capabilities to our PC, Windows 95/98 comes with a number
of useful programs. It has its own Windows Explorer that
can help us to copy and move files and manage directories.
Windows also come with a number of useful applications,
such as mini word processor (word pad), a drawing program
(paint), calendar, clock, calculator and notepad and system
tools to manage hard disks.
CODING
Introduction
The coding step performs the translation of the design
representations into an artificial language resulting in
instructions that can be executed by the computer. It thus
involves developing computer program that meet the system
specification of the design stage. Since the project is to be
implemented on the web, the two aspects: Visual Interface
Design and the efficiency of coding have been given special
emphasis.
Visual Interface Design
The user interface is perhaps the most important part of an
application. Its certainly the most visible. To users, theinterface is the application, they probably arent aware of
the code that is executing behind the scenes. No matter how
much time and effort we put into writing and optimizing our
16
-
7/28/2019 Anjala Devi Project
17/97
code. The usability of our application depends on the
interface.
Coding Conventions
Programming guidelines that focus not only on the logic ofthe program but on its physical structure and appearance.
They make the code easier to read, understand and
maintain. Following coding conventions must be kept in
mind while coding:
Guidelines for spacing, formatting and indenting.
Standardized formats for labeling and commenting code.
Naming conventions for object, variables and
procedures.
TESTING
Testing is a set of activities that can be planned in advanceand conducted automatically. For this reason a template for
software testing a set of steps into which we can place
specific test case design methods should be defined for the
software engineering process.
A strategy for software testing must accommodate
low-level tests that are necessary to verify that a smallsource code segment has been correctly implemented as
well as high-level tests that validate major system functions
against customer requirements.
17
-
7/28/2019 Anjala Devi Project
18/97
Types of testing
System Testing
It is the stage of implementation, which is aimed at
ensuring that the system works accurately and efficiently
before the operation commences. In principle, system
proving is an on-going activity throughout the project. The
logical design and the physical design should be thoroughly
and continually examined on paper to ensure that they will
work when implemented. Thus the system test in
implementation should be a confirmation that all is correct
and an opportunity to show the users that the system
works. when the programmers have tested each program
individually, using test data designed by themselves sand
have been verified that these programs linked together in
the way specified in the computer run chart to produce the
output specified in the program suite specification, the
computer system and its environment must be tested to the
satisfaction of the systems analyst and the user.
The system analyst will provide the test data; specially
designed to show that the system will operate successfully in
all its aspects and produce expected results under expected
conditions. The test should take place as far as possible in
18
-
7/28/2019 Anjala Devi Project
19/97
the actual operating environment and they should test
people and equipment as well as programs. Where this is
not possible, the system should be tested in stipulated
operational environment to prove that the computer and the
clerical procedures are understood and produce the required
results. Sometimes it is convenient to use live data from a
previous system cycle, but this presupposes that the new file
have been set up and can be used.
The software testing is performed in the following steps: -
Unit Testing
In the unit testing, each module is tested for its correctness,
validity and any missing operations. It is also verified that all
objective are met. All errors are specified in order to correct
them as soon as possible.
Integration Testing
It need not be sure that a software whose modules when
run individually and showing perfect results will perform
perfectly when run as a whole. This is due to poor
integration, which may result in data being lost across an
interface, a module can have inadvertent and adverse effect
on any other or on the global data structure causing serious
problems.
19
-
7/28/2019 Anjala Devi Project
20/97
Acceptance testing
User acceptance of the system is the key factor for the
success of any system. This system is under consideration is
tested in touch perspective system users at the time of
development and making changes whenever required.
Validation TestingIt determines whether the software functions as user
expected. Here also some modifications were made. Even
though a comprehensive test is carried out on the software,
it may not be possible to detect all the errors show in the
course of time, can be corrected through maintenance.
IMPLEMENTATION AND
ENALUATION
Implementation
It is the stage of the project when the theoretical design is
turned into a working system. At this stage the main
workload and the major impact on existing practices shifts to
the user departments. If the implementation stage is not
carefully planned and controlled, it can cause chaos. Thus it
20
-
7/28/2019 Anjala Devi Project
21/97
can be considered to be the most crucial stage in achieving a
successful new system and in giving the users confidence
that the new system work will be effective.
The implementation stage is a system project in its
own right. It involves careful planning, investigation of the
current system and its constraints on implementation,
design of method to achieve the changeover procedures and
evaluation of changeover method.
The more complex the system being implemented,
the more involved will be the systems analysis and design
effort required just for implementation. Indeed in large
organizations systems analysts may specialize in
implementation system activities.
Task of ImplementationThere is no tasks involved in the implementation process.
The first task is implementation planning i.e. deciding on the
methods and timescale to be adopted. Once the planning
has been completed, the major effort in the system is
working properly. At the same time the user department
must concentrate on training user staff. When the staff hasbeen trained a full system test can be carried out, involving
both computer and clerical procedures. Planning, training
and testing are the preparatory activities of implementation.
21
-
7/28/2019 Anjala Devi Project
22/97
Once the preparation is completed,
implementation proper can begin. The first part of this
involves the conversion of existing clerical files to computer
media and the setting up of these files as they are converted
on the computer.
Then the actual changeover from the existing system to the
new system takes place.
Finally when the changeover has taken place, there
will be need for amendments to correct or improve the
system.
Implementing a system, whether a new one or an
existing one that has been modified consists of three
primary activities:
Training
Conversion
Post implementation review(evaluation)
1) Training
Most user training deals with the operation of the system
itself, with the most attention given to data handling
procedures. It is imperative that users be properly trained inmethods of entering transactions, editing data, formulating
inquires and deleting records.
22
-
7/28/2019 Anjala Devi Project
23/97
2) Conversion
It is the process of changing from old system to new one. It
must be carefully planned and executed. There are mainly
four methods available:
i. Parallel system
ii. Direct cutover
iii. Systems phase in
We had planned the parallel system approach, in which
records are stored parallel and also manually. By this
method we achieve greatest security in the installation.
3) Post Implementation Review(evaluation)
After the system is implemented and the conversion is
complete, a review is conducted to determine:
a)Whether the system is meeting expectations?
b)Where improvements are needed?
When our system is implemented and conversion was
complete, we allowed the user to use the system for one
week and he gave us the following feedback:
23
-
7/28/2019 Anjala Devi Project
24/97
i. The system is meeting the objectives that were
decided.
ii. The design of the system is user friendly.
iii. Some additions should be there.
There should be flexible in report generation i.e. reports
should be available for daily, weekly, monthly, quarterly and
yearly basis.
System Evaluation
Evaluation of the system is performed to identify itsstrengths and weakness.
Operational Evaluation
In this assessment of the manner in which the system
functions, including ease of use, response time suitability of
information formats, overall reliability and level of utilization
is undertaken. The reliability is very high and till the writing
of this document, the system has not ever failed. All the
recovery methods are written, even if something exceptional
offers it sees to it that user has a way to come out of the
undesirables situation and carry on with the work. The
committing takes place when everything goes normal. As for
as the level of utilization is concerned, is one of the busiest
activity with the orders pouring in round the clock, so the
system has been utilized heavily and it has responded
favorably to the users expectations.
24
-
7/28/2019 Anjala Devi Project
25/97
Organization Impact
It includes identification and measurement of benefits to the
organization in such area as financial concern (cost, revenue
and profit), operational efficiency and competitive impact.
Also include impact on internal and external information
flows. Since the
response time and throughput has increased by manifolds,
the processing would increase, hence resulting in more
revenues and profit for the
Development PerformanceIt include evaluation of the development process in
accordance with such yardstick, overall development time
and effort, conformance to budgets and standards and
project management criteria. By all means our development
performance was fairly good as the project was completed
within budgets and there was no schedule slippage, target
25
-
7/28/2019 Anjala Devi Project
26/97
dates were met and all along the standards that were
followed were consistent.
Software Maintenance
Once the system is fully installed and is fully operational, the
system Maintaince task looms large. It is generally assigned
to a system and programming group consisting of
Maintaince programmers. Thus the responsibility gets
transferred from a system development team to a
Maintaince programming team.
System Maintaince involves keeping the software
operational i.e. undertaken preventive measures to keep
computer programs current, monitor and fix problems with
computer programs in response to new user requirements.
26
-
7/28/2019 Anjala Devi Project
27/97
Thus, since part of a system has to be modified rather than
the entire system, Maintaince activities resemble miniature
system development efforts.
System Maintaince that are considered during the
development of the system are:
1) Adaptive maintenance
2) Corrective maintenance
3) Perfective maintenance
IMPLEMENTATION AND
ENALUATION
Implementation
It is the stage of the project when the theoretical design is
turned into a working system. At this stage the main
workload and the major impact on existing practices shifts to
the user departments. If the implementation stage is not
carefully planned and controlled, it can cause chaos. Thus it
can be considered to be the most crucial stage in achieving a
successful new system and in giving the users confidence
that the new system work will be effective.
The implementation stage is a system project in its
own right. It involves careful planning, investigation of the
27
-
7/28/2019 Anjala Devi Project
28/97
current system and its constraints on implementation,
design of method to achieve the changeover procedures and
evaluation of changeover method.
The more complex the system being implemented,
the more involved will be the systems analysis and design
effort required just for implementation. Indeed in large
organizations systems analysts may specialize in
implementation system activities.
Task of Implementation
There is no tasks involved in the implementation process.
The first task is implementation planning i.e. deciding on the
methods and timescale to be adopted. Once the planning
has been completed, the major effort in the system is
working properly. At the same time the user department
must concentrate on training user staff. When the staff has
been trained a full system test can be carried out, involving
both computer and clerical procedures. Planning, training
and testing are the preparatory activities of implementation.
Once the preparation is completed,
implementation proper can begin. The first part of this
involves the conversion of existing clerical files to computer
media and the setting up of these files as they are converted
on the computer.
28
-
7/28/2019 Anjala Devi Project
29/97
Then the actual changeover from the existing system to the
new system takes place.
Finally when the changeover has taken place, there
will be need for amendments to correct or improve the
system.
Implementing a system, whether a new one or an
existing one that has been modified consists of three
primary activities:
Training
Conversion
Post implementation review(evaluation)
4) Training
Most user training deals with the operation of the system
itself, with the most attention given to data handlingprocedures. It is imperative that users be properly trained in
methods of entering transactions, editing data, formulating
inquires and deleting records.
5) Conversion
29
-
7/28/2019 Anjala Devi Project
30/97
It is the process of changing from old system to new one. It
must be carefully planned and executed. There are mainly
four methods available:
iv. Parallel system
v. Direct cutover
vi. Systems phase in
We had planned the parallel system approach, in which
records are stored parallel and also manually. By this
method we achieve greatest security in the installation.
6) Post Implementation Review(evaluation)
After the system is implemented and the conversion is
complete, a review is conducted to determine:
c)Whether the system is meeting expectations?
d)Where improvements are needed?
When our system is implemented and conversion was
complete, we allowed the user to use the system for one
week and he gave us the following feedback:
iv. The system is meeting the objectives that were
decided.
v. The design of the system is user friendly.
30
-
7/28/2019 Anjala Devi Project
31/97
vi. Some additions should be there.
There should be flexible in report generation i.e. reports
should be available for daily, weekly, monthly, quarterly and
yearly basis.
System Evaluation
Evaluation of the system is performed to identify its
strengths and weakness.
Operational Evaluation
In this assessment of the manner in which the system
functions, including ease of use, response time suitability of
information formats, overall reliability and level of utilization
is undertaken. The reliability is very high and till the writing
of this document, the system has not ever failed. All the
recovery methods are written, even if something exceptional
offers it sees to it that user has a way to come out of the
31
-
7/28/2019 Anjala Devi Project
32/97
undesirables situation and carry on with the work. The
committing takes place when everything goes normal. As for
as the level of utilization is concerned, is one of the busiest
activity with the orders pouring in round the clock, so the
system has been utilized heavily and it has responded
favorably to the users expectations.
Organization Impact
It includes identification and measurement of benefits to the
organization in such area as financial concern (cost, revenue
and profit), operational efficiency and competitive impact.
Also include impact on internal and external information
flows. Since the response time and throughput has increased
by manifolds, the processing would increase, hence resulting
in more revenues and profit for the Company. Especially
with the increase in the ease in processing it can schedule
their manpower accordingly rather than tying up personnel
for specific application.
This will rejuvenate and boost the morale of the users. This
system will go on to strengthen its leadership in the
market.
32
-
7/28/2019 Anjala Devi Project
33/97
Development Performance
It include evaluation of the development process inaccordance with such yardstick, overall development time
and effort, conformance to budgets and standards and
project management criteria. By all means our development
performance was fairly good as the project was completed
within budgets and there was no schedule slippage, target
dates were met and all along the standards that werefollowed were consistent.
Software Maintenance
Once the system is fully installed and is fully operational, the
system Maintaince task looms large. It is generally assigned
to a system and programming group consisting of
Maintaince programmers. Thus the responsibility gets
transferred from a system development team to a
Maintaince programming team.
System Maintaince involves keeping the software
operational i.e. undertaken preventive measures to keep
computer programs current, monitor and fix problems with
computer programs in response to new user requirements.
Thus, since part of a system has to be modified rather than
33
-
7/28/2019 Anjala Devi Project
34/97
the entire system, Maintaince activities resemble miniature
system development efforts.
System Maintaince that are considered during the
development of the system are:
1) Adaptive maintenance
2) Corrective maintenance
3) Perfective maintenance
CODE FOR FORM LABELLED BLOOD BANK
Private Sub cmd1_Click()
Adodc1.Recordset.MoveNext
If Adodc1.Recordset.EOF Then
Adodc1.Recordset.MoveLast
End If
End Sub
Private Sub cmd2_Click()
Adodc1.Recordset.MovePrevious
If Adodc1.Recordset.BOF Then
34
-
7/28/2019 Anjala Devi Project
35/97
Adodc1.Recordset.MoveFirst
End If
End Sub
Private Sub cmd3_Click()
Adodc1.Recordset.MoveFirst
End Sub
Private Sub cmd4_Click()
Adodc1.Recordset.MoveLast
End Sub
Private Sub cmdexit_Click()
End
End Sub
Private Sub command1_Click()
Adodc1.Recordset.AddNew
txt1 = ""
txt2 = ""
txt3 = ""
txt4 = ""
txt5 = ""
txt1.SetFocus
35
-
7/28/2019 Anjala Devi Project
36/97
End Sub
Private Sub command2_Click()
Adodc1.Recordset.Delete
Adodc1.Recordset.MoveNext
If Adodc1.Recordset.EOF Then
Adodc1.Recordset.MoveLast
End If
End Sub
Private Sub command4_Click()
Adodc1.Recordset.Update
End Sub
Private Sub command5_Click()
r = InputBox("Enter Name")
Adodc1.Recordset.Find ("Name='" & r & "'")
End Sub
CODE FOR FORM LABELLED BLOODBANKRADILOGY
Private Sub cmd1_Click()
BloodBank.Show
36
-
7/28/2019 Anjala Devi Project
37/97
End Sub
Private Sub cmd2_Click()
Lab.Show
End Sub
Private Sub cmd3_Click()
Radiology.Show
End Sub
Private Sub cmdexit_Click()
End
End Sub
CODE WINDOW FOR FORM LABELLED DEPARTMENTS
Private Sub cmd1_Click()
PSM.Show
End Sub
Private Sub cmd10_Click()
Medicine.Show
End Sub
Private Sub cmd2_Click()
Skin.Show
37
-
7/28/2019 Anjala Devi Project
38/97
End Sub
Private Sub cmd3_Click()
ENT.Show
End Sub
Private Sub cmd4_Click()
Psychiatry.Show
End Sub
Private Sub command1_Click()
Paediatrics.Show
End Sub
Private Sub cmd6_Click()
Eye.Show
End Sub
Private Sub cmd7_Click()
Surgery.Show
End Sub
Private Sub cmd8_Click()
Gynecology.Show
38
-
7/28/2019 Anjala Devi Project
39/97
End Sub
Private Sub cmd9_Click()
Orthopaedic.Show
End Sub
Private Sub cmdexit_Click()
End
End Sub
CODE FOR FORM LABELLED EMRGOPDDIAG
Private Sub cmd1_Click()
SurGyneOrtho.Show
End Sub
Private Sub cmd2_Click()
Departments.Show
End Sub
Private Sub cmd3_Click()
BloodLabRad.Show
39
-
7/28/2019 Anjala Devi Project
40/97
End Sub
Private Sub cmdexit_Click()
End
End Sub
CODE WINDOW FOR FORM LABELLED ENT
Private Sub cmd1_Click()
Adodc1.Recordset.MoveNext
If Adodc1.Recordset.EOF Then
Adodc1.Recordset.MoveLast
End If
End Sub
Private Sub cmd2_Click()
Adodc1.Recordset.MovePrevious
If Adodc1.Recordset.BOF Then
40
-
7/28/2019 Anjala Devi Project
41/97
Adodc1.Recordset.MoveFirst
End If
End Sub
Private Sub cmd3_Click()
Adodc1.Recordset.MoveFirst
End Sub
Private Sub cmd4_Click()
Adodc1.Recordset.MoveLast
End Sub
Private Sub cmdexit_Click()
End
End Sub
Private Sub command1_Click()
Adodc1.Recordset.AddNew
txt1.Text = ""
txt2.Text = ""
txt3.Text = ""
txt4.Text = ""
txt5.Text = ""
txt6.Text = ""
41
-
7/28/2019 Anjala Devi Project
42/97
txt7.Text = ""
txt8.Text = ""
txt9.Text = ""
txt10.Text = ""
txt1.SetFocus
End Sub
Private Sub command2_Click()
Adodc1.Recordset.Delete
Adodc1.Recordset.MoveNext
If Adodc1.Recordset.EOF Then
Adodc1.Recordset.MoveLast
End If
End Sub
Private command4_Click()
Adodc1.Recordset.Update
End Sub
Private Sub command5_Click()
r = InputBox("Enter Name")
Adodc1.Recordset.Find ("Name='" & r & "'")
End Sub
42
-
7/28/2019 Anjala Devi Project
43/97
CODE WINDOW FOR FORM LABELLED EYE
Private Sub cmd1_Click()
Adodc1.Recordset.MoveNext
If Adodc1.Recordset.EOF Then
Adodc1.Recordset.MoveLast
End If
End Sub
Private Sub cmd2_Click()
Adodc1.Recordset.MovePrevious
If Adodc1.Recordset.BOF Then
Adodc1.Recordset.MoveFirst
43
-
7/28/2019 Anjala Devi Project
44/97
End If
End Sub
Private Sub cmd3_Click()
Adodc1.Recordset.MoveFirst
End Sub
Private Sub cmd4_Click()
Adodc1.Recordset.MoveLast
End Sub
Private Sub cmdexit_Click()
End
End Sub
Private Sub command1_Click()
Adodc1.Recordset.AddNew
txt1.Text = ""
txt2.Text = ""
txt3.Text = ""
txt4.Text = ""
txt5.Text = ""
txt6.Text = ""
txt7.Text = ""
44
-
7/28/2019 Anjala Devi Project
45/97
txt8.Text = ""
txt9.Text = ""
txt10.Text = ""
txt1.SetFocus
End Sub
Private Sub command2_Click()
Adodc1.Recordset.Delete
Adodc1.Recordset.MoveNext
If Adodc1.Recordset.EOF Then
Adodc1.Recordset.MoveLast
End If
End Sub
Private Sub command4_Click()
Adodc1.Recordset.Update
End Sub
Private Sub command5_Click()
r = InputBox("Enter Name")
Adodc1.Recordset.Find ("Name='" & r & "'")
End Sub
CODE FOR FORM LABELLED GYNECOLOGY
45
-
7/28/2019 Anjala Devi Project
46/97
Private Sub cmd1_Click()
Adodc1.Recordset.MoveNext
If Adodc1.Recordset.EOF Then
Adodc1.Recordset.MoveLast
End If
End Sub
Private Sub cmd2_Click()
Adodc1.Recordset.MovePrevious
If Adodc1.Recordset.BOF Then
Adodc1.Recordset.MoveFirst
End If
End Sub
Private Sub cmd3_Click()
Adodc1.Recordset.MoveFirst
End Sub
Private Sub cmd4_Click()
Adodc1.Recordset.MoveLast
End Sub
Private Sub cmdexit_Click()
46
-
7/28/2019 Anjala Devi Project
47/97
End
End Sub
Private Sub command1_Click()
Adodc1.Recordset.AddNew
txt1.Text = ""
txt2.Text = ""
txt3.Text = ""
txt4.Text = ""
txt5.Text = ""
txt6.Text = ""
txt7.Text = ""
txt8.Text = ""
txt9.Text = ""
txt10.Text = ""
txt1.SetFocus
End Sub
Private Sub command2_Click()
Adodc1.Recordset.Delete
Adodc1.Recordset.MoveNext
If Adodc1.Recordset.EOF Then
Adodc1.Recordset.MoveLast
End If
End Sub
47
-
7/28/2019 Anjala Devi Project
48/97
-
7/28/2019 Anjala Devi Project
49/97
Adodc1.Recordset.MoveFirst
End If
End Sub
Private Sub cmd3_Click()
Adodc1.Recordset.MoveFirst
End Sub
Private Sub cmd4_Click()
Adodc1.Recordset.MoveLast
End Sub
Private Sub cmdexit_Click()
End
End Sub
Private Sub command1_Click()
Adodc1.Recordset.AddNew
txt1.Text = ""
txt2.Text = ""
txt3.Text = ""
txt4.Text = ""
txt5.Text = ""
txt6.Text = ""
49
-
7/28/2019 Anjala Devi Project
50/97
txt7.Text = ""
txt8.Text = ""
txt9.Text = ""
txt10.Text = ""
txt1.SetFocus
End Sub
Private Sub command2_Click()
Adodc1.Recordset.Delete
Adodc1.Recordset.MoveNext
If Adodc1.Recordset.EOF Then
Adodc1.Recordset.MoveLast
End If
End Sub
Private Sub command4_Click()
Adodc1.Recordset.UpdateEnd Sub
Private Sub command5_Click()
r = InputBox("Enter Name")
Adodc1.Recordset.Find ("Name='" & r & "'")
End Sub
CODE FOR FORM LABELLED MAIN
50
-
7/28/2019 Anjala Devi Project
51/97
Private Sub cmd1_Click()
Patients.Show
End Sub
Private Sub cmd2_Click()
End
End Sub
CODE FOR FORM LABELLED MEDICINE
Private Sub cmd1_Click()
Adodc1.Recordset.MoveNext
If Adodc1.Recordset.EOF Then
Adodc1.Recordset.MoveLast
End If
End Sub
Private Sub cmd2_Click()
Adodc1.Recordset.MovePrevious
If Adodc1.Recordset.BOF Then
51
-
7/28/2019 Anjala Devi Project
52/97
Adodc1.Recordset.MoveFirst
End If
End Sub
Private Sub cmd3_Click()
Adodc1.Recordset.MoveFirst
End Sub
Private Sub cmd4_Click()
Adodc1.Recordset.MoveLast
End Sub
Private Sub cmdexit_Click()
End
End Sub
Private Sub command1_Click()
Adodc1.Recordset.AddNew
txt1 = ""
txt2 = ""
txt3 = ""
txt4 = ""
txt5 = ""
txt6 = ""
52
-
7/28/2019 Anjala Devi Project
53/97
txt7 = ""
txt8 = ""
txt9 = ""
txt10 = ""
txt1.SetFocus
End Sub
Private Sub command2_Click()
Adodc1.Recordset.Delete
Adodc1.Recordset.MoveNext
If Adodc1.Recordset.EOF Then
Adodc1.Recordset.MoveLast
End If
End Sub
Private Sub command4_Click()
Adodc1.Recordset.Update
End Sub
Private Sub command5_Click()
r = InputBox("Enter Name")
Adodc1.Recordset.Find ("Name='" & r & "'")
End Sub
53
-
7/28/2019 Anjala Devi Project
54/97
CODE FOR FORM LABELLED ORTHOPAEDIC
Private Sub cmd1_Click()
Adodc1.Recordset.MoveNext
If Adodc1.Recordset.EOF Then
Adodc1.Recordset.MoveLast
End If
End Sub
Private Sub cmd2_Click()
Adodc1.Recordset.MovePrevious
If Adodc1.Recordset.BOF Then
Adodc1.Recordset.MoveFirst
End If
End Sub
Private Sub cmd3_Click()
Adodc1.Recordset.MoveFirst
End Sub
Private Sub cmd4_Click()
Adodc1.Recordset.MoveLast
End Sub
54
-
7/28/2019 Anjala Devi Project
55/97
Private Sub cmdexit_Click()
End
End Sub
Private Sub command1_Click()
Adodc1.Recordset.AddNew
txt1.Text = ""
txt2.Text = ""
txt3.Text = ""
txt4.Text = ""
txt5.Text = ""
txt6.Text = ""
txt7.Text = ""
txt8.Text = ""
txt9.Text = ""
txt10.Text = ""
txt1.SetFocus
End Sub
Private Sub command2_Click()
Adodc1.Recordset.Delete
Adodc1.Recordset.MoveNext
If Adodc1.Recordset.EOF Then
55
-
7/28/2019 Anjala Devi Project
56/97
Adodc1.Recordset.MoveLast
End If
End Sub
Private Sub command4_Click()
Adodc1.Recordset.Update
End Sub
Private Sub command5_Click()
r = InputBox("Enter Name")
Adodc1.Recordset.Find ("Name='" & r & "'")
End Sub
CODE FOR FORM LABELLED PEADATRICS
Private Sub cmd1_Click()
Adodc1.Recordset.MoveNext
If Adodc1.Recordset.EOF Then
Adodc1.Recordset.MoveLast
End If
End Sub
Private Sub cmd2_Click()
Adodc1.Recordset.MovePrevious
56
-
7/28/2019 Anjala Devi Project
57/97
If Adodc1.Recordset.BOF Then
Adodc1.Recordset.MoveFirst
End If
End Sub
Private Sub cmd3_Click()
Adodc1.Recordset.MoveFirst
End Sub
Private Sub cmd4_Click()
Adodc1.Recordset.MoveLast
End Sub
Private Sub cmdexit_Click()
End
End Sub
Private Sub command1_Click()
Adodc1.Recordset.AddNew
txt1.Text = ""
txt2.Text = ""
txt3.Text = ""
txt4.Text = ""
txt5.Text = ""
57
-
7/28/2019 Anjala Devi Project
58/97
txt6.Text = ""
txt7.Text = ""
txt8.Text = ""
txt9.Text = ""
txt10.Text = ""
txt1.SetFocus
End Sub
Private Sub command2_Click()
Adodc1.Recordset.Delete
Adodc1.Recordset.MoveNext
If Adodc1.Recordset.EOF Then
Adodc1.Recordset.MoveLast
End If
End Sub
Private Sub command4_Click()
Adodc1.Recordset.Update
End Sub
Private Sub command5_Click()
Dim X As String
r = InputBox("Enter Name")
Adodc1.Recordset.Find ("Name='" & r & "'")
58
-
7/28/2019 Anjala Devi Project
59/97
End Sub
CODE FOR FORM LABELLED PATIENTS
Private Sub cmd1_Click()
EmrgOPDDiag.Show
End Sub
Private Sub cmd2_Click()
End
End Sub
CODE FOR FORM LABELED PSM
59
-
7/28/2019 Anjala Devi Project
60/97
Private Sub cmd1_Click()
Adodc1.Recordset.MoveNext
If Adodc1.Recordset.EOF Then
Adodc1.Recordset.MoveLast
End If
End Sub
Private Sub cmd2_Click()
Adodc1.Recordset.MovePrevious
If Adodc1.Recordset.BOF Then
Adodc1.Recordset.MoveFirst
End If
End Sub
Private Sub cmd3_Click()
Adodc1.Recordset.MoveFirst
End Sub
Private Sub cmd4_Click()
Adodc1.Recordset.MoveLast
End Sub
Private Sub cmdexit_Click()
60
-
7/28/2019 Anjala Devi Project
61/97
End
End Sub
Private Sub command1_Click()
Adodc1.Recordset.AddNew
txt1 = ""
txt2 = ""
txt3 = ""
txt4 = ""
txt5 = ""
txt6 = ""
txt7 = ""
txt8 = ""
txt9 = ""
txt10 = ""
txt1.SetFocus
End Sub
Private Sub command2_Click()
Adodc1.Recordset.Delete
If Adodc1.Recordset.EOF Then
Adodc1.Recordset.MoveLast
End If
End Sub
61
-
7/28/2019 Anjala Devi Project
62/97
Private Sub commaand4_Click()
Adodc1.Recordset.UpdateEnd Sub
Private Sub command5_Click()r = InputBox("Enter Name")
Adodc1.Recordset.Find ("Name='" & r & "'")
End Sub
CODE FOR FORM LABELLED PSYCHIATRY
Private Sub cmd1_Click()
Adodc1.Recordset.MoveNext
If Adodc1.Recordset.EOF Then
Adodc1.Recordset.MoveLast
End If
End Sub
Private Sub cmd2_Click()
Adodc1.Recordset.MovePrevious
If Adodc1.Recordset.BOF Then
Adodc1.Recordset.MoveFirst
62
-
7/28/2019 Anjala Devi Project
63/97
End If
End Sub
Private Sub cmd3_Click()
Adodc1.Recordset.MoveFirst
End Sub
Private Sub cmd4_Click()
Adodc1.Recordset.MoveLast
End Sub
Private Sub cmdexit_Click()
End
End Sub
Private Sub command1_Click()
Adodc1.Recordset.AddNew
txt1.Text = ""
txt2.Text = ""
txt3.Text = ""
txt4.Text = ""
txt5.Text = ""
txt6.Text = ""
txt7.Text = ""
63
-
7/28/2019 Anjala Devi Project
64/97
txt8.Text = ""txt9.Text = ""
txt10.Text = ""
txt1.SetFocusEnd Sub
Private Sub command2_Click()
Adodc1.Recordset.Delete
Adodc1.Recordset.MoveNext
If Adodc1.Recordset.EOF Then
Adodc1.Recordset.MoveLast
End If
End Sub
Private Sub command4_Click()
Adodc1.Recordset.Update
End Sub
Private Sub command5_Click()
r = InputBox("Enter Name")
Adodc1.Recordset.Find ("Name='" & r & "'")
End Sub
CODE FOR FORM LABELLED RADIOLOGY
64
-
7/28/2019 Anjala Devi Project
65/97
Private Sub cmd1_Click()
Adodc1.Recordset.MoveNext
If Adodc1.Recordset.EOF Then
Adodc1.Recordset.MoveLast
End If
End Sub
Private Sub cmd2_Click()
Adodc1.Recordset.MovePrevious
If Adodc1.Recordset.BOF Then
Adodc1.Recordset.MoveFirst
End If
End Sub
Private Sub cmd3_Click()
Adodc1.Recordset.MoveFirst
End Sub
Private Sub cmd4_Click()
Adodc1.Recordset.MoveLast
End Sub
Private Sub cmdexit_Click()
65
-
7/28/2019 Anjala Devi Project
66/97
End
End Sub
Private Sub command1_Click()
Adodc1.Recordset.AddNew
txt1.Text = ""
txt2.Text = ""
txt3.Text = ""
txt4.Text = ""
txt5.Text = ""
txt6.Text = ""
txt7.Text = ""
txt8.Text = ""
txt9.Text = ""
txt10.Text = ""
txt1.SetFocus
End Sub
Private Sub command2_Click()
Adodc1.Recordset.Delete
Adodc1.Recordset.MoveNext
If Adodc1.Recordset.EOF Then
Adodc1.Recordset.MoveLast
End If
66
-
7/28/2019 Anjala Devi Project
67/97
End Sub
Private Sub command4_Click()
Adodc1.Recordset.Update
End Sub
Private Sub command5_Click()
r = InputBox("Enter Name")
Adodc1.Recordset.Find ("Name='" & r & "'")
End Sub
CODE FOR FORM LABELLED SKIN
Private Sub cmd1_Click()
Adodc1.Recordset.MoveNext
If Adodc1.Recordset.EOF Then
Adodc1.Recordset.MoveLast
End If
End Sub
Private Sub cmd2_Click()
Adodc1.Recordset.MovePrevious
If Adodc1.Recordset.BOF Then
67
-
7/28/2019 Anjala Devi Project
68/97
Adodc1.Recordset.MoveFirst
End If
End Sub
Private Sub cmd3_Click()
Adodc1.Recordset.MoveFirst
End Sub
Private Sub cmd4_Click()
Adodc1.Recordset.MoveLast
End Sub
Private Sub cmdexit_Click()
End
End Sub
Private Sub command1_Click()
Adodc1.Recordset.AddNew
txt1 = ""
txt2 = ""
txt3 = ""
txt4 = ""
txt5 = ""
txt6 = ""
68
-
7/28/2019 Anjala Devi Project
69/97
txt7 = ""
txt8 = ""
txt9 = ""
txt10 = ""
txt1.SetFocus
End Sub
Private Sub command2_Click()
Adodc1.Recordset.Delete
If Adodc1.Recordset.EOF Then
Adodc1.Recordset.MoveLast
End If
End Sub
Private Sub command4_Click()
Adodc1.Recordset.Update
End Sub
Private Sub command5_Click()
r = InputBox("Enter Name")
Adodc1.Recordset.Find ("Name='" & r & "'")
End Sub
CODE FOR FORM LABELLED SURGERY
69
-
7/28/2019 Anjala Devi Project
70/97
Private Sub cmd1_Click()
Adodc1.Recordset.MoveNext
If Adodc1.Recordset.EOF Then
Adodc1.Recordset.MoveLast
End If
End Sub
Private Sub cmd2_Click()
Adodc1.Recordset.MovePrevious
If Adodc1.Recordset.EOF Then
Adodc1.Recordset.MoveFirst
End If
End Sub
Private Sub cmd3_Click()
Adodc1.Recordset.MoveFirst
End Sub
Private Sub cmd4_Click()
Adodc1.Recordset.MoveLast
End Sub
Private Sub cmdexit_Click()
End
End Sub
70
-
7/28/2019 Anjala Devi Project
71/97
Private Sub command1_Click()
Adodc1.Recordset.AddNew
txt1.Text = ""
txt2.Text = ""
txt3.Text = ""
txt4.Text = ""
txt5.Text = ""
txt6.Text = ""
txt7.Text = ""
txt8.Text = ""
txt9.Text = ""
txt10.Text = ""
txt1.SetFocus
End Sub
Private Sub command2_Click()
Adodc1.Recordset.Delete
Adodc1.Recordset.MoveNext
If Adodc1.Recordset.EOF Then
Adodc1.Recordset.MoveLast
End If
End Sub
71
-
7/28/2019 Anjala Devi Project
72/97
Private Sub command4_Click()
Adodc1.Recordset.Update
End Sub
Private Sub command5_Click()
r = InputBox("Enter Name")
Adodc1.Recordset.Find ("Name='" & r & "'")
End Sub
CODE FOR FORM LABELLED SURGYNERTHO
Private Sub cmd1_Click()
Surgery.Show
End Sub
Private Sub cmd2_Click()
Gynecology.Show
End Sub
Private Sub cmd3_Click()
Orthopaedic.Show
End Sub
Private Sub cmd4_Click()
72
-
7/28/2019 Anjala Devi Project
73/97
Medicine.Show
End Sub
Private Sub cmdexit_Click()
End
End Sub
DESIGN WINDOW FOR FORM LABELLED BLOOD BANK
73
-
7/28/2019 Anjala Devi Project
74/97
DESIGN WINDOW FOR BLOOODLABRADIOLOGY
74
-
7/28/2019 Anjala Devi Project
75/97
DESIGN WINDOW FOR FORM LABELLED DEPARTMENTS
75
-
7/28/2019 Anjala Devi Project
76/97
DESIGN WINDOW FOR FORM LABELLED
76
-
7/28/2019 Anjala Devi Project
77/97
DESIGN WINDOW FOR FORM LABELLED ENT
77
-
7/28/2019 Anjala Devi Project
78/97
DESIGN WINDOW FOR FORM LABELLED EYE
78
-
7/28/2019 Anjala Devi Project
79/97
DESIGN WINDOW FOR FORM LABELLED GYNECOLOGY
79
-
7/28/2019 Anjala Devi Project
80/97
DESIGN WINDOW FOR FORM LABELLED ORTHOPAEDIC
80
-
7/28/2019 Anjala Devi Project
81/97
DESIGN WINDOW FOR FORM LABELLED PEADIATRICS
81
-
7/28/2019 Anjala Devi Project
82/97
DESIGN WINDOW FOR FORM LABELLED PATIENTS
82
-
7/28/2019 Anjala Devi Project
83/97
DESIGN WINDOW FOR FORM LABELLED LAB
83
-
7/28/2019 Anjala Devi Project
84/97
DESIGN WINDOW FOR FORM LABELLED MAIN
84
-
7/28/2019 Anjala Devi Project
85/97
DESIGN WINDOW FOR FORM LABELLED MDI FORM
85
-
7/28/2019 Anjala Devi Project
86/97
DESIGN WINDOW FOR FORM LABELLED MEDICINE
86
-
7/28/2019 Anjala Devi Project
87/97
DESIGN WINDOW FOR FORM LABELLED PAEDIATRICS
87
-
7/28/2019 Anjala Devi Project
88/97
DESIGN WINDOW FOR FORM LABELLED ORTHOPAEDIC
88
-
7/28/2019 Anjala Devi Project
89/97
DESIGN WINDOW FOR FORM LABELLED PATIENTS
89
-
7/28/2019 Anjala Devi Project
90/97
DESIGN WINDOW FOR FORM LABELLED PSM
90
-
7/28/2019 Anjala Devi Project
91/97
DESIGN WINDOW FOR FORM LABELLED PSYCHIATRY
91
-
7/28/2019 Anjala Devi Project
92/97
DESIGN WINDOW FOR FORM LABELLED RADIOLOGY
92
-
7/28/2019 Anjala Devi Project
93/97
DESIGN WINDOW FOR FORM LABELLED SKIN
93
-
7/28/2019 Anjala Devi Project
94/97
DESIGN WINDOW FOR FORM LABELLED SURGERY
94
-
7/28/2019 Anjala Devi Project
95/97
DESIGN WINDOW FOR FORM LABELLED SURGYNEORTHO
95
-
7/28/2019 Anjala Devi Project
96/97
BIBLOGRAPHY
96
-
7/28/2019 Anjala Devi Project
97/97
S.NO Name of the Book Author
1 System Analysis and Design Awadh
2 MS-Access R.B Patel
3 Introduction to database Bipin CManagement System Desai
4 Mastering Visual Basic 6.0 Evangelos
Petroutsos
5 Mastering Database programming EvangelosPetroutsos With Visual Basic 6.0
top related