Google Answers Logo
View Question
 
Q: Issuues with immediate window in Access 2003 ( No Answer,   3 Comments )
Question  
Subject: Issuues with immediate window in Access 2003
Category: Computers > Programming
Asked by: bdken-ga
List Price: $5.00
Posted: 21 May 2005 16:38 PDT
Expires: 20 Jun 2005 16:38 PDT
Question ID: 524178
I was big user of Access 2, so I am a bit rusty. My problem is to
effectively use the immediate window for debugging. I have forgotten
how to use the to find out the values of variables.

Clarification of Question by bdken-ga on 26 May 2005 09:30 PDT
Thank you for your comments they have brought back some of my memories
about coding in MS Access.  I still have a question as to where the ?
goes ( does it go in the immediate window or in the code itself?
Answer  
There is no answer at this time.

Comments  
Subject: Re: Issuues with immediate window in Access 2003
From: willcodeforfood-ga on 23 May 2005 10:04 PDT
 
Type a question mark followed by a variable or expression, such as one
of the following, then press enter:

? x

? x>10

? DCount("*","tblMyTable","SomeField=" & x)

? Forms.frmMyForm.txtLastName
Subject: Re: Issuues with immediate window in Access 2003
From: mathtalk-ga on 25 May 2005 04:17 PDT
 
? Answer.Good

True
Subject: Re: Issuues with immediate window in Access 2003
From: willcodeforfood-ga on 28 May 2005 11:21 PDT
 
Type the whole thing in the immediate window and press enter.  The
question mark is sort of like a "print" or "evaluate" command.  In
addition, you can issue commands directly by typing them in the
immediate window and pressing enter.  For example, if while debugging
some code, you are stepping through a loop that executes SQL
statements and you want to stop those pesky warning dialog windows
from appearing while you work with the code, you could type this
command:

DoCmd.SetWarnings False

Don't type anything in your code.  Just type the whole thing in the
immediate window.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy