Sometimes we can face the situation that wasn't expected and discovered that there is no problem except configuration.

 

 Todays I faced the louzy situation, you need to check below URL

 

http://www.idautomation.com/kb/vba-compile-error.html

Most likely, the application has lost the reference to an object or type library resulting in the above error when using Barcode Macros & Native VBA Functions. The problem may be resolved as follows:

  1. Open the database or application.
  2. Open a module in Design view or press ALT+F11 to switch to the Visual Basic Editor.
  3. On the Tools menu, click References.
  4. Clear the check box for the type library or object library marked as "Missing:"

An alternative to removing the reference is to restore the referenced file to the path specified in the References dialog box. If the referenced file is in a new location, clear the "Missing:" reference and create a new reference to the file in its new location.

Microsoft has documented this issue: VBA Functions Break in Database with Missing References

 

반응형

'VBA' 카테고리의 다른 글

cdbl(Convert to a double)  (0) 2012.12.28
벽에 부딪힌 vba  (0) 2012.08.13
집중력의 한계  (0) 2012.04.30
where to download ccrp timer  (0) 2012.04.25
요즘들어 vba 프로그래밍이 즐겁다  (0) 2012.04.22

+ Recent posts