'Compile' is dimmed

  • Thread starter Thread starter Karen
  • Start date Start date
K

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
 
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 said:
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.
Click to expand...


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
 
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
 
Thanks Marsh,

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

Karen

Karen said:
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.
Click to expand...


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
 
Back
Top