从a创建和更新表 [英] Create and update a table from a

问题描述

大家好，


介绍

我一直在关注这篇文章：

复选框表单允许用户选择查询输出字段


（非常感谢ADezii和所有其他贡献者）


在坚果壳中，

1.用户选择他/她想要看的标准的复选框，

2.使用组合框，他们可以选择他们想要看到上述选定标准的特定品牌/系列产品for：

展开 | 选择 | Wrap | 行号

解决方案

大家好，


有趣的是，我在发布后设法解决了部分问题（感谢zmbd编辑）。


我只是将where代码更改为：

展开 | 选择 | Wrap | 行号

HBB01：


我不是真的关注你在这里想做的事情。

你通常不应该创造和删除设计良好的数据库中的表格。

可以根据您的操作保存或创建查询。存储的查询保存在 QueryDef对象（DAO）Office 2010 ，这些可以随时更改 - 这是我以前为报告做的事情。

我现在做的是创建一个参数查询基于整个记录集，构建我的报告，并通过传递过滤器或参数来打开报告。
在查询和报告中使用参数我发现这更清洁，更易于维护，更稳定。

您好zmbd，


感谢您的回复。


我请仔细阅读你发给我的链接，看看我是否可以解决问题。


如果找到解决办法或卡住，我会回复。


谢谢。

Hi All,

INTRODUCTION
I have been following this post:

"Checkbox form to allow user to select query output fields"

(BIG THANKS TO ADezii AND ALL THE OTHER CONTRIBUTORS)

In a nut shell,
1. A user selects check boxes for the criteria he/she wants to see,
2. Using a combo box, they can choose the particular brand/family of products they want to see the above selected criteria for:

Expand|Select|Wrap|Line Numbers

解决方案

Hi All,

Funnily enough, I managed to solve part of the problem shorty after posting (Thanks zmbd for the edit).

I simply changed the where code to:

Expand|Select|Wrap|Line Numbers

HBB01:

I''m not really following what you are trying to do here.
You shouldn''t normally be creating and deleting tables in a well designed database.
The queries can be saved or created on the fly depending on what you are trying to do. The stored queries are held in the QueryDef Object (DAO) Office 2010 and these can be altered on the fly - this is something I used to do for a report.
What I do now, is create one parameter query based on the entire recordset, build my report, and open the report by passing either a filter or parameters.
Use parameters in queries and reports I''ve found this to much cleaner, easier to maintain, and more stable.

Hi zmbd,

Thank you for your response.

I shall have a read through the links you have sent me and see if I can work something out.

I shall post back if I find a solution or get stuck.

Thanks.

这篇关于从a创建和更新表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！