Solved

No Error on Compile

Posted on 2006-11-27
3
399 Views
Last Modified: 2012-08-14
I am using the following code to compile my vba code by clicking on a button.

Private Sub cmdCompile_Click()

    DoCmd.RunCommand acCmdCompileAllModules
    DoCmd.RunCommand acCmdCompileAndSaveAllModules

End Sub

The code is running, but it is not throwing debug errors when I have problems with my code.  Is there an alternative way I should be writing this?  

I get an error with my code when I use the menu drop down - Debug/Compile, but not when I click the button I created.
0
Comment
Question by:jamesdean666
[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
3 Comments
 
LVL 34

Accepted Solution

by:
jefftwilley earned 500 total points
ID: 18022495
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 18022501
when u debug/compile manually, what line of code does it fail on?

0
 

Author Comment

by:jamesdean666
ID: 18023435
the code never failed.. it just never indicated there were errors which I purposely placed in the code to test.

0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

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 earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

735 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