Solved

WEIRD Internal Error Access 2010

Posted on 2011-03-17
8
230 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
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.

911 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

22 Experts available now in Live!

Get 1:1 Help Now