报告不公开，无法查看 [英] Report doesn't open, cannot view

问题描述

突然间访问已经停止打开某个报告。使用Access 2010 64.该报告有3个不同的链接报告，它应该在打印预览中打开。在一个我有一个事件按钮，打印报告打印预览，
用户可以打印或保存为pdf ...

All of a sudden access has stopped opening a certain report. Using access 2010 64. The report has 3 different linked reports and it it is supposed to open in print preview. On one for I have an event button which opens the report in print preview and the user can either print it or save as pdf...

这是运行的事件当"打印租约"时单击按钮，

Here is the event that runs when the "Print Lease" button is clicked,

Private Sub PrintLease_Click()
On Error GoTo Err_PrintLease_Click

DoCmd.OpenReport "LEASENEW", acViewPreview, , "LeaseID = " & Me.LeaseID

Exit_PrintLease_Click:
Exit Sub

Err_PrintLease_Click:
MsgBox Err.Description
Resume Exit_PrintLease_Click

End Sub

单击该按钮时，没有任何反应。如果我转到导航窗格并尝试从那里打开报告，它也不会打开。我可以去设计报告的视图，但是如果我点击打印预览它就不会打开。

When the button is clicked, nothing happens. If i go to the navigation pane and try to open the report from there it will not open either. I can go to design view of the report but if I click print preview it does not open.

另一个奇怪的是，从办公室的其他几台计算机访问FE在其中一台计算机上，报告将通过单击打印租赁按钮正常工作，但如果您在另一台计算机上执行此操作则无法正常工作。

The other weird thing is that the FE is accessed from a few other computers in the office and on one of the computers the report will work as it should by clicking the print lease button but if you go to do it on another computer it doesn't work.

如果有人可以提供更多非常感谢可以更好地解释问题以及如何解决问题的信息。

If anyone can provide more information that might better explain the issue and how to fix it would be much appreciated..

推荐答案

无论如何，你呢？在NoData事件中有取消？如果没有数据，这将迫使报告无法打开。或者可能是报告部分损坏了。如果是这种情况，您可以

By any chance, do you have a Cancel in the NoData event? That would force the report not open if there was no data. Or it could be that the report is partially corrupt. If that is the case, you could

1. 将其导出到空白数据库
2. 删除原始数据库中的报告
3. 压缩原始数据库
4. 将报告导回原始数据库。

这篇关于报告不公开，无法查看的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！