• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1058
  • Last Modified:

vba error 94 invalid use of null - how to find

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?
0
jsgould
Asked:
jsgould
1 Solution
 
peter57rCommented:
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.

Pete
0
 
jsgouldAuthor Commented:
thanks for the quick response!!!!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now