Corrupted database/VBA module? (Have to start from scratch??) 1

[sniffingvixen]

Please help me if you can...see thread702-1316841 for original details.

Since that posting, I removed all code from the problematic form hoping that I'd be able to rewrite it. While I can properly compile the VBA project now, "Value" is still the only property available to any fields active on the form, including those that weren't manipulated in the code. This is true even if I remove the field from the form.

I really don't want to have to create the entire database from scratch, but I've run out of ideas! I'm worried that just scrapping the form won't do the job (not that I relish the prospect of recreating the form either).

Any words of wisdom on this matter would be greatly appreciated!

Thanks,
j

 

[Remou]

Have you tried a decompile or importing into a fresh database?
DB corrupt, get rid of error
faq705-4683

 

[sniffingvixen]

Thanks, Remou!

I ended up having to delete all my code and import everything to a new database (the second recommendation in the FAQ), but being able to do that saved me a huge amount of time.

Everything is back on track now.

Much obliged, j