I have put about 2 days of work into an Access database using 2000 with many
macros and code linked to buttons, when suddenly every button stopped
working.  Going to a previous day's backup did not work.  As suggested in a
response to another post, I created a new database and imported everything,
but still no buttons work.  When I try looking at the "On Click" expression
nothing comes up, I cannot launch the Code Builder (Expression and Macro
Builders work fine) and when I try to add a new button using the wizard it
will get to the point of naming the button and give me a "Subscript out of
range" error with no further explanation.  It's like VB is gone for this
database only, and I really don't want to start re-creating all my forms and
reports from scratch without knowing how or why the problem occured.  I do
link to another SQL database (SYSPRO) for some tables, but this is the same
in all our existing databases that continue to work fine.  There is also a
link to an Excel spreadsheet which is a first for me - could that cause the
VB problems?