帮助存储特定记录的附件 [英] Help Storing Attachments to Specific Records

问题描述

我创建的数据库需要一个功能，其中某些项目可以附加某些指定的PDF。


我尝试创建以下循环，以便在列中搜索表格列（表名为附件）（标题为项目编号，恰好是ID或列中） （1）通过我表单上生成的项目编号（pnumber.value）


如果我的表[附件]（字段（1））与生成的数字（pnumber）之间存在匹配.value）在我的表列中，它将编辑附件列（称为附件 - 字段6）并根据附在我表单上的附件更新附件。


如果没有匹配我希望它创建一个新的记录，其中包含项目编号详细信息和生成的相关附件，并保存在表单上。


PS（TorF.value是我生成的文本框告诉我如果表格中存在一个记录表格加载，以帮助进行故障排除，并可能用于简单地转换开关/ If else语句）


非常感谢你的帮助和我应用记下你读完帖子的时间，


LonelyKeyboard

展开 | 选择 | Wrap | 行号

解决方案

您的记录集不应返回记录。它应该只返回你正在寻找的记录。那么你可以使用记录计数来告诉你是否有匹配。


基本上是这样的：

展开 | 选择 | 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屋！