 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / March 2005Previewing a report
I have code that loops through some statements, previewing the same report each time through. After the first report previews and I close it, the loop seems to end and will not prewiew the remaining pages. It seems as if I need to be trapping some event or somewhere within the code to pause it. Any ideas? > I have code that loops through some statements, previewing the same > report each time through. After the first report previews and I close > it, the loop seems to end and will not prewiew the remaining pages. > It seems as if I need to be trapping some event or somewhere within > the code to pause it. Any ideas? Are you also closing the report in the loop? Unlike a form, a report that is already opened will not be refreshed if you issue another Open method on it. It will just continue to display what was already there.  SignatureI don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com I was not closing the report in the loop, only on the toolbar. I am guessing that I need to do this with a DoCmd.Close (object) >> I have code that loops through some statements, previewing the same >> report each time through. After the first report previews and I close [quoted text clipped - 5 lines] > is already opened will not be refreshed if you issue another Open method > on it. It will just continue to display what was already there. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.