Format() & Left() failing in query; only in runtime

[Max Moor]

Hi All,

I have an Access 2002 app. When I run it in full Access, in my
development environment, everything is fine. It's still fine after making an
MDE file.

I use SageKey's wizard to create a distribution package. Once
installed, there are a couple of queries that don't work. In fact they fail
quite silently, leaving their associated listbox or subform empty.

I've tracked the problem down to having Format() or Left() calls in the
queries. If I remove them, although the data isn't displayed as pretty as
I'd like, the runtime version works just fine. Something in the runtime libs
isn't working with those function calls in queries right.

Does this sort of symptom sound familiar to anyone? I'm stuck.

Regards,
Max

 

[Jerry Whittle]

Most likely a reference is missing or broken. I don't know enough about
Sagekey to guess if it isn't packaging up the right files or not, but that's
where I'd start looking.