帮助存储特定记录的附件 [英] Help Storing Attachments to Specific Records
问题描述
我创建的数据库需要一个功能,其中某些项目可以附加某些指定的PDF。
我尝试创建以下循环,以便在列中搜索表格列(表名为附件)(标题为项目编号,恰好是ID或列中) (1)通过我表单上生成的项目编号(pnumber.value)
如果我的表[附件](字段(1))与生成的数字(pnumber)之间存在匹配.value)在我的表列中,它将编辑附件列(称为附件 - 字段6)并根据附在我表单上的附件更新附件。
如果没有匹配我希望它创建一个新的记录,其中包含项目编号详细信息和生成的相关附件,并保存在表单上。
PS(TorF.value是我生成的文本框告诉我如果表格中存在一个记录表格加载,以帮助进行故障排除,并可能用于简单地转换开关/ If else语句)
非常感谢你的帮助和我应用记下你读完帖子的时间,
LonelyKeyboard
您的记录集不应返回记录。它应该只返回你正在寻找的记录。那么你可以使用记录计数来告诉你是否有匹配。
基本上是这样的:
展开 | 选择 | Wrap | 行号
我在以下行中收到错误:
展开 | 选择 | Wrap | 行号
这也是生成错误
展开 | 选择 | Wrap | 行号
The database I have created needs a feature in which certain projects can be attached with certain specified PDF''s.
I have tried creating the following loop in order to search through a table column (table is named attachments) the column (which is titled project number and is just right of ID or in column(1)by a generated project number on my form (pnumber.value)
If a match exists between my table [Attachments](Field(1))and the generated number (pnumber.value) in my table column that it will edit the attachments column (called attachments - field 6) and update the attachments based on those attached on my form.
If there is not a match I would like it to create a new record with the project number details and associated attachments generated adn saved on the form.
PS (TorF.value is a textbox I generated to tell me if a record exists in the table on the form load to help with troubleshooting and potentially to use as simplyfying the switch / If else statements)
Thank you all very much for your help and I appreciate the time you have taken out to read the post,
LonelyKeyboard
Expand|Select|Wrap|Line Numbers解决方案Your recordset should not return record. It should just return the record you''re looking for. Then you can use the record count to let you know if there is a match or not.
Basically something like this:
Expand|Select|Wrap|Line Numbers
I am getting an error in the following line:
Expand|Select|Wrap|Line Numbers
Also this is generating an error
Expand|Select|Wrap|Line Numbers
这篇关于帮助存储特定记录的附件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文登录 关闭
扫码关注1秒登录发送“验证码”获取 | 15天全站免登陆