Bug in Code

[DavidWRouse]

Random Bug?, can i refresh all code

I have been doing a lot of vb in the last few days and have have several weird bugs.

And code doesn't work.

But if i delete the routine. And re type it, It works.

This is how i am declaring Vars etc at begining of my routine.
Dim i, intMeterLevel As Integer
Dim strLabel As String

I am using Access 2002.

 

[spacepro]

I know this is stating the obvious but have you clicked the save button once the code has been typed in the VB window. Post your code it might help solve your post.

Andy

 

[DavidWRouse]

Yes, i always save code before running it. Just incase it locks up.
Although code does not need to be saved before it's run.

It's like a Variable name has been stored in memory, and if I then change the type etc.

I cannot provide any Code samples at the Moment. When this happens again I will fully document the Weirdness.

 

[Pat Hartman]

Dim i, intMeterLevel As Integer

- Are you aware that i is being defined as a Variant, NOT as an Integer?

 

[DavidWRouse]

No I wasn't aware of that, I have just checked it out in the debugger.

That might solve some of my weird things that happen.

Thanks