将数据添加到字段 [英] Adding Data to a Field
问题描述
我想在窗体上创建一个命令按钮,该窗体将使用超链接地址(只是文本)填充该记录的某个表中的某个字段,并将该记录中的另一个字段添加到该字符串中。例如:
点击后,填写表格ASSEMBLY中的[DRAWING HYPERLINK]字段。与W:\engineering \PRODUCT ENGINEERING \ASSEMBLY \ PDDF \\ [来自记录的现场数据] .pdf
来自记录的字段数据[ASSY DOC]
该字段中的数据为A-2000-1
因此表汇编中的DRAWING HYPERLINK字段中将包含此数据:
W:\engineering\PRODUCT ENGINEERING \ASSEMBLY \PDF \ A-2000-1.pdf
只需单击命令表格上的按钮。
我认为这很简单,但我遇到了麻烦。非常感谢任何帮助。
谢谢
I want to create a command button on a form that will populate a certain field in a certain table for that record with a hyperlink address (just the text) and add another field from that record to the string. For Example:
On Click, fill the field [DRAWING HYPERLINK] in the Table "ASSEMBLY" with W:\engineering\PRODUCT ENGINEERING\ASSEMBLY\PDF\ [field data from record].pdf
field data from record entitled [ASSY DOC]
The data in that field is A-2000-1
So the DRAWING HYPERLINK field in Table ASSEMBLY would have this data in it:
W:\engineering\PRODUCT ENGINEERING\ASSEMBLY\PDF\ A-2000-1.pdf
Just by Clicking the command button on the form.
I think this would be simple, but I am having trouble. Any help is greatly appreciated.
Thanks
推荐答案
@Desitech
通过来自记录的字段数据[ASSY DOC]是指[ASSY DOC]是另一个表中字段的名称,并且该字段包含数据A-2000-1。当您单击要编码的按钮时,在表单上显示的记录中?
如果是这种情况,我认为你应该相当简单,但这是正确的,但是我会等待确认。
Jim
@Desitech
Hi,
By "field data from record entitled [ASSY DOC]" do you mean that [ASSY DOC] is the name of a field in another table and that that field contains the data "A-2000-1" in the record which is showing on the form when you click the button you want to code?
If that is the case, I think you are correct that this should be fairly simple, but I''ll wait for confirmation.
Jim
是的,但不在另一个表中。我正在使用的表单名为FrmAssembly,它链接到一个表格为TblAssembly
[ASSY DOC]是同一个表中某个字段的标题
表中的字段如下所示:
DOCID ASSY DOC说明日期来自DRAWINGHYPERLINK
记录中的数据如下所示:
DOCID = 1
ASSY DOC = A-2000-1
描述= DH装配
DATE = 1/1/09
BY = DBT
绘图HYPERLINK = W:\engineering\PRODUCTENGINEERING\ASSEMBLY \PDF \ A-2000 -1.pdf
Yes, but not in another table. The Form I am using is entitled FrmAssembly that is linked to a table entiled TblAssembly
[ASSY DOC] is the title of one of the fields in the same table
Fields in table looks like this:
DOCID ASSY DOC DESCRIPTION DATE BY DRAWINGHYPERLINK
Data in record looks like this:
DOCID =1
ASSY DOC= A-2000-1
DESCRIPTION = DH Assembly
DATE = 1/1/09
BY = DBT
DRAWING HYPERLINK = W:\engineering\PRODUCTENGINEERING\ASSEMBLY\PDF\ A-2000-1.pdf
@Desitech
更简单。不要这样做!如果[ASSY DOC]中数据之前和之后的文本是固定的,则不需要将其存储在表格中。任何时候你需要使用完整的字符串,你只需要构建它。例如。
@Desitech
Even easier. Don''t do it! If the text before and after the data in [ASSY DOC] is fixed, then it does not need to be stored in the table. Any time you need to use the full string you just build it up. eg.
这篇关于将数据添加到字段的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!