I have been working with for two days on a database with no
problems(changing forms and adding code to the forms and a module).
Shut down last night was fine, with no errors generated.
This morning, I opened the database and I started getting the dialog
"MSACCESS.exe has generated errors and will be closed by Windows. You
will need to restart the program. An error log is being created."
with an OK button. Access shuts down.
If I open the database again, and click on my first form that pops up,
I get the error. If I don't click the form, I can access the Access
menus, however.
If I go to the VBA code, I can view code for all my forms. I can
enter new code (ie comments), but once I enter the built-in function
MsgBox( the error occurs again. I can enter user-made functions
without incident.
I notice that a new icon is in the Project Explorer. It looks like a
form, but clicking it causes an error. The icon looks like the logo
from a printout. It looks like a small sheet of paper with blue
border and blue horizontal lines with the top right corner turned down
and a bit of light blue on the top right corner.
This icon is different from the form icons, and it located right under
the form icons but before the Modules. I have a form named
Form_frmPricingReport. This new icon has the name frmPricingReport.
Obviously, they are somehow connected, but I don't know how.
I have tried to compact and repair the database several times with no
change. I have tried to use the /decompile hack, to no avail (when I
run this through a batch program, the database starts and immediately
gives me the error message above.)
Also, when I attempt Debug > Compile in VBA I get the error.
Any ideas as to what the new icon is and how to rescue the database?
Thanks,
Gordon Sanderson
go******@texas.net