Results 1 to 4 of 4
  1. 02-16-2011, 04:31 AM #1
    houseofturner
    houseofturner is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2011
    Posts
    2

    Memory & Reports

    I want to run a whole series of reports one after each unattended rather than doing them one by one. Each report is similar to:

    DoCmd.OpenReport "RDP - Report 11 - Prospects Without Contact - Chart", acViewPreview



    I would just send them all to a single PDF but dont know how.

    When I try and run them all I get an out of memory error, but I have a massive processor, 6 gb of ram etc?

    I using Access 2007.
    Reply With Quote Reply With Quote
  2. 02-16-2011, 05:19 AM #2
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Do you have the latest driver for your printer? If acViewPreview mode, shouldn't you pause after each report?
    Reply With Quote Reply With Quote
  3. 02-16-2011, 05:23 AM #3
    houseofturner
    houseofturner is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2011
    Posts
    2
    Quote Originally Posted by RuralGuy View Post
    Do you have the latest driver for your printer? If acViewPreview mode, shouldn't you pause after each report?
    I beleive I have the latest driver. When you say pause do you mean programatically?
    Reply With Quote Reply With Quote
  4. 02-16-2011, 05:26 AM #4
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Quote Originally Posted by houseofturner View Post
    When you say pause do you mean programatically?
    Yes! Your output is going to the screen so it involves user interaction does it not? acDialog would pause each report until dispatched by the user.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Out of memory exporting to spreadsheet
    By croydon in forum Programming
    Replies: 3
    Last Post: 07-22-2010, 02:29 PM
  2. Importing jpgs running out of memory?
    By cowboy in forum Reports
    Replies: 1
    Last Post: 05-22-2010, 08:25 PM
  3. access 2003 on vista Out of Memory Problem
    By skbrede in forum Access
    Replies: 0
    Last Post: 07-25-2009, 08:28 AM
  4. I am using Access. How can I clear cache memory?
    By komralph in forum Access
    Replies: 0
    Last Post: 01-09-2009, 03:10 PM
  5. Out of Memory
    By Norman Masson in forum Access
    Replies: 0
    Last Post: 12-29-2008, 11:09 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums