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
Solved

Compile Error in hidden module:

Posted on 2015-01-29
2
394 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
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: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone 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

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
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…

856 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