banking project report vb

8/6/2019 Banking Project Report VB

1/203

PREFACE

An element of good laboratory performance is the proper

functioning of laboratory equipment. The use of an instrument may be limited

by inadequate maintenance. All the major equipment in the laboratory should

have a maintenance programme. The more complex an instrument is, the more

the user will depend on the support of a supplier for its maintenance. It is therefore

pertinent to foresee the extent of costs that need to be included for the use and

maintenance of an instrument and to consider its lifespan as well as its workload.

The quality of laboratory test results depends on among other factors on the

performance of equipment. The proper functioning of equipment needs careful

operation and preventive maintenance. Early detection of malfunctions and

appropriate corrective measures will prevent unexpected costs, breakdown

of services, deterioration of quality and credibility of the laboratory. The purpose

of this manual is to address some of the fore mentioned issues and offer guidelines

for achieving greater levels of quality and functionality in selection, operation and

maintenance of laboratory equipment.

1


2/203

PROJECTON

LABORATORY REPORT

UNDERTAKEN AT

PTU LEARNING CENTRE, MALERKOTLA

UNDER THE GUIDANCE OFMAM RAJDEEP KAUR

SUBMITTED BY:

RAMANJEET KAUR RAJWINDER KAUR

(10204470152) (10204470151)

PARMINDER KAUR

(10204470146)

2


3/203

PROJECTON

LABORATORY REPORT

Undertaken at

PTU LEARNING CENTRE, MALERKOTLA

Under The Guidance OfMAM RAMANDEEP KAUR

SUBMITTED BY:


(10204470152) (10204470151)

PARMINDER KAUR

(10204470146)

MCA SEM 6th

3


4/203

ACKNOWLEDGEMENT

We like to take this opportunity to express our gratitude towards all the people

who in various ways have helped in successful completion of this project. At the

outset we like to

Thank PTU Study Center Malerkotla for giving us the opportunity and means to

undertake this study.

We like thank Mam. Ramandeep kaurfor his immense support and Guidance

without whose support making this project would not have been possible. We

would like thank all the faculty members of PTU Study Center Malerkotla for

adding value to our project. Last but not least we would like to thank all our

friends for their moral support.

Withsweet memories:


(10204470152) (10204470151)

PARMINDER KAUR

(10204470146)

MCA SEM 6th

4


5/203

DECLARATION

We swear that work being presented by us in dissertation title

LABORATORY TESTING for the partial requirement for the fulfillment of the

MCA (Information Technology) submitted to Punjab Technical University,

Jalandhar is an authentic record Of our work carried out by us in semester 6th of

the courseUnder the guidance ofMam. Ramandeep kaurof PTU Learning

Centre, Malerkotla

The matter is that we have not submitted dissertation

previously or any one else for the award of above said courseOr any other

course.


(10204470152) (10204470151)

PARMINDER KAUR

(10204470146)

5


6/203


7/203

CERTIFICATE

It is to certify that RAMANJEET KAUR, PARMINDER KAUR and

RAJWINDER KAUR submits the project entities LABORATORY

TESTING, for the fulfillment of the award of the degree of MCA is a

beneficed piece of the project work covered under my guidance and

supervision.

RAMANJEET KAUR, PARMINDER KAUR and

RAJWINDER KAUR is hard Working and sincere. I wish

them success in future Endeavors.

(CENTRE HEAD)

PTU LEARNING CENTRE

MALERKOTLA

7


8/203

REQUIRMENT:-

H/ W requirementsS/ W requirements

System requirements Specification

MS Access

1) Introduction to MS Access

2) Features of MS Access

VISUAL BASIC 6.0

1) Introduction to Visual Basic 6.02) Visual Basic Foundation3) Advantages of Visual Basic 6.04) Visual Basic as a shared language

8


9/203

HARDWARE REQUIRMENTS:-

Total number of machines : 1

Total disk capacity : 10GB

Total memory capacity : 128MB

Processor : P3 or above

SOFTWARE REQUIRMENTS:-

R.D.B.M.S : MS Access

PLATFORM : WINDOWS XP

G.U.I : VISUAL BASIC 6.0

9


10/203

Profile of Problems Assigned

1. Problem of Change and Rework:-Once the software is

delivered and deployed, it enters the maintenance

phase. All systems need maintenance, but for other

systems it is largely due to problems that are introduced

due to aging. Software needs to be maintained not

because some of its components wear out and need to

be replaced, but because there are often some residual

errors remaining in the system that must be removed as

they are discovered.Maintenance work is based on

existing software, as compared to development work

that creates new software. Consequently, maintenance

revolves around understanding existing software and

maintainers spend most of their time trying to

understand the software they have to modify.

Understanding the software involves understanding not

only the code but also the related documents. During

the modification of the software, the effects of the

change have to be clearly understood by the maintainer

because introducing undesired side effects in the

system during modification is easy.

10


11/203

2. Problem of Scale:-

A fundamental problem of project is

The problem of scale; development of a very large system

developing a small system. In other words, the methods

that are used for developing small systems generally do

not scale up to large systems.

Similarly, methods that one can

Use to develop programs of a few hundred lines cannot be

expected to work when software of a few hundred

thousand lines needs to be

Developed. A different set of methods have to be used for

developing large software. Any large project involves the

use of technology and project management. For software

projects, by technology we mean the methods,

procedures, and management can be used.

11


12/203

3. Problem of Consistency : -

Though high quality, low Cost and small cycle time are

the primary objectives of any project, for an organization

there is another goal: Consistency. An organization

involved in software development does not just want low

cost and high quality for a project, but it wants these

consistently. In other words, a software development

organization would like to produce consistent quality

with consistent productivity. Consistency of performance

is an important factor for any organization; it allows an

organization to predict the outcome of a project with

reasonable accuracy, and to improve its processes to

produce higher quality products and to improve its

productivity.Achieving consistency is an

important problem. That software engineering has to

tackle.

12


13/203

Feasibility Study

A feasibility study is a test of a system proposal

according to its workability, impact on the organization ability

to meet user needs and effective use of resources.

The objective of feasibility study is not to solve a problem but

to acquire a sense of its scope. During this study the problem

definition is crystallized and aspects of the problem are

determined. The result of the feasibility study is a formal

proposal. The proposal consists what is known and what is

going to be done. It consists of following:

1. Statement of the problem.2. Summary of findings and recommendations.3. Details of findings.4. Recommendations and conclusions.

After management reviews the proposal, it becomes a

formal agreement that paves the way for actual designs and

implementations. This is a crucial decision point in the life

cycle.

.

13


14/203

Behavioral Feasibility:-

In first solution, if the supervisor will be employed from outside

then the morale of the existing account officers will be hurt and they will be de-

motivated. But if two employees or Junior Officers in account are promoted then also

others will be de-motivated because there is no scope of promotion in the near future.

But in the second solution, the account in-charge can supervise Junior Officers in all the

manners from account creation to management and to closing and keep record of

transaction in the computer also. Moreover, his hectic job will be eased by a computer

and he can supervise well.

Acceptance Criteria:-

The accountant finally approved all

granted lists and data.

FEASIBILITY ANALYSIS

