MS Access 2010 VBA Code not compling/executing

[Peter Argast]

I've seen a lot of similar comments on this problem on various forums and most threads end with no resolution but I suspect the answer is simple enough though I've yet to find it.

I can add any given code and when I know it's OK it executes fine. The problem shows when apparently the code will execute up to some point but then stops with no complier or runtime errors.

So I deliberately create an error by mis-referencing a member of a recordset. For example;

debug.print rstMyRecordSet!RecordID

This runs OK but if I sabotage it i.e.

debug.print rstMyRecordSet!RecordIDxxxxx

I compile and run it and with trapping I know I’m executing right up to this statement, but I get no error and nothing executes thereafter.

I’m in a trusted location, tried every complier setting I can see but still no luck. Any ideas?

[TheSmileyCoder]

I dont have access 2010, so I will be shooting with a blindfold on.

Have your tried adding an error handler? Maybe there is some setting in access 2010 related to error handling that I don't know about.

An example would be:

On Error goto err_handler
  Debug.Print rstMyRecordSet!RecordIDxxxxx
Exit Sub
 
 
err_handler:
  Msgbox "An Error [" & err.Number & "] has occured" & vbnewline & Err.Description
 

Id suggest you start by trying this and then we can move forward from that. Let us know if the messagebox appears.

[Lysander]

I too don't have Access 2010 but I assume you can still put a breakpoint in your code (at a step you know works) and then use F8 to single step through the code until you come across the line that gives the problem.