A
Angela_Marie via AccessMonster.com
I am completely new to Modules and VBA programming and would not even attempt
were it not for some events that need to programmed into our database. In
researching it appears that this is the only way to do it. I have been
reading and studying books and I am just not getting it. Please help if you
can.
We are a diagnostic lab with hundreds of patients. When we receive an order
for a diagnostic there are a list of activities that are automatically going
to need to occur, depending on the type of order we received. These
activities are sequential. Once one activity is completed, the next activity
needs to be automatically "Activated" (i.e. task can now be completed).
Tbl_Patients has a one-to-many relationship with Tbl_P2P (linked together
using PatientID) and Tbl_P2P has a one-to-many relationship with
Tbl_ScheduledActivities (linked together using P2PID).
Frm_PatientDataEntry is the form that links these (and other) elements
together for data entry. I have a tab for P2P which includes a Subform that
has objects from Tbl_P2P and a subform within that which includes objects
from Tbl_ScheduledActivities.
I am attempting to do 2 seperate activities:
1. I have a control button on the P2P tab that I want to program to
automatically populate the same list of activities into
Tbl_ScheduledActivities.
2. I want to program a change in the value of certain fields within specific
records of the Tbl_ScheduledActivities based upon changes in the current
record.
i.e. Once the activity of "Insurance Verification" has been marked
"Completed", the next sequential activity of "Verifying Benefits with
Patient" should change to "Activated". Once that activity has been marked
"Completed" the next sequential activity should be "Activated" and so on...
I realize I am basically asking for the entire code for 2 different things
and would appreciate any help/advice you could give me. If I am asking for
too much, please point me to a resource (inexpensive) that I can use. We are
a small business and I am the only one who knows Access. Thanks!
were it not for some events that need to programmed into our database. In
researching it appears that this is the only way to do it. I have been
reading and studying books and I am just not getting it. Please help if you
can.
We are a diagnostic lab with hundreds of patients. When we receive an order
for a diagnostic there are a list of activities that are automatically going
to need to occur, depending on the type of order we received. These
activities are sequential. Once one activity is completed, the next activity
needs to be automatically "Activated" (i.e. task can now be completed).
Tbl_Patients has a one-to-many relationship with Tbl_P2P (linked together
using PatientID) and Tbl_P2P has a one-to-many relationship with
Tbl_ScheduledActivities (linked together using P2PID).
Frm_PatientDataEntry is the form that links these (and other) elements
together for data entry. I have a tab for P2P which includes a Subform that
has objects from Tbl_P2P and a subform within that which includes objects
from Tbl_ScheduledActivities.
I am attempting to do 2 seperate activities:
1. I have a control button on the P2P tab that I want to program to
automatically populate the same list of activities into
Tbl_ScheduledActivities.
2. I want to program a change in the value of certain fields within specific
records of the Tbl_ScheduledActivities based upon changes in the current
record.
i.e. Once the activity of "Insurance Verification" has been marked
"Completed", the next sequential activity of "Verifying Benefits with
Patient" should change to "Activated". Once that activity has been marked
"Completed" the next sequential activity should be "Activated" and so on...
I realize I am basically asking for the entire code for 2 different things
and would appreciate any help/advice you could give me. If I am asking for
too much, please point me to a resource (inexpensive) that I can use. We are
a small business and I am the only one who knows Access. Thanks!