表单缓慢保存并进入设计视图 [英] Forms Slow to Save and go into Design View

问题描述

这让我绝对疯狂！每次我想从设计视图中进行非常复杂的设计视图或在设计视图中修改后保存它，需要花费很长时间才能保存。我能想到的是，我在表格中提出了所有疑问，例如如果我有一个列表框，我将使用VBA listbox.rowsource =" query"将查询保存在列表框的行源中。什么是使表格更快（进入和退出设计视图）的最佳方法???


请帮助...然后我去秃头拉我的头发...


当我从设计视图中保存时某些表单崩溃...灾难性故障它说，灾难性的，我从来不知道Access有如此深刻的情感，但似乎我已经让它感到恐慌和害怕，我不认为它会在更多的灾难之后留在我的电脑上。

Hi,
This is driving me absolutley insane! Every time I want to take a very complex from into design view or save it after amending it in design view, it takes ages to save. All I can think of is that I make all my queries in the Form e.g. if I have a list box I will have saved the query in the row source of the list box instead using VBA listbox.rowsource = "query". What would be the best way to make the forms faster (to go into and come out of design view)???

Please help... before I go bald pulling my hair out...

Some forms just Crash when I save from Design View... "Catastrophic Failure" it says, Catastrophic, I never knew Access had such depth of emotion, but it seems I have made it panicked and afraid, I don''t think it will stay on my computer after many more catastrophies.

推荐答案

@iheartvba


您是否尝试过Compact和Repair？

此外，尽量不要太大声点击，你可能会吓到这个可怜的小野兽！


吉姆

@iheartvba
Have you tried Compact and Repair?
Also, try not clicking too loudly, you might be scaring the poor little beastie!

Jim

是的，很多时候我都去了紧凑和修理的路线，我有，但似乎Access已被侵犯太多次它遭受了太多的灾难，无政府状态，战争，饥荒，痛苦和痛苦然后它可能裸露，我现在只是要改造通过VBA表单和提供SQL而不是将它们放在表单上，​​它确实使表单更快，但它需要很长时间来修改表格。我的建议：总是永远，从Vba提供表单查询，如果可能的话，不要将它永久保存在行源中。

yes, many many a time have I gone down the route of compact and repair, I have, but it seems like it Access has been violated too many times it has suffered too many catastrophies, anarchies, wars, famines, pain and suffering then it could bare, I am now just going to revamp the forms and feed them SQL via VBA instead of putting them on the forms, it does make the forms faster, but it takes a long time to revamp the form. My advice: Always Always Always, feed your forms queries from Vba don''t save it permanently in the row sources if possible.

@iheartvba < br $> b
$ b我听到了'你好。


Jim

@iheartvba
I''m hearin'' ya.

Jim

这篇关于表单缓慢保存并进入设计视图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！