If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Error while running Access MDE
Hello Friends,
I am having a problem running an Access MDE file. When I select a value in a particular combo box, I get the following error message: The expression After Update 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. This error doesn't show up while trying to use the same combo box while using the .mdb. It only occurs in the mde version which has been recently made from the latest mdb. Any ideas?? Thanks & Regards, Hemil. |
#2
|
|||
|
|||
Error while running Access MDE
"Hemil" wrote:
The expression After Update 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. This error doesn't show up while trying to use the same combo box while using the .mdb. It only occurs in the mde version which has been recently made from the latest mdb. Probably a references problem showing itself because you have a VBA function in that query such as left, right, mid or such. Do you have any references besides the basic three? Are you sure you need them? Write down the path and name of the extra ones, delete from the references list and Compile and Save All. Keep any necessary references and ensure they are distributed to the target system. For a very detailed page on reference problems see http://members.rogers.com/douglas.j....nceErrors.html Ctrl+G will take you into the Debug/Immediate window. Then click on Tools on the menu bar and References. The Access 97 default references a Visual Basic for Applications Microsoft Access 8.0 Object Library Microsoft DAO 3.5x Object Library The Access 2000 default references a Visual Basic for Applications Microsoft Access 9.0 Object Library OLE Automation Microsoft ActiveX Data Objects 2.1 Library or Microsoft DAO 3.6 Object Library The Access 2002 default references when the MDB is created in Access 2000 format a Visual Basic for Applications Microsoft Access 10.0 Object Library OLE Automation Microsoft ActiveX Data Objects 2.1 Library The Access 2002 default references when the MDB is created in Access 2002 format a Visual Basic for Applications Microsoft Access 10.0 Object Library OLE Automation Microsoft ActiveX Data Objects 2.5 Library. The Access 2003 default references when the MDB is in A2000 format are Visual Basic for Applications Microsoft Access 11.0 Object Library OLE Automation Microsoft DAO 3.6 Object Library Microsoft ActiveX Data Objects 2.1 Library The Access 2003 default references when the MDB is in A2002/A2003 format are Visual Basic for Applications Microsoft Access 11.0 Object Library OLE Automation Microsoft DAO 3.6 Object Library Microsoft ActiveX Data Objects 2.5 Library Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm |
#3
|
|||
|
|||
Error while running Access MDE
Just a comment: you can only do what Tony's suggesting on the original MDB.
You'll need to determine where each of the referenced files is, and what version each file is on a workstation where it works. You then need to check that each of those files exist in the same location (and is the same version) on all of the workstations in question. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (No private e-mails, please) "Tony Toews" wrote in message news "Hemil" wrote: The expression After Update 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. This error doesn't show up while trying to use the same combo box while using the .mdb. It only occurs in the mde version which has been recently made from the latest mdb. Probably a references problem showing itself because you have a VBA function in that query such as left, right, mid or such. Do you have any references besides the basic three? Are you sure you need them? Write down the path and name of the extra ones, delete from the references list and Compile and Save All. Keep any necessary references and ensure they are distributed to the target system. For a very detailed page on reference problems see http://members.rogers.com/douglas.j....nceErrors.html Ctrl+G will take you into the Debug/Immediate window. Then click on Tools on the menu bar and References. The Access 97 default references a Visual Basic for Applications Microsoft Access 8.0 Object Library Microsoft DAO 3.5x Object Library The Access 2000 default references a Visual Basic for Applications Microsoft Access 9.0 Object Library OLE Automation Microsoft ActiveX Data Objects 2.1 Library or Microsoft DAO 3.6 Object Library The Access 2002 default references when the MDB is created in Access 2000 format a Visual Basic for Applications Microsoft Access 10.0 Object Library OLE Automation Microsoft ActiveX Data Objects 2.1 Library The Access 2002 default references when the MDB is created in Access 2002 format a Visual Basic for Applications Microsoft Access 10.0 Object Library OLE Automation Microsoft ActiveX Data Objects 2.5 Library. The Access 2003 default references when the MDB is in A2000 format are Visual Basic for Applications Microsoft Access 11.0 Object Library OLE Automation Microsoft DAO 3.6 Object Library Microsoft ActiveX Data Objects 2.1 Library The Access 2003 default references when the MDB is in A2002/A2003 format are Visual Basic for Applications Microsoft Access 11.0 Object Library OLE Automation Microsoft DAO 3.6 Object Library Microsoft ActiveX Data Objects 2.5 Library Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm |
Thread Tools | |
Display Modes | |
|
|