Problem with MDE file

[Barry]

I have a bit of code that, at a button's On Click event,
runs a make-table query. On my development .mdb, this
works fine. But on an MDE version, (which has different
data in the table), I get the following error message:

"The expression On Click you entered as the event
property setting produced the following error: Data type
mismatch in criteria expression.

* The expression may not result in the name of a macro,
the name of a user-defined function, or [Event Procedure].

* There may have been an error evaluating the function,
event, or macro."

Could someone explain to me what has happened, and what I
need to do to correct this? Thanks in advance to anyone
who replies.

 

[david epsom dot com dot au]

This is a fairly generic error message, which could
mean several things.

You could have a bad reference.
(In an MDB you could have code which won't compile)
(You could have code in the 'Break' mode.)
You could have a divide by zero error,
You could have a string value in a numeric cast, or
You could have a Null value in your data

Look for bad data and bad references.

(david)

 

[Roy Goldhammer]

Whell barry

The diffrence as you said was on the data on the mde.

Try creating an mde from the mdb with the same data and check if it works
fine.

If it works fine try putting the data that make trouble on the mde on your
mdb and diterme then if there is a problem

Good luck