Solved

WEIRD Internal Error Access 2010

Posted on 2011-03-17
8
231 Views
Last Modified: 2012-05-11
This is one of the weirdest things I've seen Access do (and I've seen a lot):

Access must have $&%#!## up something internally in the accdb file, 'cos when I run it or try to compile it, it tells me that certain OnGotFocus subs don't match the description of the event or are duplicated :O

I've triple checked everything, and the Sub parameters are correct and they are not duplicated :O

I'm completely flabbergasted :O

Anyone has any idea???

Error when RunningError when compiling
0
Comment
Question by:Hikarus
  • 4
  • 2
8 Comments
 
LVL 75
ID: 35160550
Can you upload the db ?

Also ... the mods are likely to be noticing your language ... not really appropriate here.

mx
0
 

Author Comment

by:Hikarus
ID: 35163367
mmm... sorry about the language :(  I was really P**** off yesterday :)

can't upload the file. It's almost 15Mb :O
0
 

Author Comment

by:Hikarus
ID: 35163776
I fixed it erasing ALL THE CODE, relinking each object with new routines, and pasting back the routine codes. SAD :(
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 57
ID: 35165194

 In the future, I would try a /decompile or better yet, creating a fresh DB and importing evetyhing into it.

JimD.
0
 
LVL 75
ID: 35166886
So, the issue is resolved ?

mx
0
 

Accepted Solution

by:
Hikarus earned 0 total points
ID: 35484257
I fixed it removing all the subs, and re-linking them from scratch to the controls.
veeery weird :(
0
 

Author Closing Comment

by:Hikarus
ID: 35510810
It just worked :)
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

806 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