Feasibility analyses are used to

present an approach or a series of alternatives and to offer decision-making guidance

based on the climate in which the project will evolve. They often defend a single or

primary approach, incorporating Extensive forecasts on the projects development, as

well as its evolution after implementation. Because a feasibility analysis may focus on

one or many aspects of a project, it may be a very short (One- to two-page) or long

14


15/203

(multivolume) document. In any case, it generally begins with an executive summary

and a description of the project outputs in their as-built condition.

1. PROJECT PLAN

Team Structure: RAMANJEET KAUR, PARMINDER KAUR and

RAJWINDER KAUR a student ofPTU Learning Center

Malerkotla ofMCA 6thSEM.

My project subject is LABORATORY TESTING. This project is

prepared & the information about this project is collected by us. But

some time some problems are faced by us when we do collections of the

materials for this project. But my teacher is also helping us in this

project. At last now this project is complete, and this project is making in

Visual Basic (programming language).

Development Schedule:-

This goal of schedule Estimation is to determine the total duration of

the project and the duration of the different phases. This schedule will

be used to monitor the progress of the project.

15


16/203

Introduction of Visual Basic: - Visual basic environment is a

Platform provided by visual basic to develop and execute a project.

The environment consists of different project templates, control tools

and various other options. A project is a collection of files that you

used to build an application.

There are some features of VISUAL BASIC 6.0, which makes it

perfect development environment. There are :

Full set of object

Lots of icons and pictures for your use

Response to mouse and keyboard action

Full array of mathematical, string handling and graphical functions

Useful debugger and error handling facilitys Active X support Package and Developed Wizard makes distributing your

applications simple.

Visual Basic is an Event Driven Programming Language:

The Visual part refers to the methods used to create the graphical

user interface (GUI). The Basic part refers to the basic language that

is used by most of the programmers in the history of computing. The

visual basic programming language is not unique to visual basic. The

visual basic programming system, applications addition

Included in Microsoft excel, Microsoft access and many other window

applications use the same language.

16


17/203

INTRODUCTION OF LABORATORY TESTING

LABORATORY TESTING is often provided instaneously on

computer printout that can be directly recorded in computerized

patient records. But how well do physicians use significant

laboratory data that have been so expertly and efficiently stored

in cyberspace? Do abundant computer printout actually facilitate

improvement of patient care, or do they add to the attending

physicians already.

The laboratory may provide the first clues

to a major disease process. This are within the laboratory where

your blood, urine and biochemistry. Take to wonder through the

variousdepartment of the laboratory. For the introduction, to

the clinical laboratory, check out this guide.

17


18/203

OBJECTIVES OF PROJECT

In our project on LABORATORY TESTING, we have tried

to produce every information through FORMS, REPORTS. In

forms , we have tried to produce every instruction by using some

of the controls such as: -Text Boxes, Label Buttons ,

CommandButtons, Radio Buttons and Frame .All these are

as follows: -

LABEL BUTTON: -Label controls to act as caption, display

information to the user, labels are similar to text boxes, exception

that the user cant edit the information presented in them.

TEXT BOXES: -Text box controls to accept textual information

needed from the user, and to display certain information backs

to the user, a text box is called Edit Control that means the

user can edit the information presented in them.

Command Button: -Command button is also referred as a

Push Button. Command button controls, is used to initiate an

action and the text on the button initiates the action associated

18


19/203

with the button. The code for this action to be performed by the

programmer.

FRAME: -The frame control is a special type of control

called a Container. Containers are control in which the user

can draw another controls, much like a real picture frame. This

feature is useful for creating multiple pages of controls on a

single form

OPTION BUTTON:- Option buttons provide a way for a

user to select one of many options on a form.Option buttons,

we must select only one among several. This is used to help any

one item from many items.

19


20/203

Microsoft Access Description

Microsoft Access is a powerful program to create and manage your databases. It

has many built in features to assist you in constructing and viewing your

information. Access is much more involved and is a more genuine database

application than other programs such as Microsoft Works.

This tutorial will help you get started with Microsoft Access and may solve some

of your problems, but it is a very good idea to use the Help Files that come with

Microsoft Access, or go to Microsoft's web site located at First of all you need to

understand how Microsoft Access breaks down a database. Some keywords

involved in this process are: Database File, Table, Record, Field, data-type. Here

is the Hierarchy that Microsoft Access uses in breaking down a database.

This tutorial will help you get started with Microsoft Access and may solve some

of your problems, but it is a very good idea to use the Help Files that come with

Microsoft Access (or any program you use for that matter.

Starting Microsoft Access

20


21/203

Two Ways

Double click on the Microsoft Access icon on the desktop.

1. Click on Start --> Programs --> Microsoft Access

Tables

A table is a collection of data about a specific topic, such as students or contacts. Using

a separate table for each topic means that you store that data only once, which makes

your database more efficient, and reduces data-entry errors.

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

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

Primary Key:

One or more fields (columns) whose value or values uniquely identify each

record in a table. A primary key does not allow Null values and must always have

a unique value. A primary key is used to relate a table to foreign keys in other

tables.

o After you do this, Save the table

21


22/203

Manipulating Data:

Adding a new row

o Simply drop down to a new line and enter the information

Updating a record

o Simply select the record and field you want to update, and change its data

with what you want

Deleting a record

Simply select the entire row and hit the Delete Key on the keyboard

22


23/203

Software Requirements Specification

System Overview:This system is developed to automate the

existing manual system, so that the response time, access time, and

process time will be reduced. Accuracy is another important factor

behind the development of this system. The system will be reliable to

different platforms. Flexibility is most important of this system. The

system will be very efficient in case of performance. It will have the

ability to analyze the results quickly and to answer queries quickly.

To operate this system the effort required is very low. Another

important feature of this system is that it prompts error messages in

case of invalid information entry to help the user. Well maintained

forms to improve the readability of information are used.

Functional Requirements:

The functional requirements of the system should clearly describe

each function which the system would support along with the

corresponding input and output data set. Different functional

requirements of the system are:

23


24/203

Performance Requirements:

Performance Requirements deal with

the characteristics such as maintainability, portability, usability,

reliability issues, accuracy of results etc. The response time,

processing time, throughput etc. can also be included in the

performance requirements.

PortabilityThe proposed system will be developed in

order to get higher portability. The developed system can be

run on any type of platform. There no limitation for running the

software due to the change of platform.

a) Maintainability

Maintainability is another important

aspect of the proposed system. The proposed system could

be easily maintained. The system can also be easily modified.

b) Response Time

The response time of our developed

system is also very short. The time amount from giving the command to start

processing is very small.

Processing Time

Processing time for each process is very small.

Every process takes only small unit of time amount required for the entire system.

24


25/203

IMPLEMENTATION

Planning is the first step in implementing a new LIMS, and the

first step in this process is to evaluate the laboratory's

information resource needs. If there is already a LIMS, how

does it operate? How does it interface with other business and

quality systems? What works well, and what weaknesses are

observed? Users, including analysts, clients, and managers, need

to be involved from the beginning. They are the people who will

have the best perspective on how the new system should work.

Additionally, early involvement can help build user acceptance

of the change. Resistance to change may be the biggest cause of

failure in implementing a new system. The planning stage

provides an opportunity to anticipate problems and educate the

users on the project (7). In the early stages of implementing our

minicomputer-based system in 1990, inadequate input from the

end users resulted in a system that could not support tests with

more than one analyze or with numerical results-features

necessary for the operations in our laboratory. Major

modifications were needed, delaying the launch of the system.

While planning for our environmental LIMS, we met with

representatives of our largest client, the state drinking water

program.

25


26/203

We examined problems with the current system, such as

transcription errors; looked at desirable new features, such as

interfacing with regulatory databases; and kept the

representatives informed with regular progress reports. A

corollary benefit was that they championed the project.

Management commitment is an absolute requirement.

Managers need to clearly delineate the goals to be obtained by

implementing the LIMS; communicate that the change is

desirable; encourage cooperation and coordination among the

users, clients, and system implementers; and ensure that

adequate financial and staff resources are available to

implement the system. The project will fail without these

commitments from the laboratory manager.

26


27/203

Feasibility study

A Feasibility Study Report is a business plan for a specific project. It provides

the rationale and the support for that rationale to pursue a specific project from the

feasibility phase, pre-construction, construction and occupancy through investment and

technical management. The objectives of a feasibility study is to find out whether an

information system project can be done (...is it possible? is it justified?) and to

suggest possible alternative solutions. A feasibility study should provide management

with enough information to decide:

a) Whether the project can be done.

b) Whether the final product will benefit its intended users

c) What are the alternatives among which a solution will be chosen

d) Whether there exists a preferred alternative

A feasibility report is dynamic integration of financial investment, technical data,

HR considerations and thorough output with return on investment (ROI) consideration in

the project. It should be as dynamic as possible to incorporate any change to

assumptions or to incorporate new information. As a result, all assumptions made and

specified in the Feasibility Study are meticulously documented. The report is prepared

in close consultation with our client (in addition to an architect, construction consultant

and others) since some of the work included in the report most likely has already been

completed by the client.

Despite the critical importance of a business plan, many Entrepreneurs and companies

procrastinate when it comes to preparing a written business plan document. They argue

that they know their project and they have done their homework. Some also feel thattheir marketplace changes too fast for a feasibility plan to be useful or that they just do

not have enough time. However, Entrepreneurs and Investors should not rush into new

investments without a plan or a Feasibility Report.

27


28/203

A basic knowledge of clinical laboratory procedures is critical for all Hospital

Corpsmen, particularly those working at small dispensaries and isolated duty stations

without the supervision of a medical officer. A patients complaint maybe of little value

by itself, but coupled with the findings of a few easily completed laboratory studies, a

diagnosis can usually be surmised and treatment initiated. Hospital Corpsmen who can

perform blood and urine tests and interpret the results are better equipped to determine

the cause of illness or request assistance. Since they can provide a more complete

clinical picture to the medical officer, their patients can be treated sooner. In this

chapter, we will discuss laboratory administrative responsibilities, ethics in the

laboratory, the microscope, blood collection techniques, and step-by-step procedures

for a complete blood count and urinalysis.

The main functions are:

I. Haematoogical

II. Urine analysis

III. Immunological

IV. Biochemical

V. Stool examinationVI. Microbiology

VII. Semenolysis

VIII. cytology

28


29/203

Technical feasibility

Required instruments

I. Photometer 5010- mainly for kidney function test and liver function test.

II. Electrolyte Analyzer 9180(a,k,Cl)test i.e biomedical test

III. Cell counter(haematology)- blood analyzer i.e TC,DC, Hb%

IV. BIO RAD-icromat- (glycocylated Hb) for Diabetes

V. Centrifuge achine- For temperature maintaining

VI. Microscope- For magnifying blood cell, urine, sputum etc.

VII. ESR achine-To measure electrolyte sedimentation rate

VIII. Incubator- For temperature maintaining

IX. Water bath

X. Test tubes

XI. Glass slides

XII. Cover slips

XIII. Test tube rack and holder

XIV. Capillary tube

XV. Tissue papers

And different types of reagents:Haematology reagents:

I. N/10 HC Acid

II. Sodium citrate

III. Leisman stain

IV. RBC Diluting fluid

V. WBC diluting fluid

VI. Platelets diluting fluid

VII. Semen diluting fluid

VIII. Carbofusion

IX. Athylene blue

X. Acetone. Benedict reagent

29


30/203

XI. Forcet reagent

XII. Sulphocylic acid

XIII. Crystal viole

XIV. Gemsa stain

Biochemical reagents:

I. Glucose

II. Urea

III. Creatinine

IV. Total protein, albumin, globulin

V. SGOT(AST)

VI. SGPT(AT)

VII. Alk. Phosphatase

VIII. Amylase

IX. Uric acid

X. HBA lc(glycylated Hb)

XI. Triglyceride

XII. Calcium

XIII. troponin

Behavioral Feasibility:-

In first solution, if the supervisor will be employed from outside

then the morale of the existing account officers will be hurt and they will be de-

motivated. But if two employees or Junior Officers in account are promoted then also

others will be de-motivated because there is no scope of promotion in the near future.

But in the second solution, the account in-charge can supervise Junior Officers in all the

manners from account creation to management and to closing and keep record of

transaction in the computer also. Moreover, his hectic job will be eased by a computer

and he can supervise well.

30


31/203


32/203

FEASIBILITY ANALYSIS

Feasibility analyses are used to

present an approach or a series of alternatives and to offer decision-making guidance

based on the climate in which the project will evolve. They often defend a single or

primary approach, incorporating Extensive forecasts on the projects development, as

well as its evolution after implementation. Because a feasibility analysis may focus on

one or many aspects of a project, it may be a very short (One- to two-page) or long

(multivolume) document. In any case, it generally begins with an executive summary

and a description of the project outputs in their as-built condition.

Information Gathering Tools

The tools which were used for gathering the information are as follows :

a. Interviews

b. On-site Observation

1. Interviews:

The interview is the oldest and most often used device for gathering information in

systems work. The interview is a face-to-face interpersonal role situation in which a

person called interviewer asks a person being interviewed questions designed

together information about a problem area. It can be used for two main purposes:-

(a) As an exploratory device to identify relations or verify information.

(b) To capture information as it exists.

32


33/203

Advantages of Interviews: -

Its flexibility makes the interview a

superior technique for exploring areas where not much is known about

what questions to ask or how to formulate questions.

It offers a better opportunity than the

questionnaire to evaluate the validity of the information gathered.

It is an effective technique for eliciting

information about complex subjects & for probing the sentiments

underlying expressed opinions.

Many people enjoy being interviewed,

regardless of the subject. They usually cooperate in a study when all they

have to do is talk.

33


34/203

2. On-site Observation: -

It is the process of recognizing and noting people, objects and occurrences to

obtain information. The analysts role is that of an information seeker whoexpected to be detached (therefore unbiased) from the system beingobserved. The role permits participation with the user staff openly and freely.The major objective of on-site observation is to get as close as possible to thereal system being studied. For this reason it is important that the analyst isknowledgeable about the general make-up and activities of the system.

