将报告超链接到另一个报告 [英] Hyperlink a report to another report

问题描述

我有两份报告报告。一个报告显示一个名为[BWAID]的字段。第二份报告是详细报道的单一记录。我试图将我的第一个报告上的这个文本框转换为超链接。超链接将链接到第二个报告报告。我需要这个超链接来捕获点击时[BWAID]的内容，并在参数查询中使用[BWAID]来提取另一个报告（更详细的报告）。


我正在寻找有关如何处理这种情况的建议。我看着我应该编写一个OnClick VBA，但是我不知道如何将[BWAID]值拉入我的第二个报表参数查询。


谢谢

I have two report reports. One report displays a field called [BWAID]. The second report is a report for a single record in mor detail. I am trying to convert this textbox on my first report into a hyperlink. The hyperlink will link to the 2nd report report. I need this hyperlink to also capture what the [BWAID] is when clicked and use the [BWAID] in a paramater query to pull up another report (more detailed report).

I am looking for advice on how to approach this situation. I looks to me that I should program an OnClick VBA however I don''t understand how to pull the [BWAID] value into my second report parameter query.

Thanks

推荐答案

报告不是交互式的。您无法在报表上使用点击事件，也无法单击要从一个链接到另一个链接的超链接。也许如果你解释了你想要达到的目的，我们可以为你提出一些替代方法。


-Stewart

Reports are not interactive. There is no on-click event you can use on a report, nor can you click on a hyperlink to link from one to another. Perhaps if you explained what it is you are trying to achieve we could suggest some alternative approaches for you.

-Stewart

基本上我有一个报告。该报告将包含多个记录。其中一个文本显示字段具有Id编号[BWAID]。我的用户想要点击[BWAID]文本框并打开第二个报告，这是一条记录的详细列表。


我可以设置一个[OnClick]事件具有[BWAID]文本框控件的多个记录的报告，并对事件进行编程以打开另一个报告（详细报告）。我需要从[BWAID]文本框中提取值并将其用作参数来打开我的详细报告。


希望有助于。我可以上传照片，如果你仍然不确定我想要做什么。


谢谢

Basically I have a Report. The report will contain multiple records. One of the text display fields has an Id number [BWAID]. My user wants to click on the [BWAID] text box and have it open a second report which is a detailed listing of a single record.

I can set an [OnClick] Event on the report with multiple records on the [BWAID] textbox control and program the event to open another report (Detailed report). I need to pull the value out of the [BWAID] Textbox and use that as a parameter to open up my detailed report.

Hope that Helps. I can upload pics if your still not sure what I''m trying to do.

Thanks

斯图尔特，我相信Access版本2007和实际上现在确实有交互式报告。


我怀疑它是为了迎合那些一开始就无法正确使用这个东西的人，但我听到了（没有直接的经验，你理解）这是当时引入的变化之一。

Stewart, I believe Access versions 2007 and beyond actually do have interactive reports now.

I suspect it was to pander to those who couldn''t work out how to use the thing properly in the first place, but I hear (No direct experience, you understand) that this is one of the changes introduced then.

这篇关于将报告超链接到另一个报告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！