access runtime error

[kurt.bilteryst]

Hello,

I'm having some difficulties with the use of the functions left($), right($)
and mid($) in combination with the access runtime environment.
I want to use these functions to do some string manipulations but i don't
know what i'm doing wrong. With access2000 they work perfect, but with access
runtim i get thet error "Execution of this application has stopped due to a
run-time error"
I checked the references i use :
. visual basic for applications
. access 9.0 object library
. ole automation
. microsoft acitveX data objects 2.1 library
. dao 3.6 object library

Can anyone help me with this problem ?

Thanx a lot.

Kurt

 

[Gijs Beukenoot]

(e-mail address removed) was zeer hard aan het denken :

Hello,

I'm having some difficulties with the use of the functions left($), right($)
and mid($) in combination with the access runtime environment.
I want to use these functions to do some string manipulations but i don't
know what i'm doing wrong. With access2000 they work perfect, but with access
runtim i get thet error "Execution of this application has stopped due to a
run-time error"
I checked the references i use :
. visual basic for applications
. access 9.0 object library
. ole automation
. microsoft acitveX data objects 2.1 library
. dao 3.6 object library

Can anyone help me with this problem ?

Thanx a lot.

Kurt

How do you know they are caused by the right/left/mid functions? Do you
have an error routine that tells you so?

Besides that, I have seen 'strange' errors in applications that
sometimes related back to a missing library/reference on the target
machine. Are you sure all libraries are installed on the target
machine?