[AccessD] peculiar casing in VBE

Chris Mackin chris at denverdb.com
Sat Apr 5 14:59:20 CST 2003


Most likely you created a variable called "commandBars" somewhere along the
way,  It capatalizes it when I drop your code into a module.

To fix just type:
Dim CommandBars
and hit enter, all instances of commandBars will capatalize.

Chris Mackin
www.denverdb.com
Denver Database Consulting, LLC


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Susan Harkins
Sent: Saturday, April 05, 2003 1:19 PM
To: AccessD at databaseadvisors.com
Subject: [AccessD] peculiar casing in VBE


Set cmdbar = Application.commandbars("Edit")

=======Regarding the above -- why does the VBE lowercase commandbars? I keep
trying to change it, but it always overrides my changes. Odd one.

Susan H.

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list