动态交叉表形式是否可行？ [英] Is a dynamic crosstab form possible?

问题描述

在A97中运行。


我在Access中没有收到很多关于Pivot表的响应。

数据透视表很不错，但是CrossTab也适用于我。


使用数据透视表，其中一个实际上是启动Excel进行数据查看。

我希望用户留在访问。创建动态交叉表查询

非常简单。问题是列数可能缩小或者b $ b增长取决于过滤器。


可以轻松打开交叉表查询。只需使用OpenQuery

命令。但是这限制了dbl-clicks和事件过程的使用。


可以创建一个可以调整列数更改/列的表单

名称更改基于交叉表？

解决方案

在Access中创建总动态表单并不是一个好主意。如果您的

愿意对表单或交叉表查询施加一些限制，那么您可以得到一个非常令人信服的结果

。最后，这一切都取决于你的确切需求。

有时，你开始时的语言选择（VB for Access）可能是你最糟糕的错误。恕我直言，这种语言是一种非常高级的语言，

不会像C ++那样提供引脚控制。但是要从头开始快速制作一个

应用程序，它比C ++好得多。


HTH

Martin

salad < oi*@vinegar.com在留言中写道

新闻：_E ***************** @ newsread4.news.pas.earthl ink.net。 ..

在A97中运行。


我没有收到很多关于在Access中保存数据透视表的响应。

数据透视表很不错，但是CrossTab也适用于我。


使用数据透视表，其中一个实际上是启动Excel进行数据查看。 />
我希望用户留在Access中。创建动态交叉表查询

非常简单。问题是列数可能缩小或者b $ b增长取决于过滤器。


可以轻松打开交叉表查询。只需使用OpenQuery

命令。但是这限制了dbl-clicks和事件过程的使用。


可以创建一个可以调整列数更改/列的表单

名称更改基于交叉表？

---- ==通过Newsfeeds.Com发布 - 无限制 - 无限制 - 安全Usenet新闻== ----
< a rel =nofollowhref =http://www.newsfeeds.comtarget =_ blank> http://www.newsfeeds.com 世界排名第一的新闻组服务！ 120,000多个新闻组

---- =东海岸和西海岸服务器农场 - 通过加密实现全隐私= ----

退房IN


即使列没有

数据，您也可以定义哪一列。通过将源查询正确格式化为十字

选项卡，您将无法更改名称和列数。


" salad" < oi*@vinegar.com在留言中写道

新闻：_E ***************** @ newsread4.news.pas.earthl ink.net。 ..

在A97中运行。


我没有收到很多关于在Access中保存数据透视表的响应。

数据透视表很不错，但是CrossTab也适用于我。


使用数据透视表，其中一个实际上是启动Excel进行数据查看。 />
我希望用户留在Access中。创建动态交叉表查询

非常简单。问题是列数可能缩小或者b $ b增长取决于过滤器。


可以轻松打开交叉表查询。只需使用OpenQuery

命令。但是这限制了dbl-clicks和事件过程的使用。


可以创建一个可以调整列数更改/列的表单

名称更改基于交叉表？

Martin写道：

总的动态表单创建并不是真的Access中的好主意。如果您的

愿意对表单或交叉表查询施加一些限制，那么您可以得到一个非常令人信服的结果

。最后，这一切都取决于您的确切需求。

好​​吧，交叉表查询给了我想要的结果。一个Pivot

表也是如此。数据透视表的问题在于记录源是隐藏在某个地方的，不适合更新或过滤

fly。交叉表的问题是列数可能会波动。

有时，您启动时的语言选择（VB for Access）可能是您的

最糟糕的错误。

我不同意。它部分地给了我我想要的东西。我认为Pivot表

和交叉表并没有完全正常运行。它们很可爱，但并不是真的很实际......部分实现了。


恕我直言，这种语言是一种非常高级的语言，
< blockquote class =post_quotes>
不会像C ++那样给出针点控制。但是从头开始快速制作一个

应用程序，它比C ++好得多。

如果你有一个庞大的程序员团队和很多钱和时间，然后

C ++是值得的。

HTH

Martin

"沙拉" < oi*@vinegar.com在留言中写道

新闻：_E ***************** @ newsread4.news.pas.earthl ink.net。 ..

>>在A97中运行。

我没有收到很多关于在Access中保存数据透视表的响应。
数据透视表很不错，但是CrossTab也适用于我。

使用数据透视表，实际上有人启动Excel进行数据查看。
我更喜欢用户留在Access中。创建动态交叉表查询非常简单。问题是列数可能会缩小或增长，具体取决于过滤器。

可以轻松打开交叉表查询。只需使用OpenQuery
命令即可。但是这限制了dbl-clicks和事件过程的使用。

