确定ATTACHMENT字段是否为空 [英] Determining if an ATTACHMENT field is null

问题描述

我在该表单上有1个TABLE和1个FORM，大约有30个PAGES（选项卡）。其中一个选项卡式PAGES仅包含一个ATTACHMENT字段。对于任何选定的记录，我将所有标签都显示为数据，否则保持隐藏状态。这是通过在每个选项卡式PAGE中的文本框上检查NULL来完成的。用于此的表达式很好，但该表达式不适用于ATTACHMENT字段。任何人都有一个简洁，优雅的解决方案？谢谢


更大的图像查看链接= http： //www.minieriassociates.com/Overview.jpg

I have 1 TABLE and 1 FORM with about 30 PAGES (tabbed) on that form. One of the tabbed PAGES contains only an ATTACHMENT field. For any selected record, I make all tabs THAT HAVE DATA visible, otherwise the remain hidden. This is done by checking for NULL on a text box within each tabbed PAGE. The expression used for that are fine, but that expression does not work for ATTACHMENT fields. Anyone have an concise, elegant solution? Thanks

LARGER IMAGE VIEW LINK = http://www.minieriassociates.com/Overview.jpg

推荐答案

您能否告诉我们您的附件是如何配置的？ ？它是一个绑定控件吗？


此外，它是什么类型的控件？ 2016年有一个名为Attachment的新产品或技术名称是否有所不同？我在2010年的主要名单中找不到这样的控制权。


PS。这个问题是您可以在如果子表单有数据，则只能在主表单上显示子表单（选项卡页面）。

Can you tell us how your attachment is configured? Is it a Bound Control?

Also, what type of Control is it? Is there a new one in 2016 called Attachment or is the technical name different? I can find no such control in the main list in 2010.

PS. This question is a follow-on from an earlier question you can find at Subform (tabbed page) visible on main form ONLY if subform has data.

Greetings NeoPa ....这是2016年的新控制名为ATTACHMENT。 2016年工具栏中有一个回形针，用于将此控件放在表单/子表单/页面中。使用它创建一个可以大小的盒子。然后单击该框将显示LABEL框左侧的小回形针。单击那个回形针将打开一个传统的上传/附加对话框。虽然我相信它允许每个盒子中有多个附件（标签旁边有垂直滚动箭头）但我只使用每个盒子一个附件（因为图像文件将显示图像，我希望所有这些都显示）。文档将显示doc文件类型的ICON。我在页面上有3个这样的盒子，有3个页面，总共9个盒子，但每个页面只使用第一个盒子来检查是否为空。一些研究显示了一些如何确定是否为空的例子......大多数使用复杂的记录计数。功能。我正在寻找一个即使是Access Moron（我）也能理解的例子。

Greetings NeoPa .... This is the NEW control in 2016 called ATTACHMENT. 2016 has a paperclip in the toolbar for placing such a control in a form/subform/page. Using it creates a box one can size. Clicking in that box will then show a small paperclip left of the box LABEL. Clicking THAT paperclip will open a traditional UPLOAD/ATTACHMENT dialogue. While I believe it allows multiple attachments in each box (has Vertical scroll arrows next to the label) I use each box for only 1 attachment (because image files will display the image and I want all of them shown). Documents will display an ICON for the doc file type. I have 3 such boxes on a page, and 3 page, for a total of 9 boxes but using only the 1st box on each page for checking if null. Some research shows some examples of how to determine if null ... most using a complicated "recordcount" function. I''m looking for an example expression that even an Access Moron (me) can understand.

问候。听起来我不能在这个问题上提供很多帮助。


我想说的是，如果你能够做到这一点，那就看一些例子吧当它被填充时，当它不存在时，看看你是否可以确定它的任何属性的某种一致和可靠的设置，它将显示它所处的状态。然后你可以使用这种新的理解来检查你的代码中的那个属性。


祝你好运:-)


PS。也许访问新手，但不是Access Moron。你根本不会遇到这种情况。

Greetings. It sounds like I can''t be a great deal of help on this one.

What I would say though, if you feel up to it, is to look at some examples of when it''s populated and when it''s not and see if you can determine some sort of consistent and reliable setting of any of its properties that will show which state it''s in. Then you can use this new understanding to check for that property in your code.

Good luck :-)

PS. Maybe Access Newbie, but not Access Moron. You don''t come across as that at all.

这篇关于确定ATTACHMENT字段是否为空的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！