使用OpenRecordSet与预建查询的问题 [英] Problems using OpenRecordSet with a prebuilt query

问题描述

我有一个表格，我希望能够将一个特定的软件重新分配给另一台机器。


表格规格：

软件标题：cbotitle

CDKEY：cbocdkey

旧作业：cbooldassignment

新作业：cbonewassignment



我已经构建了一个查询，通过从当前表单中获取其标准，动态地提取软件当前分配给的所有计算机的列表。


如果我打开完成表单后手动查询everythign工作正常。


qryASSIGNCHANGE的SQL：

I have a form that i want to be able to reassign a specific piece of software to a different machine.

Form specs:
Software Title: cbotitle
CDKEY: cbocdkey
Old Assignment: cbooldassignment
New Assignment: cbonewassignment


I''ve built a query that pulls a list of all the computers the software is currently assigned to dynamically by gettings its criteria from the current form.

If i open the query manually after completing the form everythign works fine.

SQL for qryASSIGNCHANGE:

展开 | 选择 | 包裹 | 行号

推荐答案

我有一个表格，我希望能够将一个特定的软件重新分配给另一台机器。


表格规格：

软件标题：cbotitle

CDKEY：cbocdkey

旧作业：cbooldassignment

新作业：cbonewassignment



我已经构建了一个查询，通过从当前表单中获取标准，动态地提取软件当前分配给所有计算机的列表。


如果我在完成表单后手动打开查询，则everythign工作正常。


qryASSIGNCHANGE的SQL：

I have a form that i want to be able to reassign a specific piece of software to a different machine.

Form specs:
Software Title: cbotitle
CDKEY: cbocdkey
Old Assignment: cbooldassignment
New Assignment: cbonewassignment


I''ve built a query that pulls a list of all the computers the software is currently assigned to dynamically by gettings its criteria from the current form.

If i open the query manually after completing the form everythign works fine.

SQL for qryASSIGNCHANGE:

展开 | 选择 | Wrap | 行号

尝试在findfirst行中添加引号。

Try adding quotes in the findfirst line.

展开 | 选择 < span class =codeDivider> | Wrap | 行号

尝试将查询放入字符串，然后将字符串传递给openrecordset命令。 />

如果您不确定如何执行此操作发布查询的sql，我将帮助您构建字符串。

Try putting your query into a string and then passing the string into the openrecordset command.

If you are unsure how to do this post the sql for your query and I will help you with building the string.

这篇关于使用OpenRecordSet与预建查询的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！