error from runtime 2000

[Patrick]

I have an acess 200 database, i get no errors when i run either the mdb or
mde versions when i run it from the full version of access. however, when i
run either from the 'runtime' version of 2000 i get the folloiwng error, "The
expression On lost focus you entered as the event property setting produced
the following error: invalid use of null", why does this error only occur
when using runtime????

 

[Allen Browne]

You are looking for a line that assigns a value (from a control or a field
or possibly a property) to a VBA variable that is not a variant (such as a
Number or Date or String, or a function that accepts these kinds of
arguments only.)

Since you know what routine is causing the problem, it might make sense to
add labels to the lines (like the old BASIC line numbers - 10, 20, 30, ...)
Include an error handler, and log the error number, message and ERL to a
table. This will give you information on which line generated the error.

If error logging is new, you could use this one:
http://allenbrowne.com/ser-23a.html
passing ERL as one of the parameters.

 

[Patrick]

thanks allen, i will try this path

You are looking for a line that assigns a value (from a control or a field
or possibly a property) to a VBA variable that is not a variant (such as a
Number or Date or String, or a function that accepts these kinds of
arguments only.)

Since you know what routine is causing the problem, it might make sense to
add labels to the lines (like the old BASIC line numbers - 10, 20, 30, ...)
Include an error handler, and log the error number, message and ERL to a
table. This will give you information on which line generated the error.

If error logging is new, you could use this one:
http://allenbrowne.com/ser-23a.html
passing ERL as one of the parameters.