ACC97: RunCommand Constants Truncated After 25 Characters

Retired KB Content Disclaimer

View products that this article applies to.

This article was previously published under Q168311

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

SYMPTOMS

When you convert any of the following RunCommand macro actions

   RunCommand CompileAndSaveAllModules
   RunCommand ConvertMacrosToVisualBasic
   RunCommand CreateShortcutMenuFromMacro
   RunCommand HorizontalSpacingMakeEqual
   RunCommand MicrosoftAccessHelpTopics
   RunCommand ObjBrwFindWholeWordOnly
   RunCommand ObjBrwShowHiddenMembers
   RunCommand QueryTypeSQLDataDefinition
   RunCommand QueryTypeSQLPassThrough
   RunCommand UserLevelSecurityWizard
   RunCommand VerticalSpacingMakeEqual

using the "Convert Macro to Visual Basic" command, the syntax is truncated during the conversion, and you receive the following error message when you compile the converted macro module:

Compile error:

Variable not defined

Back to the top

There is a 25 character limitation for the RunCommand constants when using the "Convert Macro to Visual Basic" command. This includes the acCmd prefix that is attached to the constant during the conversion.

Back to the top

RESOLUTION

To prevent your code from failing with a compile error, modify the syntax for the truncated constants before you compile and run the module.

Back to the top

MORE INFORMATION

Steps to Reproduce Behavior

Create a new database in Microsoft Access 97.

Create a new macro, and add the following RunCommand actions to the macro:

      Macro Name           Macro Action
      ---------------------------------
      Macro1               RunCommand
                           RunCommand
                           RunCommand

      Macro1 Actions
      --------------------------------------
      RunCommand
         Command: CompileAndSaveAllModules
      RunCommand
         Command: ConvertMacrosToVisualBasic
      RunCommand
         Command: UserLevelSecurityWizard

Save the macro as Macro1.
Select Macro1 in the Database window. On the Tools menu, point to Macro, and then click "Convert Macro to Visual Basic."
After the conversion process is finished, open the converted macro module. Note the truncated constants.
On the Debug menu, click Compile Loaded Modules. Note that you receive the error message mentioned in the "Symptoms" section.

Back to the top

REFERENCES

For more information about converting macros, search the Help Index for "macros, converting," and then "convert macros to Visual Basic," or ask the Microsoft Access 97 Office Assistant.

Back to the top

APPLIES TO

Microsoft Access 97 Standard Edition

Back to the top

kbcode kberrmsg kbprb KB168311

Back to the top

Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Back to the top