在键入文本时,VBA for Access 2007崩溃 [英] VBA for Access 2007 crash while typing text
问题描述
问候所有,
我来到这里相当困惑的是一个没有任何意义的问题。简而言之,下面是我的问题的详细信息。
背景:
- 为复杂的自定义数据分析和统计报告生成编写的VBA代码数据库
- 我离开后代码必须由老板维护,因为我只是暂时在公司(没有IT部门),因此所有工作都在VBA中。
- 在Windows上的Access 2007中进行开发工作Vista机器。
基本代码结构:
- 1 gui(form)后面有额外代码来处理数据分析逻辑
- 3个类来表示正在分析的各种形式的数据
问题:
- 在输入代码以完成if语句的内部时,程序只是冻结然后Access重新启动。
- 如果我正在使用的语句是第三级也是最后一级嵌套if语句结构。不应该有所作为,但你永远不会知道。
- 程序崩溃时没有生成或给出错误代码。
我可以根据需要提供代码示例,并解释一些流经系统的数据。非常感谢能帮助我的人。
Stephen Carlson
Greetings all,
I come here rather perplexed by a problem that doesn't make any sense. To make a long story short, below are the details of my problem.
Background:
- VBA code being written for custom data analysis and statistical report generation for a complex database
- code must be maintainable by boss after I leave as I'm only at the company temporarily (no IT department), so all work is in VBA.
- development work being done in Access 2007 on a Windows Vista machine.
Basic code structure:
- 1 gui (form) with extra code behind to handle logic of data analysis
- 3 classes to represent various forms of data being analyzed
Problem:
- while typing in code to complete the internals of an if statement, the program simply freezes up and then Access restarts.
- if statement I'm working in is the third and final level of a nested if statement structure. Shouldn't make a difference, but you never know.
- no error code is generated or given when the program crashes.
I can provide a code sample as needed, as well as explaining some of the data flowing through the system.
Many thanks to anyone who can help me.
Stephen Carlson
推荐答案
< span style ="font-family:Arial">从来没有弄清楚数据库出了什么问题,设法找到解决办法。
我最终做的是创建一个新的db文件并导入我需要旧的db文件中的表和VBA代码。希望这可以帮助遇到此问题的其他任何人。
这篇关于在键入文本时,VBA for Access 2007崩溃的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!