Solved

Access 2010 VBA Editor stopped say where or what the error is

Posted on 2016-11-03
10
41 Views
Last Modified: 2016-11-07
The VBA editor used to say what the error in the code was and indicated the point where it occurred.
It has stopped doing this.
Now it just gives an error message that says "Error in Sub ?????????".
I must have changed a setting, but I can't find it.
Please help.
0
Comment
Question by:Fritz Paul
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 2
  • 2
  • +1
10 Comments
 
LVL 52

Accepted Solution

by:
Ryan Chong earned 250 total points
ID: 41873439
Now it just gives an error message that says "Error in Sub ?????????"
is that mean you have an error handling in your codes? so when an error was detected, it prompts out that error and exit your subroutine without actually causing your program to crash and break.
0
 

Author Comment

by:Fritz Paul
ID: 41873443
Ryan, no the execution stops and I get the error message that only says there was an error and names the routine in which the error occurred, but does not say what the error was like an error code. It also does not say in which line the error occurred.
Previously the error message always said what caused the error and highligted the line of code where the error is.
0
 
LVL 17

Expert Comment

by:John Tsioumpris
ID: 41873445
Have you tried to Debug-->Compile to see if you get a  more meaningful error...
If no luck with this then
1st  Compact & Repair
2nd Decompile
3rd  check if you have any ActiveX on you form (i guess)
4th make a new database and import everything from the old one
Unless there is a corruption you also get these kind of errors when you have forgot something that you have deleted it on the form but you use it in the code
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

Author Comment

by:Fritz Paul
ID: 41873624
Thanks,
I will keep on testing and trying to find the fault.
Up to now I don't find anything wrong.
I have compacted and repaired,
I do not have ActiveX
I have Decompiled
It is a big database with many queries, forms, reports and Macros. I will have to try to copy over on the weekend.
Thanks so far.
0
 
LVL 58
ID: 41873789
<<no the execution stops and I get the error message that only says there was an error and names the routine in which the error occurred, but does not say what the error was like an error code. >>

 A screen shot would be good.

Jim.
0
 

Author Comment

by:Fritz Paul
ID: 41873797
This is what I have at the moment. Does that help?
The screenshot come from different databases. It seems to be only this database that has the problem. The others seem normal.
"Use Access special keys under options is selected in both cases.
  As is and as expected.
0
 
LVL 17

Expert Comment

by:John Tsioumpris
ID: 41873799
I am pretty sure that you have a control with faulty ControlSource....probably pointing to a faulty/changed/missing function
0
 
LVL 58

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 250 total points
ID: 41873854
That error is coming from Access, not VBA (note the title).

Put a stop in the forms OnError event and you can see the error that's occurring.

As John said, something in the form, not VBA code.

Jim.
0
 

Author Comment

by:Fritz Paul
ID: 41874740
Thanks so far guys. I will check it out over the weekend.
0
 

Author Closing Comment

by:Fritz Paul
ID: 41877542
Embarrasment.
After all my efforts, I found that there is error handling which results in the displayed message.
Thanks.
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question