documentation patient

8/12/2019 Documentation Patient

1/95

SYNOPSIS

The Project is entitled Patient Management System. The main objective of

this project is to computerize hospitals to manage patients information.

Patient management system project is developed for computerizing hospitals

to managepatientsinformation more efficiently and save time in serving patients

in limited time. Using this system details of every patient who visited hospital are

updated and their details of tests, tablets, amount they paid, doctor they consulted,

disease they are suffering form and next visit timings are updated to database.

Using patient management system application hospitals can easily manage

patients data and helps in analyzing patientsvisits and retrieving old data. With

these application hospital authorities can view data of any patient with clarity on

his past treatment details like doctor name, case and treatment details.

This project is made using VB basic as front end and Microsoft Access as

backend.


2/95

Module Description

Admin

Hospital info Doctor info Departments info Patients Reports Visitors Reports

Doctor

Patients info Appointment Report

Staff

Visitors info Appointment Info

Admin

Administrator will have complete control of the system. She/he can

Add/Edit/Delete patients, Add/Edit/Delete Doctors, Add/Edit/Delete Beds, Search

for patients, Assign patients to doctors.


3/95

Hospital

In hospital module we can registered the hospital id, during registration we enter

the basic information regarding hospital. Here we register the authoritysperson

name.

Doctor

Doctors who are related to that hospital can enter to their related page by their

login name and password. They can see their information, change their account,

they can see patients whom they checked, and Doctor can access a patients record

and update his observations about the patient in that particular visit.

Departments

In departments module we can registered the department id, department name,

description during registration we enter the basic information regarding

departments. (Scan, ECG, Medicals are including this)

Patient Reports

We can enter or view the previous medical record of particular patient.

We can enter or view the PRESCRIPTION of particular patient.

We can enter or view other information like :

o Notes and reports,

o Allergy,

o Diet Plan,

o Physician Orders,


4/95

o Problems,

o Measurement,

o Diagnosis,o Therapy,

o Medical advice

Visitors Reports

In visitors reports module, visitors basic information, Visiting Time, Patient

Name, are displayed here. The information is fetched from visitor info module.

Patient

In patient module we can registered the new patient, during registration we enter

the basic information regarding patient. There are two types of patient one is

INPATIENT and another is OUTPATIENT. If patient is INPATIENT then we can

check the availability of room in particular ward.

Appointment Report

In this appointment report module, Doctor Name, patient Name, Timing is

displayed here. Information is fetched from appointment info module.

Staff

This Module is for employees who are working in that particular hospital. Admin

will assign them user name and password by this they can enter into their related

page. An employee can enter the information about the Admitted Patient, he can

add all type of charges like Room, Medicine, Test etc. to particular Patient, and he

can also maintain the information of the Patient who has discharged.


5/95

Visitors

In visitorsmodule, visitor information on patient visits is maintained here. Patientname, visitor address, time in, time out is maintained here.

Appointment Info

In appointmen module here we can registered the new patient, during registration

we enter the basic information regarding patient. There are two types of patient one

is INPATIENT and another is OUTPATIENT. If patient is INPATIENT then we

can check the availability of room in particular ward.


6/95

Chapter No Title Page No

1. Introduction

1.1. Organization Profile1.2. Problem Statement

1

2. System Analysis

2.1. Approach

2.2. Existing System

2.3. Proposed System

2.4. Need For Computerization

3. System Configuration3.1. Hardware Configuration

3.2. Software Configuration

4. System Development

4.1. Project Specification

4.2. Module Description

4.3. Form Validation

5. System Design

5.1. Input Design

5.2. Code Design

5.3. Database Design

5.4. Output Design

5.5. Data Flow Diagram

6. Testing and Implementation

7. Future Enhancement

8. Conclusion

9. Bibliography


7/95


8/95

1.2.Problem Statement

1.Lack of immediate retrievals

The information is very difficult to retrieve and to find particular information like-

E.g. - To find out about the patients history, the user has to go through various

registers. This results in inconvenience and wastage of time.

2.Lack of immediate information storage

The information generated by various transactions takes time and efforts to be

stored at right place.

3.Lack of prompt updating

Various changes to information like patient details or immunization details ofchild are difficult to make, as paper work is involved.

4.Error prone manual calculation

Manual calculations are error prone and take a lot of time this may result in

incorrect information. For example calculation of patients bill based on various

treatments.

5. Preparation of accurate and prompt reports

This becomes a difficult task as information is difficult to collect from various

registers.


9/95

Chapter 2

System analysis


10/95

2.SYSTEM ANALYSIS

2.1. APPROACH

The data which were manually collected and the same is analyzed for

computerization. System Analysis means the set of requirement and the description

for the new system. This aims to understand how an existing system operation

there by project to proposed system.

2.2. EXISTING SYSTEM

The characteristic of existing system has been observed. They are summarized as

below:

1. Traditional works are done in systems.2. Few staff in hospitals for more patients.3. It is time consuming.4. It is error prone.5. Rectification is tedious.

LIMITATIONS OF EXISTING SYSTEM:

1. Lack of security for handling cash physically.2. Distraction and stress is more.3.No direct role of higher officials.4. Problems due to network traffic.5. Problems due to frequent power failure.

2.3. PROPOSED SYSTEM

Proposed system is being developed using Visual Basic as front end and Ms-

Access as back end. The aim of proposed system is to develop a system of

improved facilities.

The proposed system can overcome all the limitations of the existing system.

1. The system provides proper security.2. Reports can be easily generated as per the requirements.3. The customer can deposit a large amount at any time.4. Reports can be easily generated by date wise.


11/95

5. Retrieval of details of patients is very fast and easy.6. Information can be retrieved at any time.7. A patient can view the transaction at any time.

ADVANTAGES OF THE PROPOSED SYSTEM:

The system is very simple in design and to implement. The system requires

very low system resources and the system will work in almost all configurations.

1. Security of data.2. Proper control of the higher officials.3. Minimum time needed for the various processing.4. Greater efficiency and better service.5. We can view the patient report at any time.6. The details of the patient can be viewed through his finger prints.7. Reports can be viewed by the customer whenever he want.

2.4. NEED FOR COMPUTERIZATION

The storage and the retrieval of the data were difficult and data entry was time

consuming are some of the reasons for computerization are:

Can be used to give operational characteristicsFor the usage of 24 hours usage.For the users comfort ability.To achieve secrecy and confidentiality. Its user friendly and helps in obtaining knowledge.Reports can be viewed easily at any time.


12/95

Chapter 3

System configuration


13/95

3.SYSTEM CONFIGURATION

3.1. HARDWARE CONFIGURATION:

Processor : Minimum of P4 Processor

Co Processor : Build in

Speed : 2.79 GHz

RAM : 512 MB or more

Hard disk : 20 GB or more

Keyboard : 104 Keys

Mouse : 2buttons/ 3 buttons

3.2. SOFTWARE CONFIGURATION:

Operating System : Microsoft Windows XP

Front end : Visual Basic 6.0

Back end : MS Access

Design tool : Data Flow Diagram


14/95

Chapter 4

System Specifications


15/95

4.SYSTEM SPECIFICATIONS

4.1. PROJECT SPECIFICATION

MICROSOFT WINDOWS XP

Microsoft Windows XP is a series of operating systems produced by Microsoft.

Microsoft introduced an operating environment named Windows on November

20,1985 as an add-on to MS-DOS in response to the growing internet in graphical

users interfaces (GUIs). Microsoft Windows came to dominate the worlds

personal computer market, overtaking Mac OS, which had been introduced in

1984. The most recent server version is Windows Server 2008 R2; the most recent

mobile version is Windows Phone7.

Features of Windows XP

The window XP service pack is the operating system which provides more

security, flexibility and high performance in comparison with the previous versions

and offers full level compatibility with the windows updating and offers so many

features which is not there in the previous versions. Simplified user interface and

