Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/101126

From BetaArchive Wiki

Article ID: 101126

Article Last Modified on 1/18/2007



APPLIES TO

  • Microsoft Access 1.0 Standard Edition
  • Microsoft Access 1.1 Standard Edition
  • Microsoft Access 2.0 Standard Edition
  • Microsoft Access 95 Standard Edition
  • Microsoft Access 97 Standard Edition



This article was previously published under Q101126

Moderate: Requires basic macro, coding, and interoperability skills.

SYMPTOMS

In Microsoft Access 7.0 and 97, if you leave the Echo On argument out of the Echo action in a module, you may receive the error message, "Argument Not Optional."

In Microsoft Access 1.x and 2.0, if you leave the Echo On argument out of the Echo action in a module, you may receive the error message, "Expected: Expression."

RESOLUTION

Although the Microsoft Access Help system states that the default argument for the Echo action is Yes, you must include the argument in the line of code in order for the action to run properly.

MORE INFORMATION

Steps to Reproduce Behavior

In Microsoft Access 7.0 and 97:

  1. Open the sample database Northwind.mdb.
  2. Create a new module.
  3. Enter the following code in the Module window:

         '---------------------------------------------------------------
         ' The following function will produce the syntax error mentioned
         ' in the "Symptoms" section.
         '---------------------------------------------------------------
    
            Function Test()
               Docmd.Echo         ' Note that the arguments are missing.
            End Function
                            
  4. On the Run menu, click Compile Loaded Modules.

In Microsoft Access versions 1.x and 2.0:

  1. Open the sample database NWIND.MDB.
  2. Create a new module.
  3. Enter the following code in the Module window:

          '--------------------------------------------------------------
          'The following function will produce the syntax error mentioned
          'in the "Symptoms" section.
          '--------------------------------------------------------------
    
          Function Test()
             Docmd Echo         ' Note that the arguments are missing.
          End Function
                            


REFERENCES

For more information about the Echo action, search the Help Index for "Echo," and then "Echo Action," or ask the Microsoft Access 97 Office Assistant.

Keywords: kbprb KB101126