Help!!!!

[Daryl2106]

Hi,

May DB was working fine until I added an button (to add a new record) to a form, changed the name of a form and deleted a form I no longer needed. Somewhere in there it caused existing code not to work (simple stuff like Me.Requery).

I am getting errors like "file not found" when I go to view the code on a form that no longer works. It is "error 53" in Access 2010. It says:

"A statement, for example, Kill, Name, or Open, refers to a file that doesn't exist. Check the spelling of the file name and the path specification"

I deleted the form with the macro. Can it still exist somewhere else?

Any advice or suggestions would be more that appreciated.

Take care,

Daryl

[pdebaets]

First, check to see if your database will compile. Open any module in design mode and click Debug > Compile (myprojectname).

You can use "find" (ctrl-F) in your VBA code to find any occurrences of "Kill", "name", or "Open" that may be causing a problem for your form.

[Daryl2106]

Thanks, I ended up exporting the tables etc. to a new DB agood thing in the end, it helped me clean the dB somewhat.

Take care,
Daryl