andy_booth
asked on
VBA Code works in MDB but not MDE
For some strange reason, part of my application doesn't work as an mde, but it works fine on the same machines as an mdb.
When the button is pushed the error shown says as follows.
"The expression On Click you entered as the event property setting produced the following error."
*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
I will admit there is quite a bit of code under the button, but as it works fine within the MDB, the DB compiles etc, so why would this not work when made into an MDE?
Hope someone can give a quick answer on this one, I dont want to have to give people the MDB file.
Thanks
When the button is pushed the error shown says as follows.
"The expression On Click you entered as the event property setting produced the following error."
*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
I will admit there is quite a bit of code under the button, but as it works fine within the MDB, the DB compiles etc, so why would this not work when made into an MDE?
Hope someone can give a quick answer on this one, I dont want to have to give people the MDB file.
Thanks
post the erring codes
<the DB compiles etc, so why would this not work when made into an MDE?>
it all depends in what the codes is supposed to do.
remember that in an .mde file, for one, you can not change the design/property of form, report.
it all depends in what the codes is supposed to do.
remember that in an .mde file, for one, you can not change the design/property of form, report.
ASKER
Hmm, its quite a lot of code, however, I have just noticed that this part of the system uses ado rather than dao. Could that make a difference?
if the codes are running in .mdb it should also run in the .mde version, as long as it does not change any property of objects that the design option is not available in an .mde file
ASKER
Yes, I am aware of this.
As a test I am going to re-write the ADO connection into a DAO one to see if it makes any difference.
As a test I am going to re-write the ADO connection into a DAO one to see if it makes any difference.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I have set my own solution as the answer, just in case anyone else is search for this problem.