Recent content by darren99

when I use the outputto command to output a report to an .rtf file, most of my system memory(512MB) is eaten up. The rtf file is created, but most of my memory is gone...and then I get an error forcing Access to close because it performed an illegal operation... Any help would be EXTREMELY...

when I use the outputto command to output a report to a file, about half of my system memory(512MB) is eaten up. Though the outputto command does its job, all my memory is eaten up by it very quickly...and then I get an error forcing Access to close because it performed an illegal...

thank you Rich. Hi Rich, Thank you very much for the link...you have helped me tremendously and saved me a lot of time...

How do I reset the page numbers for each group and get it to print out as: page x of y ...for each group? The of y part is what stumps me... Any help would be extremely appreciated, Thanks.

Thanks for your help, however, the problem is that the name of the excel worksheet imported is independent of the name of the file... Do you know how I can access the name of the excel worksheet as to be able to access the import errors table? Or Do you know if there is a way to manually...

How do I automatically delete the import errors table when I import a table from an excel file using the transferspreadsheet action in VBA? The problem is that the name of the table created is unpredictable because tablename generated = [name of worksheet from source file]_[ImportErrors] All I...