The following questions can serve as a guide for on-site observation:-

a. What kind of system is it? What does it do?b. Who runs the system? Who are the important people in it?

c. What is the history of the system? How did it get to its present stage of

development?

Apart from its formal function what kind of system is it in comparison

with other systems in the organization? Is it a primary or a secondary

contributor to the organization? Is it fast paced or is it a leisurely system

that responds slowly to external crises?

The above given tools were used as a source of information gathering for this

project. The interview was conducted of the users & the problems of the existing

system were noted to remove them from the new system. And the on-site

observation of the companys existing system was done. These two tools were of

great usefulness through out the analysis stage.

34


35/203

DFD for Login Form

Click ok Main form

35

Login

Enter the

name andpassword


36/203

DFD For Main Form

Patient form

Select button

Select any test form

Open data

Searching and removing data

36

Choice


37/203

Data Flow Diagram

DFD For Patient

Patient Database

Patient Detail

Tests

Item Database

Result

Test data base

37

Process

Tests


38/203

DFD for adding a new patientform

Update Patient Database

38

Adding

new

Patient


39/203

DFD For Adding New UrineReport


39

Adding

newPatient


40/203

DFD For Adding New

Haemotology Reports

Update

Patient Database

40

Addingnew

Patient


41/203

DFD For Adding NewBiochemistry Report


41

Addingnew

Patient


42/203

DFD For Adding New SputumReport


42

Adding

newPatient


43/203

43


44/203

DFD For Searching or

Removing Data

Open theData base

Delete the data base

44

Open anddelete the

data


45/203

MAINTENANCE

Make a request from the manufacturer/local agent to provide staff

training in preventive maintenance and handling of trouble shooting. The

local agent should provide immediate remedy to overcome a sudden break

downof equipment. Study the manufacturers guarantee with regards to the

period, spare parts, repair and replacement. Any equipment faults due to

manufacturing process should be replaced during the warranty period.

Study the hidden terms and conditions laid down by the local agent regarding

maintenance. A service agreement should be established at the end of the

warranty period. The local agent should specify the services in detail that

will be offered during the service contract.

45


46/203

CONCLUSION AND REFERENCES

Conscientious physicians invest tremendous effort

keeping up with professional literature and medical developments.

Computerized system have an advantage over humans in

that they never forget, never get tried, and make no mistakes

if they are correctly programmed. It can be implemented inany active clinical unit providing that the information data

system is used concurrently in routine clinical practice.

the long run, this simple technique may save patients. In the

long run, this technique may save patients lives.

FOOTNOTE

With the help of my teacher and friends we are made the

project.

REFERENCED

My teacher guidness, book.

46


47/203

LOGIN FORM

In this form we have taken the user name and password in the text boxes. We use

the label button and text boxes in this form. Only those persons can login who knows

the exact password. Other it is not of anyone. We have used the two command buttons

in this form that are ok and exit.

OK:-

Ok button is used to open the main form. When we click on ok button then main

form will appear.

Exit:-

Exit button is used to exit from the project and the log in form.

47


48/203

MAIN FORM

In this form we have taken the command buttons which are used to open the other

forms by just clicking on them. We have use the command buttons are lab

management, patient form, urine report, biochemistry, serology, semen, stool, liver

function test, widal test, haemotology, sputum, heart test, culture report, charge list,

chemical and searching and removing. On clicking the any command buttons the form

displayed correspondingly. We used the frame for command buttons.

48


49/203

LAB MANAGEMENT :-

This form is used toopen a lab management form in the laboratory. We haveTaken the fields are haemotology report, serology report , stool report , urine report ,

semen report , biochemistery report , liver function test , sputum report , widal test and

heart test in the labels and data give in the combo boxes. Multiple items show in the

combo boxes and these items are saved in the tables. We have used three command

buttons save, refresh, exit in this form.

Save:-

Save button is used to save the record in the data base tables.

Refresh:-

Refresh button is used to refresh the data record for saving the new data in thedata base tables.

Exit :-

49


50/203

PATIENT FORM:-

This form is used toopen patient form a form in the laboratory. We have

Taken the fields are patient no, name, age, dated, sex, refdoctor in the

Labels and data give in the text boxes and combo boxes. Patient no and name give

Text boxes and these items are saved in the tables. We have used three command

buttons save, refresh, exit in this form.

Save:-


Refresh:-


Exit :-

50


51/203

URINE REPORT

This form is used toopen a urine report form in the laboratory. We haveTaken the fields are patient no, name, appearance, colour, reaction, sugar, pus cell,

Casts, albumin, red blood cell, epithelial, crystals, amor. Urates, trichomonas in the


In text boxes and other data items is also used in the combo boxes. Multiple items show

In the combo boxes and these items are saved in the tables. We have used three

command buttons save, refresh, exit in this form.

Save:-


Refresh:-


Exit :-

Exit button is used to go back on the main form.

51


52/203

HAEMOTOLOGY REPORT

This form is used toopen a haemotology report form in the laboratory. We have

Taken the fields are patient no, name,haemoglobin, platelet count, clotting time, tlc, dlc,

red cell count blood group, reticulocytes, neutrophills, lymphocytes, monocytes, esr in

the Labels and data give in the text boxes and combo boxes. Patient no and name give




Save:-


Refresh:-


Exit :-


52


53/203

SEROLOGY REPORT

This form is used toopen a serology report form in the laboratory. We have

Taken the fields are patient no, name, pregnancy, anti-hcv, kahn, vdrl, r a factor, c r

protein, aso titre, hiv-test, toxoplasmosis, hbsaghepatitisb, spforafb, mantouxtest in the





Save:-


Refresh:-


Exit :-


53


54/203

BIOCHEMISTRY REPORT

This form is used toopen a biochemistry report form in the laboratory. We have

Taken the fields are patient no, name, blood sugar, blood urea , sodium, potassium,

calcium, r b sugar, magnesium, phosphorus, s uric acid, screatinine, s chloride,

creatinine, acid phosp in the Labels and data give in the text boxes and combo boxes.

Patient no and name give in text boxes and other data items is also used in the combo

boxes. Multiple items show in the combo boxes and these items are saved in the tables.

We have used three command buttons save, refresh, exit in this form.

Save:-


Refresh:-


Exit :-


54


55/203

STOOL REPORT

This form is used toopen a stool report form in the laboratory. We have

Taken the fields are patient no, name, colour, consistency, red blood cell, starch cell,

blood, pus cell, cysts. Mucus, occult blood, starch fibres, stool for ph, reducing

substances in the Labels and data give in the text boxes and combo boxes. Patient no

and name give in text boxes and other data items is also used in the combo boxes.

Multiple items show in the combo boxes and these items are saved in the tables. We

have used three command buttons save, refresh, exit in this form.

Save:-


Refresh:-


Exit :-


55


56/203

SEMEN REPORT

This form is used toopen a semen report form in the laboratory. We have

Taken the fields are patient no, name, colour, Count, dead, volume, active motile ,

sluggish motile, viscocity, pus cell, r b c, liquefaction, morphology, motility in the

Labels and data give in the text boxes and combo boxes. Patient no and name give in

text boxes and other data items is also used in the combo boxes. Multiple items show in

the combo boxes and these items are saved in the tables. We have used three


Save:-


Refresh:-


Exit :-


56


57/203

SPUTUM REPORT

This form is used toopen a sputum report form in the laboratory. We have

Taken the fields are patient no, name, type of suspect/desease (pulmonary, extra

pulmonary), reason for examination (diagnosis, repeat examination and for

examination) . We have used the frames and option buttons for the sputum report.

Option button provided a selected item from many choices .We sed the text boxes for

patient no and name and these items are saved in the tables. We have used three


Save:-


Refresh:-


Exit :-


57


58/203


59/203

WIDAL REPORT

This form is used toopen a widal report form in the laboratory. We have

Taken the fields are patient no, name, s typhi o,s typh h, s paratyphi ah, s paratyphi bh

in the labels and data give in the text boxes and combo boxes. Patient no and name

give in text boxes and other data items is also used in the combo boxes. Multiple items

show in the combo boxes and these items are saved in the tables. We have used three


Save:-


Refresh:-


Exit :-


59


60/203

HEART TEST

This form is used toopen a heart test (lipids profile) form in the laboratory.

We have taken the fields are patient no, name, scholesterol, ldlcholesterol, totallipids,

totalhdlratio, hdlcholesterol, triglycerides , lithium, lipase, tibc, iron, cpk- nac, cpk-mb in

the labels and data give in the text boxes and combo boxes. Patient no and name give

in text boxes and other data items is also used in the combo boxes. Multiple items show

in the combo boxes and these items are saved in the tables. We have used three


Save:-


Refresh:-


Exit :-


60


61/203

CULTURE REPORT

This form is used toopen a culture report form in the laboratory. We have

Taken the fields are patient no, name, specimen (semen, urine, stool, blood, sputum),

medicines in the Labels and data give in the text boxes and combo boxes. Patient no

and name give in text boxes and other data items is also used in the combo boxes.

Multiple items show in the combo boxes and these items are saved in the tables. We

have used three command buttons save, refresh, exit in this form.

Save:-


Refresh:-


Exit :-


61


62/203

CHARGE LIST

This form is used toopen a charge list form in the laboratory. We have

Taken the fields are haemoglobin, stool report, pregnancy report, platelet count, blood

urea, semen report, sodium, hiv test , widal test, calcium, potassium, s uric acid , s

chloride, lipids profile , urine report. We used the message box for show the charges of

any test.When we click any command button and message box appear on the screen.

We have used three command buttons save, refresh, exit in this form.

Save:-


Refresh:-


Exit :-


62


63/203

CHEMICAL REPORT

This form is used toopen a chemical report form in the laboratory. We have

Taken the fields are sugar, potassium, calcium, haemoglobin, uric acid, sodium, aso

test, triglycrides, c r protein in the labels and data give in the text boxes and these are

saved in the tables. We have used three command buttons save, refresh, exit in this

form.

Save:-


Refresh:-


Exit :-


63


64/203

SEARCHING AND REMOVING

This form is used toopen a searching and removing form in the laboratory.

We have taken the fields are haemotology report, serology report, biochemistry report

and urine report in the command buttons. When we click on any command button and

another form will appear.This form is used to open and delete the data record. We have

used three command buttons save, refresh, exit in this form.

Save:-


Refresh:-


Exit :-


64


65/203

HAEMOTOLOGY

This form is used toopen a haemotology report form in the laboratory.

We have taken the fields are patient no, name, haemoglobin, platelet count, blood

group, red cell count, clotting time, e s r in the labels and data give in the text boxes

and combo boxes. Patient no and name give in text boxes and other data items is also

used in the combo boxes. Multiple items show in the combo boxes and these items are

saved in the tables. We have used three command buttons open, delete, refresh, exit

in this form.

Open:-

Open button is used to open the record in the data base tables.

Delete:-

Delete button is used delete the record which is not useful for us.

Refresh:-

Refresh button is used to refresh the data record for saving the new data in the

data base tables.

Exit :-


65


66/203

SEROLOGY

This form is used toopen a serology report form in the laboratory. We have

taken the fields are patient no, name, c r protein, aso titre, r a factor, hiv test, antihcv,

vdrl in the labels and data give in the text boxes and combo boxes. Patient no and

name give in text boxes and other data items is also used in the combo boxes. Multiple

items show in the combo boxes and these items are saved in the tables. We have used

three command buttons open, delete, refresh, exit in this form.

Open:-


Delete:-


Refresh:-


Exit :-


66


67/203

BIOCHEMISTRY

This form is used toopen a biochemistry report form in the laboratory.

We have taken the fields are patient no, name, blood sugar, blood urea, calcium,

sodium, potassium, magnesium in the labels and data give in the text boxes and

combo boxes. Patient no and name give in text boxes and other data items is also used

in the combo boxes. Multiple items show in the combo boxes and these items are saved

in the tables. We have used three command buttons open, delete, refresh, exit in this

form.

Open:-


Delete:-


Refresh:-

Refresh button is used to refresh the data record for saving the new data in the

data base tables.

Exit :-


67


68/203

URINE

This form is used toopen a urine report form in the laboratory. We have taken

the fields are patient no, name, appearance, colour, albumin, casts, puss cell, sugar in

the labels and data give in the text boxes and combo boxes. Patient no and name give

in text boxes and other data items is also used in the combo boxes. Multiple items show

in the combo boxes and these items are saved in the tables. We have used three

command buttons open, delete, refresh, exit in this form.

Open:-


Delete:-


Refresh:-


Exit :-


68


69/203

69


70/203


71/203

71


72/203

72


73/203

73


74/203

74


75/203

75


76/203

76


77/203

77


78/203

78


79/203

79


80/203

80


81/203

81


82/203

82


83/203

83


84/203

84


85/203

85


86/203

86


87/203

87


88/203

88


89/203

89


90/203

90


91/203

91


92/203

92


93/203

93


94/203

94


95/203

95


96/203

96


97/203

97


98/203

98


99/203

99


100/203

100


101/203

101


102/203

102


103/203

103


104/203

104


105/203

105


106/203

106


107/203

107


108/203

108


109/203

109


110/203

110


111/203

111


112/203

112


113/203

113


114/203

LOGIN FORM

Dim cnn As ADODB.ConnectionDim rss As ADODB.Recordset

Private Sub ok_Click()

If uname.Text = "raj" And upass.Text = "123" Thenma.Show

Else

MsgBox (wrongusername Or password)

End If

End Sub

114


115/203

MAIN FORM

Private Sub br_Click()

bio.ShowEnd Sub

Private Sub ch_Click()

cha.ShowEnd Sub

Private Sub SE_Click()

sear.ShowEnd Sub

Private Sub cr_Click()

che.Show

End Sub

Private Sub cu_Click()

CUL.Show

End Sub

Private Sub hr_Click()

hae.ShowEnd Sub

Private Sub ht_Click()lipi.Show

End Sub

Private Sub lfu_Click()lft.Show

End Sub

Private Sub lm_Click()

man.Show

End Sub

Private Sub paf_Click()

PAN.Show

End Sub

115


116/203

Private Sub semr_Click()

SEM.ShowEnd Sub

Private Sub spr_Click()SPU.Show

End Sub

Private Sub SR_Click()

sero.Show

End Sub

Private Sub str_Click()

STO.Show

End Sub

Private Sub UR_Click()

uri.ShowEnd Sub

Private Sub wd_Click()

WID.ShowEnd Sub

116


117/203

LAB MANAGEMENT

Dim cnn As ADODB.Connection

Dim rss As ADODB.Recordset

Private Sub EX_Click()

MA.ShowUnload Me

End Sub

Private Sub Form_Load()

HR.AddItem ("on the front")

HR.AddItem ("in the bathroom")

HR.AddItem ("in different room")

UR.AddItem ("in the bathroom")UR.AddItem ("anywhere in the lab")

UR.AddItem ("in different room")

SR.AddItem ("anywhere in the lab")SR.AddItem ("in the bathroom")

SR.AddItem ("in different room")

SER.AddItem ("in the bathroom")

SER.AddItem ("anywhere in the lab")

SER.AddItem ("in different room")

STR.AddItem ("in the bathroom")STR.AddItem ("anywhere in the lab")

STR.AddItem ("in different room")

BR.AddItem ("anywhere in the lab")BR.AddItem ("in the bathroom")

BR.AddItem ("in different room")

LIF.AddItem ("anywhere in the lab")

LIF.AddItem ("in the bathroom")

LIF.AddItem ("in different room")

SPU.AddItem ("in the lab")

SPU.AddItem ("in the bathroom")

SPU.AddItem ("in different room")

117


118/203

WID.AddItem ("anywhere in the lab")

WID.AddItem ("in the bathroom")WID.AddItem ("in different room")

HRT.AddItem ("anywhere in the lab")HRT.AddItem ("in the bathroom")

HRT.AddItem ("in different room")

CUL.AddItem ("anywhere in the lab")

CUL.AddItem ("in the bathroom")

CUL.AddItem ("in different room")

Set cnn = New ADODB.Connection

Set rss = New ADODB.Recordset

cnn.Provider = "microsoft.jet.oledb.4.0"

cnn.Open "D:\raj\LAB.mdb"rss.Open "manm", cnn, adOpenDynamic, adLockOptimistic, adCmdTable

End Sub

Private Sub REF_Click()

HR.Text = " "

UR.Text = " "SR.Text = " "

SER.Text = " "

STR.Text = " "BR.Text = " "

LIF.Text = " "

SPU.Text = " "WID.Text = " "

HRT.Text = " "

CUL.Text = " "HR.SetFocus

End Sub

Private Sub SA_Click()rss.AddNew

rss!haematologyreport = HR.Text

rss!urinereport = UR.Textrss!semenreport = SR.Text

rss!serologyreport = SER.Text

rss!stoolreport = STR.Textrss!biochemistryreport = BR.Text

rss!livertest = LIF.Text

rss!sputumreport = SPU.Text

rss!widaltest = WID.Text

118


119/203

rss!hearttest = HRT.Text

rss!culture = CUL.Text

rss.UpdateMsgBox ("recordsaved")

End Sub

PATIENT FORM

119


120/203




MA.Show

Unload MeEnd Sub



Set rss = New ADODB.Recordsetcnn.Provider = "microsoft.jet.oledb.4.0"

cnn.Open "D:\raj\LAB.mdb"

rss.Open "pati1", cnn, adOpenDynamic, adLockOptimistic, adCmdTable

End Sub

Private Sub REF_Click()PAN.Text = " "

NA.Text = " "

AG.Text = " "

DAT.Text = " "RE.Text = " "

SE.Text = " "

PAN.SetFocusEnd Sub

Private Sub SA_Click()rss.AddNew

rss!patientno = PAN.Text

rss!Name = NA.Textrss!age = AG.Text

rss!dated = DAT.Text

rss!refdoctor = RE.Text

rss!sex = SE.Textrss.Save

MsgBox ("recordsaved")

End Sub

120


121/203

URINE REPORT




MA.ShowUnload Me

End Sub

Private Sub Form_Load()AP.AddItem ("clear")

AP.AddItem ("turbid")

AP.AddItem ("semiturbid")

RE.AddItem ("acidic")

RE.AddItem ("alcoline")

SU.AddItem ("nill")

SU.AddItem ("0.5%")

SU.AddItem ("0.6%")SU.AddItem ("0.7%")

SU.AddItem ("0.8%")


SU.AddItem ("1.1%")


SU.AddItem ("1.4%")


SU.AddItem ("1.7%")

SU.AddItem ("1.8%")


CO.AddItem ("paleyellow")CO.AddItem ("yellow")

CO.AddItem ("deepyellow")

AL.AddItem ("nill")

AL.AddItem ("0.5%")

AL.AddItem ("0.6%")

AL.AddItem ("0.7%")

121


122/203

AL.AddItem ("0.8%")

AL.AddItem ("0.9%")

AL.AddItem ("1.0%")AL.AddItem ("1.1%")

AL.AddItem ("1.2%")


AL.AddItem ("1.5%")


AL.AddItem ("1.8%")

AL.AddItem ("1.9%")

AL.AddItem ("2.0%")

CA.AddItem ("puscell")

CA.AddItem ("redbloodcell")

CA.AddItem ("epithelialcell")

PUC.AddItem ("occasional")PUC.AddItem ("rear")

PUC.AddItem ("2-4")

PUC.AddItem ("4-6")

PUC.AddItem ("6-8")PUC.AddItem ("8-10")

PUC.AddItem ("10-12")







PUC.AddItem ("above")

RBC.AddItem ("occasional")

RBC.AddItem ("rear")

RBC.AddItem ("2-4")RBC.AddItem ("4-6")

RBC.AddItem ("6-8")


RBC.AddItem ("12-14")



122


123/203





RBC.AddItem ("28-30")RBC.AddItem ("above")

EPI.AddItem ("occasional")EPI.AddItem ("rear")

EPI.AddItem ("2-4")

EPI.AddItem ("4-6")

EPI.AddItem ("6-8")EPI.AddItem ("8-10")

EPI.AddItem ("10-12")







EPI.AddItem ("above")

CRYS.AddItem ("calcium")

CRYS.AddItem ("oxalate")

CRYS.AddItem ("uricacid")CRYS.AddItem ("2-4")

CRYS.AddItem ("4-6")

CRYS.AddItem ("6-8")CRYS.AddItem ("8-10")

CRYS.AddItem ("above")

CRYS.AddItem ("+")

CRYS.AddItem ("++")CRYS.AddItem ("+++")

CRYS.AddItem ("++++")

CRYS.AddItem ("above")

AMO.AddItem ("+")

AMO.AddItem ("++")AMO.AddItem ("+++")

AMO.AddItem ("++++")

AMO.AddItem ("above")

123


124/203

TRI.AddItem ("+")

TRI.AddItem ("++")

TRI.AddItem ("+++")TRI.AddItem ("++++")

TRI.AddItem ("above")

Set cnn = New ADODB.ConnectionSet rss = New ADODB.Recordset