innovative support services creates the best desktop operating system for business.

Architectural independenceLess crashingFaster internet performanceBetter Photo Handling and PrintingTreats a CD-RW like a real driveSystem RestoreCentralized AdministrationLarge memory spaceRemote access server

MICROSOFT VISUAL BASIC

Visual Basic(VB) is the third-generation event-driven programming

language and integrated development environment (IDE) from Microsoft for its

COM programming model. Visual Basic is designed to be relatively easy to learn

and use. Visual Basic was derived from BASIC and enables the rapid application


16/95

development(RAD) of graphical user interface (GUI) application, access to

databases using Data Acess Objects and Remote Data Objects, or ActiveX Data

Objects and creation of ActiveX controls and objects. Programs written in Visual

Basic can also use the Windows API, but doing so requires external function

declaration.

Properties, Events and Methods:

Properties define the characteristic of a size and color etc. sometimes it is the

way in which it behaves the method is an action that can be performed on objects.

VB forms and controls are object, which expose the own properties, methods and

events.

Developing an Application:

Visual Programming SetupCode Programming Setup

Visual Basic involves designing an application with various tools. The code

programming step involves writing the program using a text editor.

Programming Fundamentals:

Visual Basic uses building blocks such as Variables, Data types, Procedures,

Functions and Control structures in its programming environment.

Using the Menu Editor:

A Menu Editor can be used to add a new command to the existing menu

which creates menu bar, change or delete an existing menu.

Data Environment:

The Data Environment Designer allows quick and building of hierarchical

record set during the design time. Programming is the result in Data Environment

Object however requires the knowledge of ADO Programming Model combines

with the characters of hierarchical record set.

Elements used in Visual Basic:


17/95


18/95

0.You can include the statements check1.value=1to mark the checkbox and

check1.value=0 to unmark the check box, as well as use them to initiate certain

actions.

MICROSOFT ACCESS

Microsoft Access stores information in what is called a Database.

Database

Create your Microsoft Access database and specify what kind of data you will be

storing. A retail business might create a database to store all their sales information

(i.e. Items sold, Customer, employee, commission, etc)

The name database is actually a very descriptive name. The database is two things

in one:

Data: A place to store your data. This data could be a record of sales,

employees, salaries, or anything else.

base: It is the basic building block that many other features in access use

to function.With a properly created database you can create informative reports

about the data, custom charts to visually display values, and create queries.

Query

Using queries we can view, change, and analyze the data in different ways. We can

also use them as the source of records for forms, reports, and data access pages.

This is a fancy term to basically describe the process of retrieving information

from the database.

Table

A table is a collection of data about specific topics.A table in access in quite

different then a table in real life. Instead of having wooden legs and being used for

meals, Access tables are a grid made up of rows and columns Table organizes the

data into columns(called fields)and rows(called records).


19/95

4.2.Module Description

Admin

Administrator will have complete control of the system. She/he can Add /Edit /

Delete patients, Add/Edit/Delete Doctors, Add/Edit/Delete Beds, Search for

patients, Assign patients to doctors.

Hospital

In hospital module here we can registered the hospital id, during registration we

enter the basic information regarding hospital. Here we register the authoritys

person name.

Doctor

Doctors who are related to that hospital can enter to their related page by their

login name and password. They can see their information, change their account,

they can see patients whom they checked, and Doctor can access a patients recordand update his observations about the patient in that particular visit.

Departments

In departments module here we can registered the department id, department name,

description during registration we enter the basic information regarding

departments. (Scan, ECG, Medicals are including this)

Patient Reports

We can enter or view the previous medical record of particular patient.

We can enter or view the PRESCRIPTION of particular patient.


20/95

We can enter or view other information like :

o Notes and reports,

o Allergy,o Diet Plan,

o Physician Orders,

o Problems,

o Measurement,

o Diagnosis,

o Therapy,

o Medical advice

Visitors Reports

In visitors reports module, visitors basic information, Visiting Time, Patient

Name, are displayed here. The information is fetched from visitor info module.

Patient

In patient module here we can registered the new patient, during registration we

enter the basic information regarding patient. There are two types of patient one is



Appointment Report


21/95

In this appointment report module, Doctor Name, patient Name, Timing is

displayed here. Information is fetched from appointment info module.

Staff

This is Module is for employees who are working in that particular hospital.

Admin will assign them user name and password by this they can enter in to their

related page. An employee can enter the information about the Admitted Patient,

he can add all type of charges like Room, Medicine, Test etc. to particular Patient,

and he can also maintain the information of the Patient who has discharged.

Visitors

In visitors module, visitor information on patient visits is maintained here. Patient

name, visitor address, time in, time out is maintained here.

Appointment Info

In patient module here we can registered the new patient, during registration we

enter the basic information regarding patient. There are two types of patient one is



4.3 FORM VALIDATION

Patient Info Form: Validation was done to ensure that the patient has entered

numeric values in numeric fields and has entered the alphabets for text fields and

has entered the correct date in the date/time field.


22/95

Doctor Info Form:Validation was done to ensure that the doctor has entered

numeric values in numeric fields and has entered the alphabets for text fields and

has entered the correct date in the date/time field.

Visitor Info Form: Each field was tested by the programmer. Validation was done

to ensure the owner has enters a numeric value in the amount field.


23/95

Chapter 5

System design


24/95

5.SYSTEM DESIGN

Design is a iterative process thought which requirements a translated into or blue

print for constructing the software design must implement all the implicit all threw

implicit requirements and explicit requirements. It must be a readable and

understandable. It is not coding. The initial focus of the project will be on in-house

league formats. However, the user interface is designed to organize the users' data

efficiently and intuitively and can be easily extended to support almost any kind of

athletic event. The scheduling system will be developed in Java, while web-based

components will be developed in HTML.

5.1.Input Design

Input design is the process of converting a user-oriented description of the input

into a computer-based system. This design is important to avoid errors in the data

input process and show the correct direction to the management for getting correct

information from the computerized system.

It is achieved by creating user-friendly screens for the data entry to handle large

volume of data. The goal of designing input is to make data entry easier and to free

from errors. The data entry screen is designed such a way that all the data

manipulates can be performed. It also provides record viewing facilities. When the

data is entered it will check for its validity.

Data can be entered with the help of screen. Appropriate messages are provided as

when needed so that the user will not be in maize of instant. The design of input

focuses on controlling the amount of input required, controlling the errors,

avoiding delay, avoiding extra steps and keeping the process simple. The input is

designed in such a way so that it provides security.


25/95

5.2.CODE DESIGN

A code is an ordered collection of symbols designed to prove unique identificationto an entry or an attribute. Purpose of using code is:

To achieve unique identification. Can be used instead of the name. To specify an objects physical or performance characteristics. Can be used to give Operational characteristics.

5.3.DATA BASE DESIGN

Table : Login

Field Name Data Type Size Description

LoginId Text 50 Login Id

UserId Text 50 User Id

Password Text 50 Password

Usertype Text 50 User Type

Table :AppoinmentInfo


Id Number 50 Appoinment Id

Date Date/Time 50 AppoinmentDate


26/95

DoctorName Text 50 DoctorName

PatientName Text 50 Patient Name

Timing Date/time Size Timing

Age Number 50 Age

Table :DepartmentInfo


Id Number 50 Department Id

Name Text 50 Department Name

Description Text 50 Description

Table : DoctorInfo


Id Number 50 Doctor Id


27/95

Name Text 50 DoctorName

PhoneNo Text 50 PhoneNo

MailId Text 50 MailId

Address Text 50 Address

HospitalName Text 50 HospitalName

Specialist Text 50 Specialist

Table :HospitalInfo


HospitalId Number 50 HospitalId

HospitalName Text 50 HospitalName


PhNo Number 50 PhNo

Inchargename Text 50 Inchargename

Table : InpatientInfo



28/95

Id Number 50 Id

Doctorname Text 50 Doctorname

