Solved

Compile Error in hidden module:

Posted on 2015-01-29
2
397 Views
Last Modified: 2015-02-17
when you add a form or report in Access from another database, if you get the error "Compile Error in hidden module:" what could be the issue? (it worked before adding the form/report).
0
Comment
Question by:25112
[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
2 Comments
 
LVL 24

Accepted Solution

by:
Bitsqueezer earned 375 total points
ID: 40579186
Hi,

I would check the VBA references in the original database, probably there is a reference to a module which you do not have in your current database. Most likely it is a reference like ADO library which is not in the list of references by default but often used, but it could of course be any other non-default reference. Look into the code of the imported form and check all declarations like "Dim rs As ADODB.Recordset" which would give you the hint that here ADO is needed, similar for any other kind of object which needs an external reference (like MS Office library which is i.e. needed for file dialogs etc.).

Cheers,

Christian
0
 
LVL 57

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 125 total points
ID: 40579471
You might also have a conflict in name; you have a module or procedure that is named the same as what is in the hidden project.

Jim.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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 Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

756 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