Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

WEIRD Internal Error Access 2010

Posted on 2011-03-17
8
Medium Priority
?
237 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
LVL 58
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
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…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

662 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