patientname Text 50 Patientname

Department Text 50 Department

Indate Date/Time 50 Indate

Outdate Date/Time 50 Outdate

Feesamount Number 50 Feesamount

Paidamount Number 50 Paidamount

Medicalreport Text 50 Medicalreport

Tabletinfo Text 50 Tabletinfo

Table: OutPatientInfo


Id Number 50 Id

doctor name Text 50 DoctorName

patient name Text 50 patient name

Medical Report Text 50 Medical Report

Tablet info Text 50 Tablet info

Date Date/Time 50 Date

Timing Date/Time 50 Timing

Fees Number 50 Fees


29/95


30/95


Salary Number 50 Salary

Table : VisitorsInfo


Id Number 50 Id

Name Text 50 Name

Patientname Text 50 Patientname


Phoneno Text 50 Phoneno

Date Date/Time 50 Date

Timing Date/Time 50 Timing

5.4.Output Design

Designing computer output should processed in an organized, well thought

out manner; the right output must be developed while ensuring that each output


31/95

element is designed so that people will find the system can use easily and

effectively.

When analysis designs computer output should design:

Identify the specific output that is needed to meet the requirements. Create document, report, or other formats that contain information produced

by the system.

Select the appropriate methods for presenting the information.A quality output is one, which meets the requirements of the end user and

presents the information clearly. In output designs it is determined how the

information is to be displaced for immediate need and also the hard copy output. It

is the most important and direct source information to the user. Efficient and

intelligent output design improves the systems relationship to help user decision

making.


32/95

5.5Data Flow Diagram

ADMIN

Doctor

Data Storage

Admin

Employee

UI Screens

Reports

Data Input StageData Out Put Stage

Emplo.

Doctor

Patient Billing

Login DFD

Open Login

form

Enter User

Name and

Password

Check User

Verification

Data

Login Master

User Home

PageYes Yes

No


33/95

Admin Activities (1stLevel)

Open

Form()

1.0.0

Enter Login

Details

1.0.1

Login Master

Doctors

registration

1.0.2

Verificatio

nValidation

Employee

registration1.0.3

Doctors Master

Generate

Pay slips

1.0.4

Pay Slips

Details

Patient

Reports

1.0.6

Manage

Reports

1.0.5

User Reports

Patient Details

Employee

Details


34/95

Admin Register Doctors

Doctor Registration

1.2.1

Get Doctor ID

1.2.2

Get doctor name

1.2.3

Get Qulification

1.2.4

Validates

Data

Validates

Data

Validates

Data

Specialzation

1.2.5

Doctor Details


35/95

Admin Register Employee

Employee

Registration

1.2.1

Employee ID

1.2.2

Employee name

1.2.3

Get Qulification

1.2.4

Validates

Data

Validates

Data

Validates

Data

Designation

1.2.5

Employee

Details

User (Employee) Activities (2ndLevel):

New Patient

Registration

2.0.2

Login Account

Details

Enter Login

Details

2.0.1

Validates

Data

Queries

2.0.3

Patient

Details

Data Storage

Log out

Open Form()

2.0.0

Verifies

Data

Generate Bills

2.0.4

Data Storage


36/95

Chapter 6

Testing and Implementation


37/95

6. SYSTEM IMPLEMENTATION AND TESTING

6.1.SYSTEM TESTING

A strategy for software testing may also be viewed in the context of the spiral. Unittesting begins at the vertex of the spiral and concentrates on each unit of the

software as implemented in source code. Testing progress by moving outward

along the spiral to integration testing, where the focus is on the design and the

construction of the software architecture. Talking another turn on outward on the

spiral we encounter validation testing where requirements established as part of

software requirements analysis are validated against the software that has been

constructed. Finally we arrive at system testing, where the software and other

system elements are tested as a whole.

UNIT TESTING

All modules were tested and individually as soon as they were completed and were

checked for their correct functionality.Unit testing focuses verification effort on the

smallest unit of software design, the module. The unit testing we have is white box

oriented and some modules the steps are conducted in parallel. To follow the

concept of white box testing we have tested each form .we have created

independently to verify that Data flow is correct, All conditions are exercised to

check their validity, All loops are executed on their boundaries.

INTEGRATION TESTING

The entire project was split into small program; each of this single programs

gives a frame as an output. These programs were tested individually; at last all

these programs where combined together by creating another program where all


38/95

these constructors were used. It give a lot of problem by not functioning is an

integrated manner.

The user interface testing is important since the user has to declare that the

arrangements made in frames are convenient and it is satisfied. when the frames

where given for the test, the end user gave suggestion. Based on their suggestions

the frames where modified and put into practice.

VALIDATION TESTING

At the culmination of the black box testing software is completely assembled as a

package. Interfacing errors have been uncovered and corrected and a final series of

test i.e., Validation succeeds when the software function in a manner that can be

reasonably Accepted by the customer.

6.2. SYSTEM IMPLEMENTATION

System implementation is stage in the project where the theoretical design isturned into the working system. The most crucial stage is giving the users

confidence that the new system will work effectively and efficiently.

The performance of reliability of the system is tested and it gained acceptance. The

system was implemented successfully. Implementation is a process that means

converting a new system in to operation.

Proper implementation is essential to provide a reliable system to meet

organization requirements. During the implementation stage a live demon was

undertaken and made in front of end-users. The various features provided in the

system were discussed during implementation.


39/95

Chapter 7

FUTURE ENHANCEMENT


40/95

7. FUTURE ENHANCEMENT

I have derived immense pleasure in completing this project.

This project has not only helped me to learn in depth but also improved the

system design capabilities.

In our project we developed to manage the patient management

system. It can handle the patient details as well as doctors details and staff

so it is easy to maintain a patient records in our project. We can retrieve a

large data in a short time.

In future we enhance Patient management in online. Thats very

helpful to use our project in anywhere. We can enhance the sms concept in

appointment info by using GSM concepts. Once we make an appointment

that will intimate through sms if your appointment is conform or not


41/95

Chapter 8

CONCLUSION


42/95

8. CONCLUSIONI have successfully completed the project PATIENT

MANAGEMENT SYSTEM Using Visual Basic 6.0 as Front End and MS Accessas Back End. The developed system deals with the computerization of both patient

and hospital management with In patients, Out Patients, Doctors Info, Patients

Info, Appoinment Info, Deparment Info , Staff Info, Hospital Info, Visitors Info.

This system is partially implemented because of time consumption and low

cost.The developed system is completely menu driven and extremely user friendly.

So it can easily used by any user.

APPENDICES

A.INPUT SCREEN


43/95

B.SAMPLE CODING

Login Page


44/95


45/95

If LCase(txtUserId.Text) = LCase(dataLogin.Recordset(1).Value) And

LCase(txtPassword.Text) = LCase(dataLogin.Recordset(2).Value) And cmbUserType.Text =

dataLogin.Recordset(3).Value ThenIsValidUser = True

End If

dataLogin.Recordset.MoveNextWendIf IsValidUser = True Then

If cmbUserType.Text = "Admin" Then

frmMainFormAdmin.ShowElseIf cmbUserType.Text = "Doctor" Then

frmMainfromdoctor.Show

ElseIf cmbUserType.Text = "Staff" Then

frmMainFormStaff.ShowEnd If

Me.Hide

Else

MsgBox "Invalid User"

txtUserId.SetFocus

End IfEnd If

End Sub

Private Sub txtPassword_KeyDown(KeyCode As Integer, Shift As Integer)

If KeyCode = 13 ThencmbUserType.SetFocus

End If

End Sub

Private Sub txtUserId_KeyDown(KeyCode As Integer, Shift As Integer)

If KeyCode = 13 ThentxtPassword.SetFocus

End If

End Sub

Main Form Admin


46/95

Private Sub cmdBack_Click()

Me.Hide

FrmLogin.ShowFrmLogin.txtUserId = ""

FrmLogin.txtPassword = ""

