Can't print reports in Access 2003 for Access 2000 database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Our office recently upgraded our computers and we now have Office 2003. We previously created a few databases, one of which is quite extensive (but the designer no longer is available), and we cannot print any reports now that we have the new version of MS Office. We have converted the files to be 2003 files, but no matter what I have done, I cannot print my reports. I get an "Action Failed" message. The Macro Name is SelectII, the Condition is True: DCount("[KEY]", "PROBLEM")>0, the Action name is OutputTo, and the Arguments is 3, NOTICES, RichTextFormat (*.rtf), f:\assoc\ws\L1211309.rtf, Yes, , . I have had this particular database since we were working with Office 97 and never had a problem printing the reports when we upgraded to Office 2000. Our network support office unfortunately knows very little about Access and cannot help me, but they did say that the MDAC that created the original database will fail on teh Office 2003 platform (I don't understand this terminology, I am simply re-writing what was told to me.). Is there any way that I can fix this error?

Thank you
 
Victoria:

You talk about printing reports, but your post actually mentions using the
OutputTo command to create a file from the report. Which is actually
failing? (BTW MDAC would likely have little impact on this issue and the
version of MDAC which stands for Microsoft Data Access Components is updated
when you install Office 2003).

Can you preview and actually print the report when opened in the user
interface?

What occurs when you have the report open in preview and from the menu
File -> Export you choose to output it to an RTF file (obviously without the
standard filter you use,) does this work? If not a.) you may get a better
sense of the underlying error that is causing the problem and b.) try doing
a detect and repair on the Office installation (Help -> Detect and Repair;
you may need your IT folks to be there when you do this as it will require
both administrator privileges and access to the Office installation CD or
administrative installation point)

If that works OK, then look at your Macro. When using DCount(), normally
you should bracket all the fields and table names as in DCount("[KEY]",
"[PROBLEM]")>0.

HTH
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

Victoria said:
Our office recently upgraded our computers and we now have Office 2003.
Click to expand...
We previously created a few databases, one of which is quite extensive (but
the designer no longer is available), and we cannot print any reports now
that we have the new version of MS Office. We have converted the files to
be 2003 files, but no matter what I have done, I cannot print my reports. I
get an "Action Failed" message. The Macro Name is SelectII, the Condition
is True: DCount("[KEY]", "PROBLEM")>0, the Action name is OutputTo, and the
Arguments is 3, NOTICES, RichTextFormat (*.rtf), f:\assoc\ws\L1211309.rtf,
Yes, , . I have had this particular database since we were working with
Office 97 and never had a problem printing the reports when we upgraded to
Office 2000. Our network support office unfortunately knows very little
about Access and cannot help me, but they did say that the MDAC that created
the original database will fail on teh Office 2003 platform (I don't
understand this terminology, I am simply re-writing what was told to me.).
Is there any way that I can fix this error?
 
Back
Top