Doug Murphy
dw-murphy at cox.net
Fri Mar 25 10:49:32 CST 2005
Duh, didn't read the first line obviously. I had a similar problem in 97 but that was due to Snap shot not being part of the basic product, it was introduced in a service pack. Sorry about the noise. Doug -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Hewson Sent: Friday, March 25, 2005 8:44 AM To: AccessD Subject: [AccessD] OutputTo problem Access 2000, Snapshot Viewer. For the last several months, the code has been working properly for several users. In the last couple of days a few of the users (including myself) get an error message that reads: "The report snapshot was not created because you do not have enough free disk space for temporary work files." MS Knowledge Base indicates the problem is associated by one of three factors. 1. No file name: the parameters for OutPutTo indicates there is no need for a file name. When I take out the file to output to it works. 2. Invalid characters - none present. 3. Path specified does not exist - I'm using the default path (My Documents). Help files indicates that if a file is named with no path the default path is used. That is what I have been using. Below is the code line. DoCmd.OutputTo acReport, "rptCorporateTopList", acFormatSNP, "Corporate Top List - " & Date & ".snp", True If I take out the date, it works. If I remove the Output to file name, it works. I checked references, they all seem to be there. Why is the date function not working? Why is this not working? TIA Jim