lumch
Board Regular
- Joined
- Jan 29, 2010
- Messages
- 204
Hello. I need help with a userform with some combobox selection:
I have a small family medical office and I need to improve the way we do the referrals for patient, in order to make it effective I need accuracy and proactivity, here is the idea:
I have a referral form pre established very simple:
1. Demographics: patient's name, date of birth, phone number, insurance info---this information is going to be enter as patients need it--- this part I got it.
2. Referring place: name, phone number, fax number, address, appt date, appt time.
3. Purpose of referral: type of referral/procedure, diagnosis / icd-9 code
4.referring physician.
What I need to do is for number 2 is have a userform that I select i.e: specialist Gastroenterologist and them give me a list of Gastroenterologist and I select one i.e: Northwest Gastro Inc. and when I select that one it will show in the same user form the rest of the info such as address, phone, fax and insurances they DON'T TAKE. However it will be very useful if I enter the 3 first letter of the place name and match from a data base.
If there is no place that I am looking for , an option to add it or edit it, (this will be an extra plus). If in not in the data base enter the info and keep it in the data base.
For part 3 It will have 6 options: Consultation, Labs, Procedure, x.ray,follow up, and other. the options here are either I entered manually or select one of these and other option depending of what I selected open another list and I will select according to i.e: I select with a checkmark procedure then opens another list that shows Ultrasound,and the a part of the body i.e: abdomen and then left or right and then upper or lower, ( if this is too complicated can be enter manually) not a big deal but very useful if created.
Part 4. The names of the referring physicians and I will check the box according to the one.
All selection entered send it to an specific cell and then print ( this could be a command button, this part I believe I have it controlled).
The information about the place have to be pull from a database that is going to be created by each nurse as they got, For example today a new Physical Therapist open a clinic they will enter the info and it will be save for future needs to be referred to.
My knowledge in VBA in beginner, but I am willing to follow all instruction and be patient, and I ask viceversa to be patient. I understand you have things to do, so take your time.
I appreciate very much your time and effort, your knowledge is this expertise is immense.
Thanks in advance for your help. Any questions will be answered, however I believed I will have more questions than you.
I have a small family medical office and I need to improve the way we do the referrals for patient, in order to make it effective I need accuracy and proactivity, here is the idea:
I have a referral form pre established very simple:
1. Demographics: patient's name, date of birth, phone number, insurance info---this information is going to be enter as patients need it--- this part I got it.
2. Referring place: name, phone number, fax number, address, appt date, appt time.
3. Purpose of referral: type of referral/procedure, diagnosis / icd-9 code
4.referring physician.
What I need to do is for number 2 is have a userform that I select i.e: specialist Gastroenterologist and them give me a list of Gastroenterologist and I select one i.e: Northwest Gastro Inc. and when I select that one it will show in the same user form the rest of the info such as address, phone, fax and insurances they DON'T TAKE. However it will be very useful if I enter the 3 first letter of the place name and match from a data base.
If there is no place that I am looking for , an option to add it or edit it, (this will be an extra plus). If in not in the data base enter the info and keep it in the data base.
For part 3 It will have 6 options: Consultation, Labs, Procedure, x.ray,follow up, and other. the options here are either I entered manually or select one of these and other option depending of what I selected open another list and I will select according to i.e: I select with a checkmark procedure then opens another list that shows Ultrasound,and the a part of the body i.e: abdomen and then left or right and then upper or lower, ( if this is too complicated can be enter manually) not a big deal but very useful if created.
Part 4. The names of the referring physicians and I will check the box according to the one.
All selection entered send it to an specific cell and then print ( this could be a command button, this part I believe I have it controlled).
The information about the place have to be pull from a database that is going to be created by each nurse as they got, For example today a new Physical Therapist open a clinic they will enter the info and it will be save for future needs to be referred to.
My knowledge in VBA in beginner, but I am willing to follow all instruction and be patient, and I ask viceversa to be patient. I understand you have things to do, so take your time.
I appreciate very much your time and effort, your knowledge is this expertise is immense.
Thanks in advance for your help. Any questions will be answered, however I believed I will have more questions than you.
