以访问报告为条件显示图像 [英] Displaying an image conditional on an Access Report

问题描述

您好，我一般都是Access的新手......但是确实有很多VBA的能力（尽管通常是通过Excel）。


我正在开发一个通过Access Report生成产品目录的项目，这就是我所坚持的：


他们希望在每个产品类别的主要组标题下方显示广告横幅。我们计划将这些图像横幅存储到他们自己的桌子中，并通过那里连接到正确的类别。


然而，事实是，并非所有类别都会有横幅显示。


我假设一个简单的检查，看看当前类别的图像是否存在将照顾图像是否显示...并调整组标题'的高度也基于此。


但是我应该将这个代码放入哪个事件才能正常运行？

Hello, I am fairly novice with Access in general ... but do have a decent amount of ability with VBA (mostly through Excel, though).

I''m working on a project that is producing a product catalog through an Access Report, and here is what I am stuck on:

There are advertising banners that they would like to display beneath the main group headers for each product category. We plan on storing these image banners into their own table, and connect to the correct one for the category through there.

The thing is, though, that not all categories will have a banner to display.

I''m assuming a simple check to see if an image exists for the current category would take care of whether the image shows or not ... and adjust the group header''s height based on that also.

But which event should I put this code in for it to function correctly?

推荐答案

我在工作中不会使用很多图像，但最合理的方法是通过链接图像表来将图像项包含在查询中吗？


使用代码可以处理标题的大小，但我建议这是一个单独的问题，只有在第一个问题得到解决时才应该接近。

I don''t use images much in my work, but wouldn''t the most sensible approach be to include the image item in the query by linking the image table in?

Handling the size of the header could be done using code, but I would suggest that is a separate question and should be approached only when the first problem is resolved.

绝对值得一看成。让我试一试。

Definitely worth looking into. Let me give that a run.

态度好。去吧。


让我们知道你如何继续它，我们可以看到当时仍然需要帮助。

Good attitude. Go for it.

Let us know how you get on with it and we can see about helping if any is still required by then.

这篇关于以访问报告为条件显示图像的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！