display temporary variables

[Jen0dorf]

Hi

debugging a sequence of forms etc which use a temporary variable

it's not working and I suspect a temporary variable is not being set.

A google search showed me

[CODE
Dim tv As TempVar
Debug.Print "TempVars.Count: " & TempVars.Count
For Each tv In TempVars
Debug.Print tv.Name, tv.Value
Next]
[/CODE]

I tried attaching this as a vba event to a button but that does not work,

How do I use this code or am I going in totaly the wrong direction

thanks

Ian

[John_G]

Saying "it does not work" isn't very helpful.

Does it print anything in the immediate window? Is there an Error message?

Can you post the entire On_Click event code for the button - that might indicate where the problem could be.

The code you posted should work fine - it does for me.

[davegri]

Works OK for me too, if you remove the bracket after "Next"

Dim tv As TempVar
Debug.Print "TempVars.Count: " & TempVars.Count
For Each tv In TempVars
Debug.Print tv.Name, tv.Value
Next]

[Jen0dorf]

Saying "it does not work" isn't very helpful.

Does it print anything in the immediate window? Is there an Error message?

Can you post the entire On_Click event code for the button - that might indicate where the problem could be.

The code you posted should work fine - it does for me.

Hi

apologies my button code is

Private Sub Command51_Click()
Dim tv As TempVar
Debug.Print "TempVars.Count: " & TempVars.Count
For Each tv In TempVars
    Debug.Print tv.Name, tv.Value
Next
End Sub

When pressed nothing happens, no error message no screen actions at all.

At the risk of being dispy how to I open the immediate window? as I can't seem to show it hence I can't answer your question

thanks

Ian

[John_G]

Use Ctrl-G to open the immediate pane. Debug.print writes to the immediate window.

[Jen0dorf]

Use Ctrl-G to open the immediate pane. Debug.print writes to the immediate window.

Many thanks I can now trouble shoot

cheers

Ian

[Jen0dorf]

Hi
just a thank you discovered my temporary variable was not being created so I deleted the code and compacted the database. Re inserted the code and its now creating the variabel

cheers

Ian