zdpl0a
asked on
Controlling Processes
Hello Experts:
I need help determining how to handle this process. I have a report, which displays information concerning transactions on a deposit slip. After running the report, I run a seperate routine, which changes the status of each record to indicate that that transaction is closed. This process works just fine.
However, it appears that the status changing occurs first, so when the report is displayed, it returns a blank report. I've put the processes in a module, and call the module from my application. Here is the code:
Dim objDeposits As clsStatements
Set objDeposits = New clsStatements
DoEvents
objDeposits.PrintDepositDe
objDeposits.ChangeDepositS
Set objDeposits = Nothing
PrintDepositDetails is the module which displays the report and ChangeDepositStatus is the module which changes the status of each transaction. So, my question is, is there a way to determine when a process is completed before starting the next process?
I need help determining how to handle this process. I have a report, which displays information concerning transactions on a deposit slip. After running the report, I run a seperate routine, which changes the status of each record to indicate that that transaction is closed. This process works just fine.
However, it appears that the status changing occurs first, so when the report is displayed, it returns a blank report. I've put the processes in a module, and call the module from my application. Here is the code:
Dim objDeposits As clsStatements
Set objDeposits = New clsStatements
DoEvents
objDeposits.PrintDepositDe
objDeposits.ChangeDepositS
Set objDeposits = Nothing
PrintDepositDetails is the module which displays the report and ChangeDepositStatus is the module which changes the status of each transaction. So, my question is, is there a way to determine when a process is completed before starting the next process?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
There are better ways of doing this with events and such, but this is the easiest way that works in most situations.
ASKER