Computer Learning Zone CLZ Access Excel Word Windows

If you can't explain it simply, you don't understand it well enough.

-Albert Einstein
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to ABCD Core Part 6    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
VBA Programming
Eduardo Benaim 
     
4 years ago
The version of the ABCD database that I have does not display error messages when programming. I remember you said you usually turn those off when you work.  I need to have all type of warnings ON when programming because I make mistakes.  How do you turn On/off.  In particular, If I'm running a sub and there is a problem there, Access is not telling me in which line the problem is. So debugging is a lot harder.
Thank you
Scott Axton  @Reply  
        
4 years ago
Beginner 1 lesson 7 - Confirm record changes

Also Developer 1 - Docmd.SetWarnings
Eduardo Benaim OP  @Reply  
     
4 years ago
I followed your instructions with no Luck
If I run this simple test VBA in the database I'm working on, I am not getting an error message:

Private Sub testBtn_Click()
x = ""
DoCmd.Print x
End Sub

In a new Database I get the error prompt: " Invalid Use of Null"
In the Database I'm working on the Message does not show (it does nothing)
I have no Set warnings off or Echo offs in the data base
Any Clues to how these errors are being lost?
How do I turn these error banners on?
Scott Axton  @Reply  
        
4 years ago

Did you make the changes that I indicated it THIS POST?

If those are turned on you might want to do a global search for .SetWarnings.
Open your code window.  Type Ctrl-F.  Choose the option for Current Project.
Remember if you have any DoCmd.SetWarnings False you need to follow it up with DoCmd.SetWarnings True after your done doing the procedures you want warnings suppressed for.

Honestly though, that error you just mentioned above, should come up whether or not you have those setting on or off.
If you are just trying something to force an error that will work because there isn't a DoCmd.Print method.

If you are attempting to get x to display to the Immediate window you can use Debug.Print x and that would work.

The Client Settings under options and .SetWarnings False are the only two error suppression that I know of.  Echo just turns off all out put to the screen.


Scott Axton  @Reply  
        
4 years ago
You might Compile your database and run through the Troubleshooter if neither of those help.
Kevin Robertson  @Reply  
          
4 years ago
Make sure Use Access Special Keys is checked on as this seems to suppress error messages.
Kevin Robertson  @Reply  
          
4 years ago

Eduardo Benaim OP  @Reply  
     
4 years ago
Scott and Kevin.  
Thank you very much for all your suggestions.

The Culprit is the  "Use Access Special Keys".

Yes.  I was trying to force error messages so I could determine why they were not showing up.

Scott: I had made sure I did not have any SetWarnings or echos in the way.

Kevin: Once I turned on the "Use Access Special Keys" all started working Fine.

I think this is an important Finding because part of the Security protocol that Rick implements is turning this Off.

If anyone is Working with ABCD they need to check this If they want error messages while programming.

Scott Axton  @Reply  
        
4 years ago
Glad you found the solution.

Kevin - I missed that one!  Glad I'm part of this team...   It sometimes takes the whole village.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in ABCD Core Part 6.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 5/2/2026 4:29:53 AM. PLT: 1s