rss.Open "uri", cnn, adOpenDynamic, adLockOptimistic, adCmdTableEnd Sub


PA.Text = " "NA.Text = " "

AP.Text = " "CO.Text = " "

RE.Text = " "

AL.Text = " "

SU.Text = " "CA.Text = " "

PUC.Text = " "

RBC.Text = " "EPI.Text = " "

CRYS.Text = " "

AMO.Text = " "TRI.Text = " "

PA.SetFocus

End Sub

Private Sub SA_Click()

rss.AddNew

rss!patientno = PA.Textrss!Name = NA.Text

rss!Appearance = AP.Text

rss!colour = CO.Textrss!reaction = RE.Text

rss!albumin = AL.Text

rss!sugar = SU.Textrss!casts = CA.Text

rss!puscell = PUC.Text

rss!redbloodcell = RBC.Text

rss!epithelialcell = EPI.Text

124


125/203

rss!crystals = CRYS.Text

rss!amorurates = AMO.Text

rss!trichomonas = TRI.Textrss.Save


End Sub

125


126/203

HAEMOTOLOGY REPORT




MA.Show

Unload MeEnd Sub


HA.AddItem ("11gms")HA.AddItem ("12mgs")

HA.AddItem ("13mgs")

HA.AddItem ("14gms")

HA.AddItem ("15mgs")HA.AddItem ("16mgs")

HA.AddItem ("17gms")HA.AddItem ("18mgs")

HA.AddItem ("above")

RC.AddItem ("4.5*10./cmm")RC.AddItem ("4.6*10./cmm")

RC.AddItem ("4.7*10./cmm")













RC.AddItem ("above")

126


127/203

ES.AddItem ("0mm")

ES.AddItem ("1mm")

ES.AddItem ("2mm")ES.AddItem ("3mm")

ES.AddItem ("4mm")


ES.AddItem ("7mm")


ES.AddItem ("10mm")

ES.AddItem ("11mm")


ES.AddItem ("14mm")

ES.AddItem ("14mm")



ES.AddItem ("19mm")

ES.AddItem ("20mm")

ES.AddItem ("above")

PC.AddItem ("1.5lacs/cmm")

PC.AddItem ("1.6lacs/cmm")PC.AddItem ("1.7lacs/cmm")















127


128/203







PC.AddItem ("4.5lacs/cmm")PC.AddItem ("above")

TL.AddItem ("4000/cmm")

TL.AddItem ("5000/cmm")TL.AddItem ("6000/cmm")





TL.AddItem ("above")

NEU.AddItem ("40")NEU.AddItem ("50")

NEU.AddItem ("40")

NEU.AddItem ("60")NEU.AddItem ("70")

NEU.AddItem ("above")

LYM.AddItem ("20")

LYM.AddItem ("30")

LYM.AddItem ("40")LYM.AddItem ("above")

MON.AddItem ("2")

MON.AddItem ("3")MON.AddItem ("4")

MON.AddItem ("5")


MON.AddItem ("8")


MON.AddItem ("above")

RT.AddItem ("1.6lacs")

128


129/203



RT.AddItem ("1.6lacs")RT.AddItem ("1.7lacs")




















RT.AddItem ("4.5lacs")RT.AddItem ("above")

BG.AddItem ("a+")

BG.AddItem ("b+")BG.AddItem ("o+")

BG.AddItem ("ab+")

BG.AddItem ("a-")BG.AddItem ("b-")

BG.AddItem ("o-")

BG.AddItem ("ab-")

CT.AddItem ("5 min")



129


130/203



CT.AddItem ("10 min")CT.AddItem ("above")



cnn.Open "D:\raj\LAB.mdb"rss.Open "haema", cnn, adOpenDynamic, adLockOptimistic, adCmdTable

End Sub

Private Sub REF_Click()PA.Text = " "

NA.Text = " "

HA.Text = " "

RC.Text = " "PC.Text = " "

RT.Text = " "CT.Text = " "

TL.Text = " "

BG.Text = " "

ES.Text = " "NEU.Text = " "

LYM.Text = " "

MON.Text = " "PA.SetFocus

End Sub


rss.AddNew


rss!haemoglobin = HA.Text

rss!redcellcount = RC.Text

rss!plateletcount = PC.Textrss!reticulocytes = RT.Text

rss!clottingtime = CT.Text

rss!tlc = TL.Textrss!bloodgroup = BG.Text

rss!esr = ES.Text

rss!neutrophills = NEU.Textrss!lymphocytes = LYM.Text

rss!monocytes = MON.Text

rss.Save


130


131/203

End Sub

131


132/203

SEROLOGY REPORT

Dim cnn As ADODB.Cnnectiono



MA.Show

Unload Me

End Sub


PR.AddItem ("positive")

PR.AddItem ("negative")

AH.AddItem ("positive")AH.AddItem ("negative")

RA.AddItem ("positive")

RA.AddItem ("negative")

VD.AddItem ("positive")

VD.AddItem ("negative")

CR.AddItem ("positive")

CR.AddItem ("negative")

AT.AddItem ("positive")

AT.AddItem ("negative")

HT.AddItem ("positive")

HT.AddItem ("negative")

KAH.AddItem ("positive")

KAH.AddItem ("negative")

TOX.AddItem ("positive")

TOX.AddItem ("negative")

HBS.AddItem ("positive")

HBS.AddItem ("negative")

132


133/203

SPF.AddItem ("positive")

SPF.AddItem ("negative")

MAT.AddItem ("positive")

MAT.AddItem ("negative")


Set rss = New ADODB.Recordsetcnn.Provider = "microsoft.jet.oledb.4.0"


rss.Open "sero2", cnn, adOpenDynamic, adLockOptimistic, adCmdTable

End Sub

Private Sub REF_Click()PA.Text = " "

NA.Text = ""PR.Text = " "

AH.Text = " "

RA.Text = " "

VD.Text = " "CR.Text = " "

AT.Text = " "

HT.Text = " "KAH.Text = " "

TOX.Text = " "

HBS.Text = " "SPF.Text = " "

MAT.Text = " "

PA.SetFocusEnd Sub


rss.AddNewrss!patientno = PA.Text

rss!Name = NA.Text

rss!pregnancy = PR.Textrss!antihcv = AH.Text

rss!rafactor = RA.Text

rss!vdrl = VD.Textrss!crprotein = CR.Text

rss!asotitre = AT.Text

rss!hivtest = HT.Text

rss!kahn = KAH.Text

133


134/203

rss!toxoplasmosis = TOX.Text

rss!hbsaghepatitisb = HBS.Text

rss!spforafb = SPF.Textrss!mantouxtest = MAT.Text

rss.Save


End Sub

134


135/203

BIOCHEMISTRY REPORT




MA.ShowUnload Me

End Sub


BS.AddItem ("60mg/dl")


BS.AddItem ("62mg/dl")BS.AddItem ("63mg/dl")





















135


136/203





















BS.AddItem ("120mg/dl")BS.AddItem ("above")

BU.AddItem ("15mg/dl")BU.AddItem ("16mg/dl")

BU.AddItem ("17mg/dl")










136


137/203









BU.AddItem ("above")

SO.AddItem ("136mEq/l")



SO.AddItem ("139mEq/l")SO.AddItem ("140mEq/l")







SO.AddItem ("above")

PO.AddItem ("3.8mEq/l")


PO.AddItem ("4.0mEq/l")PO.AddItem ("4.1mEq/l")









PO.AddItem ("above")

137


138/203

SU.AddItem ("1.5mg/dl")


SU.AddItem ("1.7mg/dl")SU.AddItem ("1.8mg/dl")































138


139/203








SU.AddItem ("above")

CAL.AddItem ("9.0mg/dl")CAL.AddItem ("9.1mg/dl")

CAL.AddItem ("9.2mg/dl")













CAL.AddItem ("above")

PHO.AddItem ("2.5mg/dl")PHO.AddItem ("2.6mg/dl")

PHO.AddItem ("2.5mg/dl")







139


140/203












PHO.AddItem ("above")

MAG.AddItem ("1.7mg/dl")

MAG.AddItem ("1.8mg/dl")MAG.AddItem ("1.9mg/dl")






MAG.AddItem ("above")

RBS.AddItem ("150mg/dl")


RBS.AddItem ("170mg/dl")RBS.AddItem ("180mg/dl")






RBS.AddItem ("above")

SC.AddItem ("0.8mg/dl")




140


141/203



SC.AddItem ("above")

SCH.AddItem ("96mg/dl")

SCH.AddItem ("97mg/dl")SCH.AddItem ("98mg/dl")







SCH.AddItem ("above")

ACP.AddItem ("1 k.a.unit/dl")

ACP.AddItem ("2 k.a.unit/dl")ACP.AddItem ("3 k.a.unit/dl")

ACP.AddItem ("4 k.a.unit/dl")

ACP.AddItem ("above")



cnn.Open "D:\raj\LAB.mdb"rss.Open "bioch1", cnn, adOpenDynamic, adLockOptimistic, adCmdTable

End Sub


PA.Text = " "NA.Text = ""

BS.Text = " "

BU.Text = " "PO.Text = " "

SO.Text = " "

SU.Text = " "CAL.Text = " "

PHO.Text = " "

MAG.Text = " "

RBS.Text = " "

141


142/203

SC.Text = " "

SCH.Text = " "

ACP.Text = " "PA.SetFocus

End Sub


rss.AddNew


rss!bloodsugar = BS.Text

rss!bloodurea = BU.Text

rss!sodium = SO.Textrss!potassium = PO.Text

rss!uricacid = SU.Text

rss!calcium = CAL.Text

rss!phosphorus = PHO.Textrss!magnesium = MAG.Text

rss!rbsugar = RBS.Textrss!screatinine = SC.Text

rss!schloride = SCH.Text

rss!acidphosp = ACP.Text

rss.SaveMsgBox ("recordsaved")

End Sub

142


143/203

STOOL PEPORT




MA.Show

Unload MeEnd Sub


COL.AddItem ("brownish")COL.AddItem ("yellowish")

CO.AddItem ("solid")

CO.AddItem ("semisolid")CO.AddItem ("watery")

CY.AddItem ("E.Histalytics")

CY.AddItem ("giadia")

CY.AddItem ("amblia")

MU.AddItem ("nill")

MU.AddItem ("+")

MU.AddItem ("++")MU.AddItem ("+++")

MU.AddItem ("++++")

PU.AddItem ("nill")

PU.AddItem ("1-2")

PU.AddItem ("2-4")PU.AddItem ("4-6")

PU.AddItem ("6-8")

PU.AddItem ("8-10")

PU.AddItem ("above")

RB.AddItem ("nill")

RB.AddItem ("1-2")RB.AddItem ("2-4")

RB.AddItem ("4-6")

RB.AddItem ("6-8")RB.AddItem ("8-10")

RB.AddItem ("above")

143


144/203

BLO.AddItem ("nil")

BLO.AddItem ("+")

BLO.AddItem ("++")BLO.AddItem ("+++")

BLO.AddItem ("++++")

STR.AddItem ("nil")

STR.AddItem ("+")

STR.AddItem ("++")STR.AddItem ("+++")

STR.AddItem ("++++")

ST.AddItem ("nil")ST.AddItem ("+")

ST.AddItem ("++")

ST.AddItem ("+++")

ST.AddItem ("++++")

OCC.AddItem ("negative")OCC.AddItem ("positive")

OCC.AddItem ("+")

OCC.AddItem ("++")

OCC.AddItem ("+++")OCC.AddItem ("++++")

STOF.AddItem ("acidic below 5.0")STOF.AddItem ("normal 6.0")

STOF.AddItem ("6.1")

STOF.AddItem ("6.2")STOF.AddItem ("6.3")


STOF.AddItem ("6.5")STOF.AddItem ("6.6")



STOF.AddItem ("alkaline 7.0 is above")

RES.AddItem ("nil")

RES.AddItem ("+")RES.AddItem ("++")

RES.AddItem ("+++")

RES.AddItem ("++++")

144


145/203


Set rss = New ADODB.Recordset

cnn.Provider = "microsoft.jet.oledb.4.0"cnn.Open "D:\raj\LAB.mdb"

rss.Open "sto", cnn, adOpenDynamic, adLockOptimistic, adCmdTable

End Sub


PA.Text = " "

NA.Text = " "

COL.Text = " "CO.Text = " "

CY.Text = " "

MU.Text = " "

PU.Text = " "RB.Text = " "

BLO.Text = " "STR.Text = " "

ST.Text = " "

OCC.Text = " "

STOF.Text = " "RES.Text = " "

PA.SetFocus

End Sub


rss.AddNewrss!patientno = PA.Text

rss!Name = NA.Text

rss!colour = COL.Textrss!consistancy = CO.Text

rss!cysts = CY.Text

rss!mucus = MU.Text

rss!puscell = PU.Textrss!redbloodcell = RB.Text

rss!blood = BLO.Text

rss!starchcell = STR.Textrss!starchfibers = ST.Text

rss!occultblood = OCC.Text

rss!stoolforph = STOF.Textrss!reducingsubstances = RES.Text

rss.Save


End Sub

145


146/203

SEMEN REPORT




MA.Show

Unload MeEnd Sub


VOL.AddItem ("2ml")VOL.AddItem ("3ml")

VOL.AddItem ("4ml")VOL.AddItem ("5ml")

VOL.AddItem ("6ml")

VOL.AddItem ("7ml")

VOL.AddItem ("8ml")VOL.AddItem ("above")

VIS.AddItem ("normal")VIS.AddItem ("abnormal")

CO.AddItem ("graynish white")CO.AddItem ("light pale yellow")

LIQ.AddItem ("10 min")



LIQ.AddItem ("13 min")LIQ.AddItem ("14 min")








146


147/203






AM.AddItem ("60 normal")AM.AddItem ("20%")

AM.AddItem ("30%")

AM.AddItem ("40%")

AM.AddItem ("50%")

COU.AddItem ("80million/cmm")


COU.AddItem ("82million/cmm")COU.AddItem ("83million/cmm")









COU.AddItem ("96

banking project report vb

Documents