J
JJA
Overview:
I have two tables; one has employee information; the second training modules
(scores, dates ect) which I have used to create a query. I have used this
same query to generate a report, which was not a problem. The problem arises
when an individual moves to a different department to take up a different
position. I'm locked into the old department/position based on the way the
data was entered. I need to gernerate VB Code to transfer training material
that applies to the first department positon over to the second department
position with some Select Case, If Then statesments.
Here is the question:
How do I draw information from the query I created, have it pass through the
VB Code and have it printout on my current report??? How do I link the query
to the code and then the code to the report? It can't be that hard, I must
be missing something.
I have two tables; one has employee information; the second training modules
(scores, dates ect) which I have used to create a query. I have used this
same query to generate a report, which was not a problem. The problem arises
when an individual moves to a different department to take up a different
position. I'm locked into the old department/position based on the way the
data was entered. I need to gernerate VB Code to transfer training material
that applies to the first department positon over to the second department
position with some Select Case, If Then statesments.
Here is the question:
How do I draw information from the query I created, have it pass through the
VB Code and have it printout on my current report??? How do I link the query
to the code and then the code to the report? It can't be that hard, I must
be missing something.