Hi everyone,
I have a report that I just want to loop through with a little wait time.
The report shows errors in red so when I see the 12 pages I can see the error
right away. As of now I have to hit the curser right button to loop through all the
pages.
Is there a way to do this automatically via VBA as soon as I open the view
to loop through all the pages with 1 sec pause in between the views.
I also ant to be able to stop the cycle by hitting any key.
This is my current code :
Private Sub Command85_Click()
DoCmd.OpenReport "qryDelivered2", acPreview, "", "", acNormal
DoCmd.RunCommand acCmdPreviewTwelvePages
End Sub
Thanks
I have a report that I just want to loop through with a little wait time.
The report shows errors in red so when I see the 12 pages I can see the error
right away. As of now I have to hit the curser right button to loop through all the
pages.
Is there a way to do this automatically via VBA as soon as I open the view
to loop through all the pages with 1 sec pause in between the views.
I also ant to be able to stop the cycle by hitting any key.
This is my current code :
Private Sub Command85_Click()
DoCmd.OpenReport "qryDelivered2", acPreview, "", "", acNormal
DoCmd.RunCommand acCmdPreviewTwelvePages
End Sub
Thanks
Last edited: