Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


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

Posted on 2016-11-03
Medium Priority
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.
Question by:Fritz Paul
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
LVL 53

Accepted Solution

Ryan Chong earned 1000 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.

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.
LVL 18

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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.


Author Comment

by:Fritz Paul
ID: 41873624
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.
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.


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.
LVL 18

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
LVL 58

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 1000 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.


Author Comment

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

Author Closing Comment

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

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

688 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