jeffrey.demulling at usbank.com
jeffrey.demulling at usbank.com
Fri Mar 25 10:50:53 CST 2005
You might want to do a msgbox "Corporate Top List - " & Date & ".snp" to
see the exact file name being created. It probably has some characters ie
"\" that is causing the error. You will probably need to format the date
to get rid of the "\"s.
Jeffrey F. Demulling
U.S. Bank Corporate Trust Services
60 Livingston Avenue
EP-MN-WS3C
St. Paul, MN 55107-2292
Ph: 651-495-3925
Fax: 651-495-8103
email: jeffrey.demulling at usbank.com
"Jim Hewson"
<JHewson at karta.co
m> To
Sent by: "AccessD"
accessd-bounces at d <accessD at databaseadvisors.com>
atabaseadvisors.c cc
om
Subject
[AccessD] OutputTo problem
03/25/2005 10:43
AM
Please respond to
"Access
Developers
discussion and
problem solving"
<accessd at database
advisors.com>
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
------------------------------------------------------------------------------
Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation.
==============================================================================