Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

No Error on Compile

Posted on 2006-11-27
3
Medium Priority
?
406 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
3 Comments
 
LVL 34

Accepted Solution

by:
jefftwilley earned 2000 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

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Question has a verified solution.

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

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…
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

824 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