vba error 94 invalid use of null - how to find

Posted on 2006-04-11
Last Modified: 2008-03-06
A very large vba program, processing thousands of records. Somewhere in the vba I'm getting this error.
I'm looking for a way to trap or display the statement that is producing this error. Is this info stored anywhere
where it is accessible?
Question by:jsgould
    LVL 77

    Accepted Solution

    Hi jsgould,
    In any module in design view go to Tools>options and on the general tab make sure you have 'Break On All Errors' selected.
    That will cuase the code to be high;ighted on the line that causes the error.


    Author Comment

    thanks for the quick response!!!!

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    733 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

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now