[AccessD] OutputTo problem

Jeffrey and Charlotte
Thank you.
I did reformat the date to exclude the standard hash marks.
It works now.
But I'm still stumped as to why it quit working in the first place.
Or why did it work before?
I'm not going to spend any more time on this...
Thanks again.
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte
Foust
Sent: Friday, March 25, 2005 10:53 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] OutputTo problem


The date function is going to return a short date, complete with
delimiters.  If those delimiters happen to be slashes, or worse
backslashes, it causes problems.  If you format the date result as
"ddmmyyyy", or some such, it should work.

Charlotte Foust


-----Original Message-----
From: Jim Hewson [mailto:JHewson at karta.com] 
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
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com