Multiple reports same query 1

[kennedymr2]

in VBa i am printing several reports , but the problem i have is they are using the same query.. i keep getting a message that the table is already in use

Is there a way of stopping the preview of the second report until the first report is printed and completed,


This is the code

Dim stDocName As String
stDocName = "FODETDSalesCommissionDue1"
DoCmd.OpenReport stDocName, acPreview

???can we stop it here ??? eg While viewing ???


stDocName3 = "FODETDSalesCommissionOS1"
DoCmd.OpenReport stDocName3, acPreview



stDocName = "sumx"
DoCmd.OpenReport stDocName, acPreview


Appreciate any help

Kennedymr2

 

[MazeWorX]

you could check for the open report and open the second one only if it is closed you would need a loop to do it OR ... create separate queries?

Thoughts

HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work

 

[kennedymr2]

Mazeworx..

Thanks for your comments.

A bit hard to do seperate query's in this instance.

Looking for while ??????? report is open
do events
wend


regards Kennedymr2

 

[PWise]

do while CurrentProject.AllReports("Reportname").IsLoaded
doevents
loop

 

[kennedymr2]

PWise

Exactly what i was after... many thanks... helped a lot

Regards Kennedymr2