是否可以创建一个可以根据交叉表调整列数更改/列
名称更改的表单？

---- ==通过Newsfeeds.Com发布 - 无限制 - 无限制 - 安全Usenet新闻== ----
< a rel =nofollowhref =http://www.newsfeeds.comtarget =_ blank> http://www.newsfeeds.com 世界排名第一的新闻组服务！ 120,000多个新闻组

---- =东和西海岸服务器农场 - 通过加密的总隐私= ----

Operating in A97.

I didn''t receive much of a response conserning Pivot tables in Access.
Pivot tables are nice, but a CrossTab will work for me too.

Using a Pivot table, one is actually launching Excel for data viewing.
I''d prefer the user stay in Access. Creating dynamic crosstab queries
is pretty simple. The problem is that the column count may shrink or
grow depending on the filter.

One can easily open up a crosstab query. Simply use the OpenQuery
command. But this limits the use of dbl-clicks and event procedures.

Can a form be created that can adjust to the column count changes/column
name changes based on a Crosstab?

解决方案

Total dynamic form creation is not really a good idea in Access. If your
willing to impose some limits to the form or crosstab query you can get a
pretty convincing result. In the end, it all depends on your exact needs.
Sometimes, your language choice(VB for Access) when you started can be your
worst mistake. IMHO, this language is a very high level language that
doesn''t give pin point control like for example C++. But for making an
application quickly from scratch its much better than C++.

HTH
Martin
"salad" <oi*@vinegar.comwrote in message
news:_E*****************@newsread4.news.pas.earthl ink.net...

Operating in A97.

I didn''t receive much of a response conserning Pivot tables in Access.
Pivot tables are nice, but a CrossTab will work for me too.

Using a Pivot table, one is actually launching Excel for data viewing.
I''d prefer the user stay in Access. Creating dynamic crosstab queries
is pretty simple. The problem is that the column count may shrink or
grow depending on the filter.

One can easily open up a crosstab query. Simply use the OpenQuery
command. But this limits the use of dbl-clicks and event procedures.

Can a form be created that can adjust to the column count changes/column
name changes based on a Crosstab?

----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----

Check out the "IN" clause

You will be able to define which column will be present even if there is no
data for the column. With proper formatting of the source query to the cross
tab, you will not have the name and number of columns change.

"salad" <oi*@vinegar.comwrote in message
news:_E*****************@newsread4.news.pas.earthl ink.net...

Operating in A97.

I didn''t receive much of a response conserning Pivot tables in Access.
Pivot tables are nice, but a CrossTab will work for me too.

Using a Pivot table, one is actually launching Excel for data viewing.
I''d prefer the user stay in Access. Creating dynamic crosstab queries
is pretty simple. The problem is that the column count may shrink or
grow depending on the filter.

One can easily open up a crosstab query. Simply use the OpenQuery
command. But this limits the use of dbl-clicks and event procedures.

Can a form be created that can adjust to the column count changes/column
name changes based on a Crosstab?

Martin wrote:

Total dynamic form creation is not really a good idea in Access. If your
willing to impose some limits to the form or crosstab query you can get a
pretty convincing result. In the end, it all depends on your exact needs.

Well, a crosstab query gives me the results I want. So does a Pivot
table. The problem with Pivot tables is that the recordsource is
stashed away someplace, not suitable to updating or filtering on the
fly. The problem with a crosstab is that the column count may fluctuate.

Sometimes, your language choice(VB for Access) when you started can be your
worst mistake.

I disagree. It gives me partially what I want. I think Pivot tables
and crosstabs aren''t fully functional. They are cute, but not really
practical...partially implemented.

IMHO, this language is a very high level language that

doesn''t give pin point control like for example C++. But for making an
application quickly from scratch its much better than C++.

If you have a large team of programmers and lots of money and time, then
C++ is worthwhile.

HTH
Martin
"salad" <oi*@vinegar.comwrote in message
news:_E*****************@newsread4.news.pas.earthl ink.net...

>>Operating in A97.

I didn''t receive much of a response conserning Pivot tables in Access.
Pivot tables are nice, but a CrossTab will work for me too.

Using a Pivot table, one is actually launching Excel for data viewing.
I''d prefer the user stay in Access. Creating dynamic crosstab queries
is pretty simple. The problem is that the column count may shrink or
grow depending on the filter.

One can easily open up a crosstab query. Simply use the OpenQuery
command. But this limits the use of dbl-clicks and event procedures.

Can a form be created that can adjust to the column count changes/column
name changes based on a Crosstab?

----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----

这篇关于动态交叉表形式是否可行？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！