shopaholic
Programmer
Hi !
An error happens while executing my code: "You try to commit or rollback without first beginning a transaction."
But I DO BEGIN my transactions !
Here is my code :
'Search VInvoice for new invoices to process
tmpWorkSpace.BeginTrans
'Add Detail Line Numbers to found set
Do Until rst.NoMatch = True
...
Loop
'Summarise Vendor Invoice totals
CreateAPTotalsIN
tmpWorkSpace.CommitTrans
PLEASE HELP ! thankssssss
An error happens while executing my code: "You try to commit or rollback without first beginning a transaction."
But I DO BEGIN my transactions !
Here is my code :
'Search VInvoice for new invoices to process
tmpWorkSpace.BeginTrans
'Add Detail Line Numbers to found set
Do Until rst.NoMatch = True
...
Loop
'Summarise Vendor Invoice totals
CreateAPTotalsIN
tmpWorkSpace.CommitTrans
PLEASE HELP ! thankssssss