A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Error while running Access MDE



 
 
Thread Tools Display Modes
  #1  
Old June 21st, 2004, 03:30 AM
Hemil
external usenet poster
 
Posts: n/a
Default 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.
Ads
  #2  
Old June 21st, 2004, 07:40 AM
Tony Toews
external usenet poster
 
Posts: n/a
Default 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  
Old June 21st, 2004, 01:03 PM
Douglas J. Steele
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:54 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 OfficeFrustration.
The comments are property of their posters.