FrmLogin.cmbUserType = ""End Sub

Private Sub cmdstaffinfo_Click()

Me.HidefrmStaffinfo.Show

End Sub

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)If KeyCode = 27 Then

If MsgBox("Do you want to close?", vbYesNo, "PMS") = vbYes Then

Unload MeEnd If

End If

End SubPrivate Sub cmddepartmentinfo_Click()

Me.Hide

frmDepartmentinfo.ShowEnd Sub

Private Sub cmddoctorinfo_Click()

Me.HidefrmDoctorinfo.Show

End Sub

Private Sub cmdHospitalInfo_Click()

Me.Hide

frmHospitalinfo.ShowEnd Sub

Private Sub cmdPatientinfo_Click()

Me.HidefrmPatientinfo.Show

End Sub

STAFF MAIN FORM


47/95


Me.Hide

FrmLogin.ShowFrmLogin.txtUserId = ""

FrmLogin.txtPassword = ""

FrmLogin.cmbUserType = ""

End Sub

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)If KeyCode = 27 Then


Unload Me

End IfEnd If

End SubPrivate Sub Appointmentinfo_Click()

Me.Hide

frmAppointmentinfo.Show

End Sub

Private Sub cmdVisitorsinfo_Click()

Me.HidefrmVisitorsinfo.Show

End Sub

MAIN DOCTOR FORM

Private Sub cmdBack_Click()Me.Hide

FrmLogin.Show

FrmLogin.txtUserId = ""FrmLogin.txtPassword = ""

FrmLogin.cmbUserType = ""

End Sub

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)

If KeyCode = 27 Then


Unload MeEnd If

End If

End Sub


48/95

Private Sub cmdAppointmentinfo_Click()

frmAppointmentinfo.ShowMe.Hide

End Sub

Private Sub cmdInpatientinfo_Click()frmInpatientinfo.Show

Me.Hide

End Sub

Private Sub cmdOutpatientinfo_Click()

frmOutpatientinfo.Show

Me.HideEnd Sub

Private Sub cmdPatientinfo_Click()frmPatientinfo.Show

Me.Hide

End Sub

APPOINTMENT FORM


Txtdate = ""

Txtdoctorname = ""

Txtid = ""Txtpatientname = ""

cmbTiming = ""

If MsgBox("Do you want to move staff form ?", vbYesNo) = vbYes ThenfrmMainFormStaff.Show

Me.Hide

ElsefrmMainfromdoctor.Show

Me.Hide

End If

End Sub

Private Sub cmdDelete_Click()

If MsgBox("Are you Delete this Record?", vbYesNo) = vbYes Then

If DataAppoitnmentinfo.Recordset.RecordCount = 0 ThenMsgBox "No record"

Else

DataAppointmentinfo.Recordset.MoveFirstDo While Not DataAppointmentinfo.Recordset.EOF


49/95

If Txtid.Text = DataAppointmentinfo.Recordset(0).Value Then

DataAppointmentinfo.Recordset.Delete

MsgBox "Deleted"Exit Do

End If

DataAppointmentinfo.Recordset.MoveNextLoopEnd If

End If

Txtid = ""Txtdate = ""

Txtdoctorname = ""

Txtid = ""

Txtpatientname = ""cmbTiming = ""

Txtdate.SetFocus

End Sub

Private Sub cmdNew_Click()

Txtid.Text = DataAppointmentinfo.Recordset.RecordCount + 1cmbTiming.Text = ""

Txtdoctorname.Text = ""

Txtdate = ""Txtpatientname = ""

Txtdate.SetFocus

End Sub

Private Sub cmdSave_Click()

If Txtid = "" Then

MsgBox ("Please enter the id")Txtid.SetFocus

ElseIf Txtdoctorname = "" Then

MsgBox ("Please enter the doctorname")Txtdoctorname.SetFocus

ElseIf Txtpatientname = "" Then

MsgBox ("Please enter the patientname")

Txtpatientname.SetFocusElseIf cmbTiming = "" Then

MsgBox ("Please enter the timings")

cmbTiming.SetFocus

ElseDim IsExistRec As Boolean

IsExistRec = False

If DataAppointmentinfo.Recordset.RecordCount > 0 Then


50/95

DataAppointmentinfo.Recordset.MoveFirst

End If

Do While Not DataAppointmentinfo.Recordset.EOF

If Txtid.Text = DataAppointmentinfo.Recordset(0).Value Then

IsExistRec = TrueExit DoEnd If

DataAppointmentinfo.Recordset.MoveNext

Loop

If IsExistRec = True Then

DataAppointmentinfo.Recordset.Edit

ElseDataAppointmentinfo.Recordset.AddNew

End If

DataAppointmentinfo.Recordset(0) = Txtid.Text

DataAppointmentinfo.Recordset(1) = Txtdate.Text

DataAppointmentinfo.Recordset(2) = Txtdoctorname.TextDataAppointmentinfo.Recordset(3) = Txtpatientname.Text

DataAppointmentinfo.Recordset(4) = cmbTiming.Text

DataAppointmentinfo.Recordset.Update

MsgBox "Saved"

End If

Txtid = ""Txtdate = ""

Txtdoctorname = ""

Txtid = ""Txtpatientname = ""

cmbTiming = ""

Txtdate.SetFocusEnd Sub

Private Sub cmdSearch_Click()

Dim IsExistRec As Boolean

IsExistRec = False

If DataAppointmentinfo.Recordset.RecordCount > 0 ThenDataAppointmentinfo.Recordset.MoveFirst

End If

Do While Not DataAppointmentinfo.Recordset.EOF


51/95


52/95

End If

End If

End Sub

Private Sub Txtdate_KeyDown(KeyCode As Integer, Shift As Integer)If KeyCode = 13 ThenTxtdoctorname.SetFocus

End If

End Sub

Private Sub Txtdate_KeyPress(KeyAscii As Integer)

