'Compile' is dimmed

[Karen]

I started to compile my VBA code and it stopped on some code associated with
a form that I had added for testing purposes. I deleted the form and, since
then, the 'Compile' command on the Debug menu is dimmed. I've restarted the
database several times and rebooted the computer. Any ideas?

Karen

 

[Jeff]

Karen,

Honestly I have no idea what may be causing this, but as
a possible solution is maybe some currupt DLL files. If
you have the CD, try uninstalling & then Re-install MS
Office.
Its not that time consuming to do so...might fix the
problem.

Jeff

 

[Marshall Barton]

I started to compile my VBA code and it stopped on some code associated with
a form that I had added for testing purposes. I deleted the form and, since
then, the 'Compile' command on the Debug menu is dimmed. I've restarted the
database several times and rebooted the computer.

This sounds like VBA corruption. Make a backup before you
do anything else.

I suggest that you try to decompile your app. See:
http://www.mvps.org/access/bugs/bugs0008.htm

If that doesn't do it, there are several other suggestions
at:
http://www.granite.ab.ca/access/corruptmdbs.htm

 

[Karen]

Thanks Jeff,

I tried that and it didn't change my problem.

Karen

Karen,

Honestly I have no idea what may be causing this, but as
a possible solution is maybe some currupt DLL files. If
you have the CD, try uninstalling & then Re-install MS
Office.
Its not that time consuming to do so...might fix the
problem.

Jeff

 

[Karen]

Thanks Marsh,

I backed up the database, held my breath and did a compact and repair, my
'compile' is back now.

Karen

I started to compile my VBA code and it stopped on some code associated
with
a form that I had added for testing purposes. I deleted the form and,
since
then, the 'Compile' command on the Debug menu is dimmed. I've restarted
the
database several times and rebooted the computer.

This sounds like VBA corruption. Make a backup before you
do anything else.

I suggest that you try to decompile your app. See:
http://www.mvps.org/access/bugs/bugs0008.htm

If that doesn't do it, there are several other suggestions
at:
http://www.granite.ab.ca/access/corruptmdbs.htm