如何从Access生成报告，他们可以保存或打印文件？ [英] How to generate a report from Access to a file they can either save or print?

问题描述

我有以下代码在本地运行时工作正常，但是当尝试通过Citrix服务器从Access运行报表时，我得到MS VB运行时错误2501：OutputTo操作已取消。我的特定My Documents文件夹映射到N：驱动器。任何帮助将不胜感激。谢谢。

I have the following code that works fine when I run it locally, but when trying to run the report from Access through the Citrix server, I get MS VB Run-time error 2501: The OutputTo action was canceled. My particular My Documents folder is mapped to the N: drive. Any help will be greatly appreciated. Thank you.

展开 | 选择 | Wrap | 行号

推荐答案

从我在代码中看到的，你的尺寸 dbscw 和 rstcw 变量（第3行和第4行）但设置 dbs 和 rst （第12行和第13行）。


我认为你发帖时出错是因为，除非你不使用 Option Explicit ，否则编译器必须引发错误。


无论如何都要先解决。

From what I see in your code, you dimension dbscw and rstcw variables (lines #3 and #4) but set dbs and rst (lines #12 and #13).

I think that you make an error when you post this because, unless if you not use Option Explicit, your compiler must raise an error.

Anyway fix that first.

你好Mihail，

修正那个部分。代码在本地为我创建报告，但是当我创建accde并尝试通过Citrix运行它时，现在我得到一个不同的错误：您的Microsoft Access数据库或项目包含对文件的缺失或损坏的引用Wfica .ocx''版本2.8。我将继续努力，看看我现在是否可以解决这个问题。我认为我现在最大的问题是如何部署应用程序以便它可以通过Citrix运行。谢谢你的帮助。

Hello Mihail,
Fixed that part. The code creates the report for me locally, but when I create the accde and try to run it through Citrix, now I get a different error: "Your Microsoft Access database or project contains a missing or broken reference to the file ''Wfica.ocx'' version 2.8." I will work on that and see if I can fix that now. I think my biggest question now is how to deploy the application so that it can function through Citrix. Thank you for your help.

我承认我对citrix不太熟悉，所以当你读到我的想法时请记住这一点。


您是否正在访问远程桌面？在这种情况下，需要使用正确的dll设置远程桌面，并将网络共享映射到与您的示例相同的驱动器。

I will admit that I am not too familiar with citrix, so bear that in mind when you read my thoughts.

Are you accesssing a remote desktop? In that case the remote desktop needs to be setup with the correct dlls, and have the network share mapped to the same drive as your example.

这篇关于如何从Access生成报告，他们可以保存或打印文件？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！