VBA与查询 [英] VBA versus Query
问题描述
您好，
我点击了无法打开更多数据库和系统资源
超出错误。知道这件事即将到来，但随着我接近完成
数据库，我希望它不会成为一个问题。
我的DB包括数百条独特的信息（原子表中
当然）。但是，我有许多多个查询需要
编译信息并进行各种计算，以便为报告和表单提供可行的
格式。
我提出的问题：
1）我应该有查询吗？使用
VB代码执行表单/报表本身或
2）我是否应该修改我的数据库设计以提高效率
现在，特定表单可能引用一个引用多个
查询和表格的查询。
感谢您的帮助！
B
-
通过AccessMonster.com发布消息
http://www.accessmonster.com/Uwe/For...ccess/200708/ 1
Hello,
I have hit the "Cannot open any more databases" and "System resource
exceeded" errors. Knew this was coming, but as I got closer to finishing the
database, I hoped it wouldn''t be an issue.
My DB consists of hundreds of unique pieces of information (in atomic tables
of course). However, I have many multiple queries that are required to
compile information and conduct various calculations to put it in a workable
format for reports and forms.
My posed question:
1) Should I have the "queries" execute on the forms/reports themselves using
VB code or
2) Should I rework my database design to improve effeciency
Right now a particular form may refer to a query that refers to multiple
queries and tables.
Thanks for your help!
B
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200708/1
推荐答案
bhipwell通过AccessMonster.com写道：
bhipwell via AccessMonster.com wrote:
您好，
我点击了无法打开更多数据库和系统资源
超出错误。知道这件事即将到来，但随着我接近完成
数据库，我希望它不会成为一个问题。
我的DB包括数百条独特的信息（原子表中
当然）。但是，我有许多多个查询需要
编译信息并进行各种计算，以便为报告和表单提供可行的
格式。
我提出的问题：
1）我应该有查询吗？使用
VB代码执行表单/报表本身或
2）我是否应该修改我的数据库设计以提高效率
现在，特定表单可能引用一个引用多个
查询和表格的查询。
感谢您的帮助！
B
Hello,
I have hit the "Cannot open any more databases" and "System resource
exceeded" errors. Knew this was coming, but as I got closer to finishing the
database, I hoped it wouldn''t be an issue.
My DB consists of hundreds of unique pieces of information (in atomic tables
of course). However, I have many multiple queries that are required to
compile information and conduct various calculations to put it in a workable
format for reports and forms.
My posed question:
1) Should I have the "queries" execute on the forms/reports themselves using
VB code or
2) Should I rework my database design to improve effeciency
Right now a particular form may refer to a query that refers to multiple
queries and tables.
Thanks for your help!
B
您可以在A97数据库中拥有32,768个对象。您可以一次打开1024个打开的
表。 （转到帮助，输入规格）
您是否打开与数据库的连接
set dbs = Currentdb
或recordsets
设置rst = dbs.Openrecordset
而不关闭它们或将对象设置为空？
You can have 32,768 objects in a A97 database. You can have 1024 open
tables open at a time. (Go to help, type Specifications)
Are you opening connections to a database
set dbs = Currentdb
or recordsets
set rst = dbs.Openrecordset
and not closing them or setting the object to nothing?
我在哪里卡住了现在是一个查询。如果我右键单击它并且选择设计，我会得到超出系统资源。不过，我可以在数据表中获得它的视图和SQL。这是一个使用其他查询的混乱查询，因此我可以使用b $ b填充报告。 （A2000）
解开这个可能是一团糟。我想我可能只是报告了
查询自己。
有什么想法吗？
B
-
留言通过 http://www.accessmonster.com
Where I am stuck right now is with a query. If I right click on it and
select design, I get "System resource exceeded." I can get it in datasheet
view and SQL, however. It is a messy query that uses other queries so I can
populate a report. (A2000)
Untangling this could be a mess. I was think I may just have the report make
queries for itself.
Any thoughts?
B
--
Message posted via http://www.accessmonster.com
8月15日上午8:31，bhipwell通过AccessMonster.com < u30281 @ uwe>
写道：
On Aug 15, 8:31 am, "bhipwell via AccessMonster.com" <u30281@uwe>
wrote:
您好，
我已经点击了无法打开更多数据库和系统资源
超出错误。知道这件事即将到来，但随着我接近完成
数据库，我希望它不会成为一个问题。
我的DB包括数百条独特的信息（原子表中
当然）。但是，我有许多多个查询需要
编译信息并进行各种计算，以便为报告和表单提供可行的
格式。
我提出的问题：
1）我应该有查询吗？使用
VB代码执行表单/报表本身或
2）我是否应该修改我的数据库设计以提高效率
现在，特定表单可能引用一个引用多个
查询和表格的查询。
感谢您的帮助！
B
-
留言通过AccessMonster.comhttp：//www.accessmonster.com/Uwe/Forums.aspx/databases发布-ms-access / 2007 ...
Hello,
I have hit the "Cannot open any more databases" and "System resource
exceeded" errors. Knew this was coming, but as I got closer to finishing the
database, I hoped it wouldn''t be an issue.
My DB consists of hundreds of unique pieces of information (in atomic tables
of course). However, I have many multiple queries that are required to
compile information and conduct various calculations to put it in a workable
format for reports and forms.
My posed question:
1) Should I have the "queries" execute on the forms/reports themselves using
VB code or
2) Should I rework my database design to improve effeciency
Right now a particular form may refer to a query that refers to multiple
queries and tables.
Thanks for your help!
B
--
Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/2007...
我也遇到过这么多次。由于你已经有了
它几乎完成了最简单的解决方案是用VBA代码替换你的查询
，因为这实际上并没有计入你的对象限制。
请记住，表格和查询计算的次数超过
数量限制，一次只是存在，并且每个有效参考额外计算
。
您应该能够通过执行任何查询或设置行数来报告
$ b $，通过
VBA消除几乎所有查询b查询。
I''ve run into that quite a few times as well. Since you already have
it almost done the easiest solution would be to replace your queries
with VBA code, as this does not really count toward your object limit.
Remember that tables and queries count more then once toward the
number limits imposed, once just to exist, and an additional count for
every active reference.
You should be able to eliminate just about all of your queries with
VBA through executing any queries or setting rowsources for report
queries.
这篇关于VBA与查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
