Solved

The expression OnClick you entered as the event property setting produced the following error ...

Posted on 2009-04-07
11
5,147 Views
Last Modified: 2012-05-06
I have a user who is running an application that uses an Access database.  When performing a function on one computer she receives the below error, but on a different computer she does not.  The database is shared by both computers.  Does anyone have any suggestions?

"The expression OnClick 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."
0
Comment
Question by:pattihill
  • 4
  • 4
  • 2
  • +1
11 Comments
 
LVL 83

Expert Comment

by:CodeCruiser
Comment Utility
Is it a web application or a Windows Forms application?
0
 

Author Comment

by:pattihill
Comment Utility
Windows.  The program is CWorks ... a maintenance management program.
0
 
LVL 83

Expert Comment

by:CodeCruiser
Comment Utility
You chose the wrongs zones i guess. If its a third party app then try to find the proper zone and also try the vendor's website.
0
 
LVL 28

Expert Comment

by:TextReport
Comment Utility
The error message is very much a standard access error message, can you please confirm if the form in question is being opened in Microsoft Access and if so what version.

If this is Access and it works on one PC but not another it is normally a references problem, go into a module and go to the Tools Menu References and see if any that are ticked have the word MISSING in front.

Cheers, Andrew
0
 

Author Comment

by:pattihill
Comment Utility
Thank you, I will try that!
0
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 
LVL 15

Expert Comment

by:Simon Ball
Comment Utility
could well be that the acces db is corrupt.

this happens from time to time.

can you get into VB from form design and try a debug?
0
 
LVL 15

Accepted Solution

by:
Simon Ball earned 500 total points
Comment Utility
also i found recently a robust access app i look after was getting the same error on one newly built pc...

afer days of recompiling, exporting objects, compacting and repairing, copying and rebuilding the offending form...

i realised that the machine had been built with access xp and access 2007... once i opened the db in 2007 instead of XP it didn;t show the error... so the fault must have been with the install of Access on that specific machine.. and not with the MDB file...
1
 

Author Comment

by:pattihill
Comment Utility
That could be it, Sudonim ...  I will check that out first thing Monday morning and I'll let you know.
Thanks!
0
 
LVL 15

Expert Comment

by:Simon Ball
Comment Utility
good luck.  hope its that.
0
 

Author Closing Comment

by:pattihill
Comment Utility
Thanks, Sudonim!  This worked!
0
 
LVL 15

Expert Comment

by:Simon Ball
Comment Utility
wohooo!

glad my 3 days of toil has saved you some time!
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

This article describes some very basic things about SQL Server filegroups.
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now