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