Turn off automatic compile

Posted on 2006-06-14
Last Modified: 2010-05-18
Can I to turn off the automatic check on vba code.  I want to be able to compile when I say and not to get the irritating message compile error when I move away from the line to fetch something.  Even better would be the text to show red but no messaqe
Question by:Mike_Leggett
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
  • 2

Accepted Solution

fefo_33065 earned 250 total points
ID: 16903634
IN vb editor:

Tools > Options > uncheck "Auto Syntax check"
LVL 65

Expert Comment

ID: 16903637
in vba window
go to Tools/Options

and play away!!!!!!!!
LVL 65

Expert Comment

ID: 16903652
fefo, how many secs do u think u beat be by - both sametime, just a matter of secs, wow

Expert Comment

ID: 16903692
ha,ha! Don't know...
but I went to vba editor to find out myself then came back to answer!
LVL 65

Expert Comment

ID: 16903858
damn, I need some go faster stripes on my keyboard

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MS Access - Autofill field with item description 6 53
Outlook Automation in Access Using "Find" 2 59
Excel graph in access report 1 33
SUBFORM on ACCESS 2013 8 35
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
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, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

739 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