VBA and Access97

C

Chris

I'm working with Access 97.
In a form, I have a listbox based on a query which calls a function I have
created.
This function calls VBA functions like "Mid", "Instr" or "Len".
When I open this form on my computer where Access is installed every thing
is ok.

If I open this form on a computer with only Access runtime, list is empty
and my function is not called. It seems that the query is not running at
all.
If a delete the call to this function in my query, everything is ok.

Could you help me please.
Chris
 
M

MDP

You need to check your "references". One the development computer, open the
MDB, and then view some VBA code (any will do), then select Tools/References.
Note down all the references that have a check next to them. These are the
dlls, ocx's etc. that are needed for the MDB to run correctly. Now,
unfortunately, to transfer these files and references to a runtime version
computer (one that does not have full Access) you need to include them with
the distribution files for the application.
 
A

Albert D. Kallal

This usually means you version of JET is miss-matched.

You need to install on your developer pc:

office sr2b update
jet35sp3.exe update

The above also needs to be installed on the target pc also.
 
C

Chris

Thanks Albert,

I have tried this, but I get to problem :

1) I'm unable to install Office sr2b on target pc. Update doesn't work. (Sp1
doesn't work too)
2) I have a custom workgroup file and with this install, I'm unable to join
to it. He says to me that he successfully join my custom workgroup but it
doesn't.

Could you help me more ?
chris
 
C

Chris

I have already checked all of my references and all of them are added with
my distribution files.
 
Top