Solved

No Error on Compile

Posted on 2006-11-27
3
400 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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

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.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

734 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