If (KeyAscii >= Asc("A") And KeyAscii = Asc("a") And KeyAscii

= Asc("0") And KeyAscii = Asc("0") And KeyAscii


53/95

End Sub

Private Sub cmbTiming_KeyDown(KeyCode As Integer, Shift As Integer)If KeyCode = 13 Then

cmdSave.SetFocus

End IfEnd Sub

DEPARTMENT INFO


Me.Hide

frmMainFormAdmin.Show

End Sub

Private Sub Form_Activate()

If Datadepartment.Recordset.RecordCount > 0 ThenDatadepartment.Recordset.MoveFirst

End If

cmbSearch.Clear

Do While Not Datadepartment.Recordset.EOFcmbSearch.AddItem (Datadepartment.Recordset(1).Value)

Datadepartment.Recordset.MoveNext

LoopEnd Sub



If MsgBox("Do you want to close?", vbYesNo, "PMS") = vbYes ThenUnload Me

End If

End If

End Sub

Private Sub cmdDelete_Click()If MsgBox("Are you Delete this Record?", vbYesNo) = vbYes Then

If Datadepartment.Recordset.RecordCount = 0 Then

MsgBox "No record"

ElseDatadepartment.Recordset.MoveFirst

Do While Not Datadepartment.Recordset.EOF

If Txtid.Text = Datadepartment.Recordset(0).Value Then

Datadepartment.Recordset.DeleteMsgBox "Delted"

Exit Do

End IfDatadepartment.Recordset.MoveNext


54/95

Loop

End If

End IfTxtid.Text = ""

Txtname.Text = ""

Txtdescription.Text = ""Txtid.SetFocusEnd Sub

Private Sub cmdNew_Click()Txtid.Text = Datadepartment.Recordset.RecordCount + 1

Txtname.Text = ""

Txtdescription.Text = ""

Txtname.SetFocusEnd Sub

Private Sub cmdSave_Click()If Txtid = "" Then

MsgBox ("Please enter the id")

ElseIf Txtdescription = "" Then

MsgBox ("Please enter the description")ElseIf Txtname = "" Then

MsgBox ("Please enter the name of the department")

ElseDim IsExistRec As Boolean

IsExistRec = False

If Datadepartment.Recordset.RecordCount > 0 ThenDatadepartment.Recordset.MoveFirst

End If


If Txtid.Text = Datadepartment.Recordset(0).Value Then

IsExistRec = TrueExit Do

End If


Loop


Datadepartment.Recordset.Edit

ElseDatadepartment.Recordset.AddNew

End If


55/95

Datadepartment.Recordset(0) = Txtid.Text

Datadepartment.Recordset(1) = Txtname.Text

Datadepartment.Recordset(2) = Txtdescription.TextDatadepartment.Recordset.Update

MsgBox "Saved"End IfTxtid.Text = ""

Txtname.Text = ""

Txtdescription.Text = ""Txtname.SetFocus

End Sub

Private Sub cmdSearch_Click()Dim IsExistRec As Boolean

IsExistRec = False

If Datadepartment.Recordset.RecordCount > 0 Then

Datadepartment.Recordset.MoveFirst

End If


If LCase(cmbSearch.Text) = LCase(Datadepartment.Recordset(1).Value) Then


End If


Loop


Txtid.Text = Datadepartment.Recordset(0)Txtname.Text = Datadepartment.Recordset(1)

Txtdescription.Text = Datadepartment.Recordset(2)

Else

MsgBox "Record not found"

End If

End Sub

Private Sub cmdView_Click()

rptDepartmentinfo.Show

End Sub


56/95

Private Sub Txtdescription_KeyDown(KeyCode As Integer, Shift As Integer)


cmdSave.SetFocusEnd If

End Sub

Private Sub Txtid_KeyDown(KeyCode As Integer, Shift As Integer)If KeyCode = 13 Then

Txtname.SetFocus

End IfEnd Sub

Private Sub Txtname_KeyDown(KeyCode As Integer, Shift As Integer)

If KeyCode = 13 ThenTxtdescription.SetFocus

End If

End Sub

Private Sub Txtname_KeyPress(KeyAscii As Integer)

If (KeyAscii >= Asc("0") And KeyAscii 0 Then

datadoctor.Recordset.MoveFirstEnd If

cmbSearch.Clear

Do While Not datadoctor.Recordset.EOF

cmbSearch.AddItem (datadoctor.Recordset(1).Value)datadoctor.Recordset.MoveNext

Loop

End Sub





57/95

End If

End If

End Sub


If MsgBox("Are you Delete this Record?", vbYesNo) = vbYes ThenIf datadoctor.Recordset.RecordCount = 0 ThenMsgBox "No record"

Else

datadoctor.Recordset.MoveFirstDo While Not datadoctor.Recordset.EOF

If Txtid.Text = datadoctor.Recordset(0).Value Then

datadoctor.Recordset.Delete

MsgBox "Delted"Exit Do

End If

datadoctor.Recordset.MoveNextLoop

End If

End If

Txtid.Text = ""Txtname.Text = ""

txtaddress.Text = ""

txtphoneno.Text = ""cmbSpecialist = ""

Txtmailid.Text = ""

txthospitalname = ""


Private Sub cmdNew_Click()Txtid.Text = datadoctor.Recordset.RecordCount + 1

Txtname.Text = ""

txtaddress.Text = ""txtphoneno.Text = ""

cmbSpecialist = ""

Txtmailid.Text = ""

txthospitalname = ""Txtname.SetFocus

End Sub

Private Sub cmdSave_Click()If Txtname = "" Then

MsgBox ("Please enter the name of the doctor")

ElseIf txtaddress = "" ThenMsgBox ("Please enter the address of doctor")


58/95


59/95


60/95

Private Sub txthospitalname_KeyDown(KeyCode As Integer, Shift As Integer)


cmbSpecialist.SetFocusEnd If

End Sub

Private Sub txthospitalname_KeyPress(KeyAscii As Integer)If (KeyAscii >= Asc("0") And KeyAscii = Asc("0") And KeyAscii = Asc("A") And KeyAscii = Asc("a") And KeyAscii


61/95

End Sub

Private Sub cmbSpecialist_KeyDown(KeyCode As Integer, Shift As Integer)If KeyCode = 13 Then

cmdSave.SetFocus

End IfEnd Sub

Private Sub cmbSpecialist_KeyPress(KeyAscii As Integer)

If (KeyAscii >= Asc("0") And KeyAscii 0 Then

dataHospital.Recordset.MoveFirstEnd If

cmbSearch.Clear

Do While Not dataHospital.Recordset.EOF

cmbSearch.AddItem (dataHospital.Recordset(1).Value)dataHospital.Recordset.MoveNext

Loop

End SubPrivate Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)



End If

End If

End Sub



If dataHospital.Recordset.RecordCount = 0 ThenMsgBox "No record"

Else

dataHospital.Recordset.MoveFirstDo While Not dataHospital.Recordset.EOF


62/95

If txtHospitalId.Text = dataHospital.Recordset(0).Value Then

dataHospital.Recordset.Delete


End If

dataHospital.Recordset.MoveNextLoopEnd If

End If

txtHospitalId.Text = ""Txtname.Text = ""

txtaddress.Text = ""

txtphoneno.Text = ""

txtInchargename.Text = ""Txtname.SetFocus

End Sub


txtHospitalId.Text = dataHospital.Recordset.RecordCount + 1

Txtname.Text = ""


txtInchargename.Text = ""



If txtaddress = "" ThenMsgBox ("Please enter the address")

ElseIf txtInchargename = "" Then

MsgBox ("Please enter the Inchargename")ElseIf Txtname = "" Then

MsgBox ("Please enter the name")

ElseIf txtphoneno = "" ThenMsgBox ("Please enter the phoneno")

Else


IsExistRec = False

If dataHospital.Recordset.RecordCount > 0 Then

dataHospital.Recordset.MoveFirst

End If

Do While Not dataHospital.Recordset.EOF

If txtHospitalId.Text = dataHospital.Recordset(0).Value ThenIsExistRec = True


63/95

Exit Do

End If

dataHospital.Recordset.MoveNextLoop

If IsExistRec = True ThendataHospital.Recordset.EditElse

dataHospital.Recordset.AddNew

End If

dataHospital.Recordset(0) = txtHospitalId.Text

dataHospital.Recordset(1) = Txtname.Text

dataHospital.Recordset(2) = txtaddress.TextdataHospital.Recordset(3) = txtphoneno.Text

dataHospital.Recordset(4) = txtInchargename.Text

dataHospital.Recordset.Update

MsgBox "Saved"

End IftxtHospitalId.Text = ""

Txtname.Text = ""


txtInchargename.Text = ""

Txtname.SetFocus

End Sub

Private Sub cmdSearch_Click()

Dim IsExistRec As BooleanIsExistRec = False

If dataHospital.Recordset.RecordCount > 0 ThendataHospital.Recordset.MoveFirst

End If

Do While Not dataHospital.Recordset.EOFIf LCase(cmbSearch.Text) = LCase(dataHospital.Recordset(1).Value) Then

IsExistRec = True

Exit Do

End IfdataHospital.Recordset.MoveNext

Loop



64/95

txtHospitalId.Text = dataHospital.Recordset(0)

Txtname.Text = dataHospital.Recordset(1)

txtaddress.Text = dataHospital.Recordset(2)txtphoneno.Text = dataHospital.Recordset(3)

txtInchargename.Text = dataHospital.Recordset(4)

ElseMsgBox "Record not found"End If

End Sub


rptHospitalinfo.ShowEnd Sub

Private Sub txtaddress_KeyDown(KeyCode As Integer, Shift As Integer)If KeyCode = 13 Then

txtphoneno.SetFocus

End If

End Sub

Private Sub txtHospitalId_KeyDown(KeyCode As Integer, Shift As Integer)

If KeyCode = 13 ThenTxtname.SetFocus

End If

End Sub

Private Sub txtInchargename_KeyDown(KeyCode As Integer, Shift As Integer)


cmdSave.SetFocusEnd If

End Sub

Private Sub txtInchargename_KeyPress(KeyAscii As Integer)

If (KeyAscii >= Asc("0") And KeyAscii


65/95


If (KeyAscii >= Asc("0") And KeyAscii = Asc("A") And KeyAscii = Asc("a") And KeyAscii 0 ThenDataInpatientinfo.Recordset.MoveFirst

End If

cmbSearch.ClearDo While Not DataInpatientinfo.Recordset.EOF

cmbSearch.AddItem (DataInpatientinfo.Recordset(1).Value)

DataInpatientinfo.Recordset.MoveNextLoop

End Sub


If KeyCode = 27 ThenIf MsgBox("Do you want to close?", vbYesNo, "PMS") = vbYes Then

Unload Me

End If

End If

End Sub

Private Sub cmdDelete_Click()If MsgBox("Are you Delete this Record?", vbYesNo) = vbYes Then


66/95

If DataInpatientinfo.Recordset.RecordCount = 0 Then

MsgBox "No record"

ElseDataInpatientinfo.Recordset.MoveFirst

Do While Not DataInpatientinfo.Recordset.EOF

If Txtid.Text = DataInpatientinfo.Recordset(0).Value ThenDataInpatientinfo.Recordset.DeleteMsgBox "Delted"

Exit Do

End IfDataInpatientinfo.Recordset.MoveNext

Loop

End If

End IfTxtid.Text = ""


Txtpatientname.Text = ""cmbDepartment.Text = ""

Txtindate.Text = ""

Txtoutdate.Text = ""

Txtfeesamount.Text = ""Txtpaidamount.Text = ""

Txtmedicalreport.Text = ""

Txttabletinfo.Text = ""Txtdoctorname.SetFocus

End Sub

Private Sub cmdNew_Click()Txtid.Text = DataInpatientinfo.Recordset.RecordCount + 1


Txtpatientname.Text = ""cmbDepartment.Text = ""

Txtindate.Text = ""

Txtoutdate.Text = ""Txtfeesamount.Text = ""

Txtpaidamount.Text = ""

Txtmedicalreport.Text = ""

Txttabletinfo.Text = ""Txtdoctorname.SetFocus

End Sub

Private Sub cmdSave_Click()If cmbDepartment = "" Then

MsgBox ("Please enter the epartment")

ElseIf Txtdoctorname = "" ThenMsgBox ("Please enter the doctorname")


67/95

ElseIf Txtfeesamount = "" Then

MsgBox ("Please enter the feesamount")

ElseIf Txtindate = "" ThenMsgBox ("Please enter the indate")

ElseIf Txtoutdate = "" Then

MsgBox ("Please enter the outdate")ElseIf Txtmedicalreport = "" ThenMsgBox ("Please enter the medicalreport")

ElseIf Txtpaidamount = "" Then

MsgBox ("Please enter the paid amount")ElseIf Txtpatientname = "" Then

MsgBox ("Please enter the patient name")

ElseIf Txttabletinfo = "" Then

MsgBox ("Please enter the tabletinfo")Else


If DataInpatientinfo.Recordset.RecordCount > 0 Then

DataInpatientinfo.Recordset.MoveFirstEnd If

Do While Not DataInpatientinfo.Recordset.EOFIf Txtid.Text = DataInpatientinfo.Recordset(0).Value Then

IsExistRec = True

Exit Do

End IfDataInpatientinfo.Recordset.MoveNext

Loop


DataInpatientinfo.Recordset.Edit

ElseDataInpatientinfo.Recordset.AddNew

End If

DataInpatientinfo.Recordset(0) = Txtid.TextDataInpatientinfo.Recordset(1) = Txtdoctorname.Text

DataInpatientinfo.Recordset(2) = Txtpatientname.Text

DataInpatientinfo.Recordset(3) = cmbDepartment.Text

DataInpatientinfo.Recordset(4) = Txtindate.TextDataInpatientinfo.Recordset(5) = Txtoutdate.Text

DataInpatientinfo.Recordset(6) = Txtfeesamount.Text

DataInpatientinfo.Recordset(7) = Txtpaidamount.TextDataInpatientinfo.Recordset(8) = Txtmedicalreport.Text


68/95


69/95

Else

MsgBox "Record not found"End If

End Sub


rptInpatientinfo.ShowEnd Sub

Private Sub cmbDepartment_KeyDown(KeyCode As Integer, Shift As Integer)If KeyCode = 13 Then

Txtindate.SetFocus

End IfEnd Sub

Private Sub cmbDepartment_KeyPress(KeyAscii As Integer)

If (KeyAscii >= Asc("0") And KeyAscii 0 ThenDataPatientinfo.Recordset.MoveFirst

End If

Do While Not DataPatientinfo.Recordset.EOF

varnt = DataPatientinfo.Recordset(10)

Set RP = New FPTemplate


70/95

er = RP.Import(varnt)

re = VP.Compare(RP, FPVerVeiw1.Template, Result, src, thsh, False, Sm_None)

Set RP = NothingIf Result = True Then

IsExistRec = True

Exit DoEnd IfDataPatientinfo.Recordset.MoveNext

Loop


Txtpatientname.Text = DataPatientinfo.Recordset(1)

Dim i As Integer

i = 0

MSFlexGrid1.Rows = 0



Do While Not DataInpatientinfo.Recordset.EOFIf LCase(Txtpatientname.Text) = LCase(DataInpatientinfo.Recordset(2).Value) Then

i = i + 1

MSFlexGrid1.Rows = MSFlexGrid1.Rows + 1

MSFlexGrid1.Row = i - 1

MSFlexGrid1.Col = 0

MSFlexGrid1.Text = i

MSFlexGrid1.Col = 1

MSFlexGrid1.Text = DataInpatientinfo.Recordset(1).Value

MSFlexGrid1.Col = 2MSFlexGrid1.Text = DataInpatientinfo.Recordset(2).Value

MSFlexGrid1.Col = 3


MSFlexGrid1.Col = 4



71/95

MSFlexGrid1.Col = 5


MSFlexGrid1.Col = 5


End If

DataInpatientinfo.Recordset.MoveNextLoop

Else

Txtpatientname.Text = ""End If

End If

End Sub

Private Sub Txtdoctorname_KeyDown(KeyCode As Integer, Shift As Integer)


Txtpatientname.SetFocusEnd If

End Sub

Private Sub Txtfeesamount_KeyDown(KeyCode As Integer, Shift As Integer)


Txtpaidamount.SetFocus

End IfEnd Sub

Private Sub Txtfeesamount_KeyPress(KeyAscii As Integer)If (KeyAscii >= Asc("A") And KeyAscii = Asc("a") And KeyAscii


72/95

End Sub

Private Sub Txtindate_KeyPress(KeyAscii As Integer)If (KeyAscii >= Asc("A") And KeyAscii = Asc("a") And KeyAscii

= Asc("A") And KeyAscii = Asc("a") And KeyAscii



73/95

Private Sub Txtpatientname_KeyPress(KeyAscii As Integer)If (KeyAscii >= Asc("0") And KeyAscii


74/95

End Sub

Private Sub cmdNew_Click()Txtid.Text = DataOutpatientinfo.Recordset.RecordCount + 1


Txtpatientname.Text = ""Txtmedicalreport.Text = ""Txttabletinfo.Text = ""

Txtdate.Text = ""

cmbTiming.Text = ""Txtfeesamount.Text = ""

Txtdoctorname.SetFocus

End Sub


If Txtdoctorname = "" Then

MsgBox ("Please enter the doctorname")ElseIf Txtfeesamount = "" Then

MsgBox ("Please enter the feesamount")

ElseIf Txtpatientname = "" Then

MsgBox ("Please enter the patient name")ElseIf Txttabletinfo = "" Then

MsgBox ("Please enter the tabletinfo")

ElseIf Txtmedicalreport = "" ThenMsgBox ("Please enter the medicalreport")

ElseIf Txtdate = "" Then

MsgBox ("Please enter the date")

ElseIf cmbTiming = "" ThenMsgBox ("Please enter the timings")

Else


If DataOutpatientinfo.Recordset.RecordCount > 0 ThenDataOutpatientinfo.Recordset.MoveFirst

End If

Do While Not DataOutpatientinfo.Recordset.EOFIf Txtid.Text = DataOutpatientinfo.Recordset(0).Value Then

IsExistRec = True

Exit Do

End IfDataOutpatientinfo.Recordset.MoveNext

Loop



75/95


76/95

Else

MsgBox "Record not found"End If

End Sub

Private Sub Timer1_Timer()If FPVerVeiw1.Done = True Then

Dim RP As FPTemplate

Dim VP As New FPVerify

Dim Result As BooleanDim er, re As String

Dim src, thsh As Object


IsExistRec = False

If DataPatientinfo.Recordset.RecordCount > 0 ThenDataPatientinfo.Recordset.MoveFirst

End If


varnt = DataPatientinfo.Recordset(10)

Set RP = New FPTemplate

er = RP.Import(varnt)

re = VP.Compare(RP, FPVerVeiw1.Template, Result, src, thsh, False, Sm_None)Set RP = Nothing

If Result = True Then


End If

DataPatientinfo.Recordset.MoveNext

Loop


Txtpatientname.Text = DataPatientinfo.Recordset(1)

Dim i As Integer

i = 0

MSFlexGrid1.Rows = 0


77/95



While Not DataInpatientinfo.Recordset.EOFIf LCase(Txtpatientname.Text) = LCase(DataInpatientinfo.Recordset(2).Value) Then

i = i + 1

MSFlexGrid1.Rows = MSFlexGrid1.Rows + 1

MSFlexGrid1.Row = i - 1

MSFlexGrid1.Col = 0MSFlexGrid1.Text = i

MSFlexGrid1.Col = 1MSFlexGrid1.Text = DataOutpatientinfo.Recordset(1).Value

MSFlexGrid1.Col = 2

MSFlexGrid1.Text = DataOutpatientinfo.Recordset(2).Value

MSFlexGrid1.Col = 3


MSFlexGrid1.Col = 4


MSFlexGrid1.Col = 5


MSFlexGrid1.Col = 6


Loop

Else

Txtpatientname.Text = ""

End If

End Sub


If DataOutpatientinfo.Recordset.RecordCount > 0 Then

DataOutpatientinfo.Recordset.MoveFirstEnd If


78/95

cmbSearch.Clear

Do While Not DataOutpatientinfo.Recordset.EOF

cmbSearch.AddItem (DataOutpatientinfo.Recordset(2).Value)DataOutpatientinfo.Recordset.MoveNext

Loop

End SubPrivate Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)If KeyCode = 27 Then


Unload MeEnd If

End If

End Sub

Private Sub cmdView_Click()rptOutpatientinfo.Show

End Sub

Private Sub Txtdate_KeyDown(KeyCode As Integer, Shift As Integer)If KeyCode = 13 Then

cmbTiming.SetFocus

End IfEnd Sub

Private Sub Txtdate_KeyPress(KeyAscii As Integer)

If (KeyAscii >= Asc("A") And KeyAscii = Asc("a") And KeyAscii= Asc("0") And KeyAscii


79/95


cmdSave.SetFocus

End IfEnd Sub

Private Sub Txtfeesamount_KeyPress(KeyAscii As Integer)If (KeyAscii >= Asc("A") And KeyAscii = Asc("a") And KeyAscii= Asc("0") And KeyAscii


80/95

End Sub

PATIENT INFO


If MsgBox("Do you want to move Admin form ", vbYesNo) = vbYes ThenfrmMainFormAdmin.ShowMe.Hide

Else

frmMainfromdoctor.ShowMe.Hide

End If

End Sub


If DataPatientinfo.Recordset.RecordCount > 0 Then

DataPatientinfo.Recordset.MoveFirstEnd If

cmbSearch.Clear


cmbSearch.AddItem (DataPatientinfo.Recordset(1).Value)DataPatientinfo.Recordset.MoveNext

Loop

End SubPrivate Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)



Unload MeEnd If

End If

End Sub

Private Sub cmbgender_KeyDown(KeyCode As Integer, Shift As Integer)If KeyCode = 13 Then

txtaddress.SetFocus

End If

End Sub



If DataPatientinfo.Recordset.RecordCount = 0 ThenMsgBox "No record"

Else

DataPatientinfo.Recordset.MoveFirstDo While Not DataPatientinfo.Recordset.EOF


81/95

If Txtid.Text = DataPatientinfo.Recordset(0).Value Then

DataPatientinfo.Recordset.Delete


End If

DataPatientinfo.Recordset.MoveNextLoopEnd If

End If


txtAge.Text = ""

cmbgender.Text = ""

txtaddress.Text = ""cmbBloodgroup.Text = ""

TxtHeight.Text = ""

TxtWeight.Text = ""txtphoneno.Text = ""

Txtregistrationdate = ""

Txtname.SetFocus

End Sub


Txtid.Text = DataPatientinfo.Recordset.RecordCount + 1Txtname.Text = ""

txtAge.Text = ""

cmbgender.Text = ""

txtaddress.Text = ""cmbBloodgroup.Text = ""

TxtHeight.Text = ""

TxtWeight.Text = ""txtphoneno.Text = ""

Txtregistrationdate = ""



If txtAge = "" ThenMsgBox ("enter the age")

ElseIf cmbBloodgroup = "" Then

MsgBox ("Please enter the bloodgroup")

ElseIf Txtname = "" ThenMsgBox ("Please enter the name")

ElseIf Txtregistrationdate = "" Then

MsgBox ("Please enter the registration date")ElseIf txtphoneno = "" Then


82/95

MsgBox ("Please enter the phone number")

Else


If DataPatientinfo.Recordset.RecordCount > 0 ThenDataPatientinfo.Recordset.MoveFirstEnd If

Do While Not DataPatientinfo.Recordset.EOFIf Txtid.Text = DataPatientinfo.Recordset(0).Value Then

IsExistRec = True

Exit Do

End IfDataPatientinfo.Recordset.MoveNext

Loop


DataPatientinfo.Recordset.Edit

Else

DataPatientinfo.Recordset.AddNewEnd If

If FPRegView1.register Is Nothing Then

MsgBox "Nothing Registered !!"

Exit Sub

End If

Dim bvariant As Variant

bvariant = Null

FPRegView1.register.Export bvariant

DataPatientinfo.Recordset(0) = Txtid.Text

DataPatientinfo.Recordset(1) = Txtname.Text

DataPatientinfo.Recordset(2) = txtAge.TextDataPatientinfo.Recordset(3) = cmbgender.Text

DataPatientinfo.Recordset(4) = txtaddress.Text

DataPatientinfo.Recordset(5) = cmbBloodgroup.Text

DataPatientinfo.Recordset(6) = TxtHeight.TextDataPatientinfo.Recordset(7) = TxtWeight.Text

DataPatientinfo.Recordset(8) = txtphoneno.Text

DataPatientinfo.Recordset(9) = Txtregistrationdate.Text


83/95


84/95

rptPatientinfo.Show

End Sub

Private Sub Timer1_Timer()

If FPRegView1.Done = True Then

lblFPReady.Caption = "Ready"ElselblFPReady.Caption = "Not Ready"

End If

End Sub

Private Sub txtaddress_KeyDown(KeyCode As Integer, Shift As Integer)


cmbBloodgroup.SetFocusEnd If

End Sub

Private Sub Txtage_KeyDown(KeyCode As Integer, Shift As Integer)


cmbgender.SetFocus

End IfEnd Sub

Private Sub Txtage_KeyPress(KeyAscii As Integer)If (KeyAscii >= Asc("A") And KeyAscii = Asc("a") And KeyAscii



85/95

End If

End Sub

Private Sub Txtid_KeyDown(KeyCode As Integer, Shift As Integer)


Txtname.SetFocusEnd IfEnd Sub

Private Sub Txtname_KeyDown(KeyCode As Integer, Shift As Integer)If KeyCode = 13 Then

txtAge.SetFocus

End If

End Sub


If (KeyAscii >= Asc("0") And KeyAscii = Asc("A") And KeyAscii = Asc("a") And KeyAscii



86/95


87/95

DataStaffinfo.Recordset.Delete

MsgBox "Delted"

Exit DoEnd If

DataStaffinfo.Recordset.MoveNext

LoopEnd IfEnd If

Txtid.Text = ""

Txtname.Text = ""txtphoneno.Text = ""

Txtmailid.Text = ""

Cmbdestination.Text = ""

txtaddress.Text = ""Txtsalary.Text = ""

Txtname.SetFocus

End Sub


Txtid.Text = DataStaffinfo.Recordset.RecordCount + 1

Txtname.Text = ""txtphoneno.Text = ""

Txtmailid.Text = ""

Cmbdestination.Text = ""txtaddress.Text = ""

Txtsalary.Text = ""

Txtname.SetFocus

End Sub


If txtaddress = "" ThenMsgBox ("Please enter the address")

ElseIf Txtname = "" Then

MsgBox ("Please enter the name")ElseIf txtphoneno = "" Then

MsgBox ("Please enter the phone number")

ElseIf Txtsalary = "" Then

MsgBox ("Please enter the salary")Else


IsExistRec = False

If DataStaffinfo.Recordset.RecordCount > 0 Then

DataStaffinfo.Recordset.MoveFirst

End If


88/95

Do While Not DataStaffinfo.Recordset.EOF

If Txtid.Text = DataStaffinfo.Recordset(0).Value Then


End If

DataStaffinfo.Recordset.MoveNextLoop


DataStaffinfo.Recordset.EditElse

DataStaffinfo.Recordset.AddNew

End If

DataStaffinfo.Recordset(0) = Txtid.Text

DataStaffinfo.Recordset(1) = Txtname.Text

DataStaffinfo.Recordset(2) = txtphoneno.TextDataStaffinfo.Recordset(3) = Txtmailid.Text

DataStaffinfo.Recordset(4) = Cmbdestination.Text

DataStaffinfo.Recordset(5) = txtaddress.Text

DataStaffinfo.Recordset(6) = Txtsalary.TextDataStaffinfo.Recordset.Update

MsgBox "Saved"End If

End Sub

Private Sub cmdSearch_Click()Dim IsExistRec As Boolean

IsExistRec = False

If DataStaffinfo.Recordset.RecordCount > 0 Then

DataStaffinfo.Recordset.MoveFirst

End If

Do While Not DataStaffinfo.Recordset.EOF

If LCase(cmbSearch.Text) = LCase(DataStaffinfo.Recordset(1).Value) Then


End If

DataStaffinfo.Recordset.MoveNext

Loop


Txtid.Text = DataStaffinfo.Recordset(0)Txtname.Text = DataStaffinfo.Recordset(1)


89/95

txtphoneno.Text = DataStaffinfo.Recordset(2)

Txtmailid.Text = DataStaffinfo.Recordset(3)

Cmbdestination.Text = DataStaffinfo.Recordset(4)txtaddress.Text = DataStaffinfo.Recordset(5)

Txtsalary.Text = DataStaffinfo.Recordset(6)

Else

MsgBox "Record not found"

End If

End Sub


rptStaffinfo.Show

End Sub

Private Sub txtaddress_KeyDown(KeyCode As Integer, Shift As Integer)


Txtsalary.SetFocusEnd If

End Sub

Private Sub Txtid_KeyDown(KeyCode As Integer, Shift As Integer)


Txtname.SetFocus

End IfEnd Sub

Private Sub Txtmailid_KeyDown(KeyCode As Integer, Shift As Integer)If KeyCode = 13 Then

Cmbdestination.SetFocus

End IfEnd Sub

Private Sub Txtname_KeyDown(KeyCode As Integer, Shift As Integer)

If KeyCode = 13 Thentxtphoneno.SetFocus

End If

End Sub


If (KeyAscii >= Asc("0") And KeyAscii


90/95

End Sub

Private Sub txtphoneno_KeyDown(KeyCode As Integer, Shift As Integer)If KeyCode = 13 Then

Txtmailid.SetFocus

End IfEnd Sub

Private Sub txtphoneno_KeyPress(KeyAscii As Integer)

If (KeyAscii >= Asc("A") And KeyAscii = Asc("a") And KeyAscii= Asc("A") And KeyAscii = Asc("a") And KeyAscii 0 Then

DataVisitorsinfo.Recordset.MoveFirstEnd If


91/95

cmbSearch.Clear

Do While Not DataVisitorsinfo.Recordset.EOF

cmbSearch.AddItem (DataVisitorsinfo.Recordset(1).Value)DataVisitorsinfo.Recordset.MoveNext

Loop

End SubPrivate Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)If KeyCode = 27 Then


Unload MeEnd If

End If

End SubPrivate Sub cmdDelete_Click()


If DataVisitorsinfo.Recordset.RecordCount = 0 ThenMsgBox "No record"

Else

DataVisitorsinfo.Recordset.MoveFirst

Do While Not DataVisitorsinfo.Recordset.EOFIf Txtid.Text = DataStaffinfo.Recordset(0).Value Then

DataVisitorsinfo.Recordset.Delete


End If

DataVisitorsinfo.Recordset.MoveNext

LoopEnd If

End If




Txtdate.Text = ""

cmbTiming.Text = ""



Txtid.Text = DataVisitorsinfo.Recordset.RecordCount + 1Txtname.Text = ""




92/95

Txtdate.Text = ""

cmbTiming.Text = ""


Private Sub cmdSave_Click()If Txtdate = "" ThenMsgBox ("Please enter the date")

ElseIf Txtname = "" Then

MsgBox ("Please enter the name ")ElseIf Txtpatientname = "" Then

MsgBox ("Please enter the patient name")

ElseIf txtphoneno = "" Then

MsgBox ("Please enter the phone number")ElseIf cmbTiming = "" Then

MsgBox ("Please enter the timings")

ElseIf Txtdate = "" ThenMsgBox ("Please enter the date ")

Else


IsExistRec = False

If DataVisitorsinfo.Recordset.RecordCount > 0 Then

DataVisitorsinfo.Recordset.MoveFirstEnd If

Do While Not DataVisitorsinfo.Recordset.EOF

If Txtid.Text = DataVisitorsinfo.Recordset(0).Value ThenIsExistRec = True

Exit Do

End IfDataVisitorsinfo.Recordset.MoveNext

Loop


DataVisitorsinfo.Recordset.Edit

Else

DataVisitorsinfo.Recordset.AddNewEnd If

DataVisitorsinfo.Recordset(0) = Txtid.Text

DataVisitorsinfo.Recordset(1) = Txtname.TextDataVisitorsinfo.Recordset(2) = Txtpatientname.Text

DataVisitorsinfo.Recordset(3) = txtaddress.Text

DataVisitorsinfo.Recordset(4) = txtphoneno.TextDataVisitorsinfo.Recordset(5) = Txtdate.Text


93/95


94/95


95/95

Private Sub txtphoneno_KeyDown(KeyCode As Integer, Shift As Integer)

If KeyCode = 13 Thentxtaddress.SetFocus

End If

End Sub

Private Sub txtphoneno_KeyPress(KeyAscii As Integer)

If (KeyAscii >= Asc("A") And KeyAscii = Asc("a") And KeyAscii

documentation patient

Documents