• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6091
  • Last Modified:

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

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
pattihill
Asked:
pattihill
  • 4
  • 4
  • 2
  • +1
1 Solution
 
CodeCruiserCommented:
Is it a web application or a Windows Forms application?
0
 
pattihillAuthor Commented:
Windows.  The program is CWorks ... a maintenance management program.
0
 
CodeCruiserCommented:
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
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
TextReportCommented:
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
 
pattihillAuthor Commented:
Thank you, I will try that!
0
 
Simon BallCommented:
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
 
Simon BallCommented:
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
 
pattihillAuthor Commented:
That could be it, Sudonim ...  I will check that out first thing Monday morning and I'll let you know.
Thanks!
0
 
Simon BallCommented:
good luck.  hope its that.
0
 
pattihillAuthor Commented:
Thanks, Sudonim!  This worked!
0
 
Simon BallCommented:
wohooo!

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

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

  • 4
  • 4
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now