从列表框中打开19个项目的附件 [英] Open Attachment from listbox of 19 items
问题描述
当我点击搜索按钮时，我有一个显示19项的列表框。第1项是我的主键，第19项是附件。那么这将是列（0）然后是列（18）
我有一个右键单击选项设置用于排序和编辑按钮，所以一旦用户找到他们想要的记录编辑他们点击编辑按钮。列表框中的整个第一行在打开表格时突出显示。
我想要的是如果他们看到附件，那将是.pdf或.doc并且它们非常小并且是的，我知道数据库中的附件是不可取的，但是这是上层人员现在想要的，直到我们得到我们的服务器，当然他们都说如果Access并不意味着它被使用，那么为什么要将它包含在软件编程中选项.............我不打算与那些付钱给我的人争论..........无论他们想要我做什么........ ......
所以，我的问题是，我想要一个事件，也许双击就可以了，所以我可以得到一些在用户说好的时候查询双击，它在第8行，主键为8，附件在那里，打开该附件供查看。这是我尝试编码的内容，但它除了清除列表框中的所有内容之外没有做任何事情。
I have a listbox that displays 19 items when I click the search button. Item 1 is my primary key with item 19 being an attachment. So that would be column(0) and then column(18)
I have a right click option set up for sorting and an edit button so once the user finds the record they want to edit they click the edit button. The entire 1st row in the listbox is highlighted upon open of form.
What I want is if they see an attachment, which will be .pdf or .doc and they are very small and yes I know attachments in DB is not advisable, however this is how the upper folks want it for now until we get our server and of course they all say if Access did not mean for it to be used then why include it in the software programming options.............I am not going to argue this point with those that pay me..........whatever they want I do..............
So, my problem is, I want an event, maybe a double click would be ok so I can have some sort of query that says ok when the user double clicks and it is on row 8 which would have primary key of 8 and the attachment is there, open that attachment for viewing. Here is what I tried coding for it but it does not do anything other than clear out everything in my listbox.
推荐答案
tmcrouse，
欢迎来到字节！希望我们可以帮助你。
Access中的附件很奇怪，我也遇到了一些违规行为。
为什么不对您的附件表单进行控制？然后，双击该控件将打开attachemnt对话框。在我所知的这个阶段，我知道没有办法打开。直接来自Access的附件。这个网站上的其他一些大脑可能知道。但是，根据我的理解，你必须先打开附件对话框，因为可能有多个附件。
如果这让你指向正确的方向，请告诉我。
tmcrouse,
Welcome to Bytes! Hope we can help you with this.
Attachments in Access are strange and I''ve come across some irregularities there, too.
Why not have a control on your Form for the Attachment? Then, double-clicking that control will open the attachemnt dialog. At this stage in my knowledge, I know of no way to "open" an attachment directly from Access. Some other giant brains on this site may know. But, from what I understand, you have to open the attachment dialog box first, because there may be multiple attachments.
Please let me know if this gets you pointed in the right direction.
处理attacments的方式略有不同。
请提供您正在使用的Access版本。
There are some slight differences in how attacments are handled.
Please provide the version of Access you are using.
Access 2010是我的版本
Access 2010 is my version
这篇关于从列表框中打开19个项目的附件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
