"Object variable or With block variable not set" Message

[jdegeorge]

Hi:

I get this error message whenever I try to view the code behind forms, modules, etc.:

"Object variable or With block variable not set"

I tried compacting, repairing, jetcomp, etc. and nothing works.

Any ideas on how to see all that code through a back door or something? Documentor doesn't work either.

Jim DeGeorge

 

[BillPower]

Hi Jim,

While in the Visual Basic Editor, from the Menu select Debug>> Compile.

The debugger will highlight the first line of code with an error in it. If you can't work out the problem yourself, post the whole Sub or Procedure.

Bill

 

[jdegeorge]

While this MDB is open, I can't even get into the VB editor. No code can be viewed from any method I know. I have a backup of the MDB from Monday, so it looks like I'll have to re-create what I did yesterday! Yuck!

Jim DeGeorge

 

[VBOnly]

I had this problem several times. ACCESS crash when the startup form opens, so I have no way to access the database.

If you know the form or module which you have made most additions, open a new .mdb and import the change form/module, cut-paste to update your backup. It may same some time.

 

[jdegeorge]

When I try to import anything from the corrupted file, I get an error message saying that it is corrupted and that I should try to compact/repair or use a backup version. My LAN folks did get me a copy of Monday's file so all I have to re-recreate is Tuesday's development.

Jim DeGeorge