如何链接Access 2003中的绘图 [英] How to link Drawings in Access 2003
问题描述
我目前正在尝试修复我的旧数据库并且遇到了一些麻烦...
我正在尝试将绘图（位图图像）链接到表格。
我已经在一列中为图像设置了路径的表格，在另一列中设置了与其对应的部件号。
在我的主表单上，我在部件号字段旁边有一个按钮，我想用它来显示另一种形式的图像。它从主表单中复制部件号并将其粘贴到图纸中的部件号。形成。
我试图使用DLookup来显示图像，但无济于事。
我也尝试过微软的做事方式，但他们对模板中需要改变的内容的解释是相反的。
I am currently trying to fix up my old database and I have hit a bit of a snag...
I am trying to link a drawing (bitmap image) to a form.
I have set up a table with the Path to the image in one column and the part number it corresponds to in the other.
On my main form I have a button next to the part number field which I want to use to display the images in another form. It copies the part number from the main form and pastes it to the part number in the "Drawing" form.
I tried to use a DLookup to display the image but to no avail.
I have also tried the Microsoft way of doing things but their explanations of what needs to be changed from the template is rather s**t.
推荐答案
@ greeni91
只需订阅，将在稍后返回。零件号是字符串还是数字？
@greeni91
Just subscribing, will return later. Is Part Number a String or Number?
@ADezii
零件编号设置为字符串，因为它以2个字母开头，例如AG55470。
/ Sandy
@ADezii
The Part Number is set as a string as it begins with 2 letters, e.g. AG55470.
/Sandy
- 通过以下方式打开第二个表格OpenForm（）方法，并通过OpenArgs属性传递零件号（PartNum应该是必需的）：
- Open the 2nd Form via the OpenForm() Method, and pass the Part Number via the OpenArgs Property (PartNum should be Required):
这篇关于如何链接Access 2003中的绘图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
