debug window on a form

[Thomas Anderson]

I would like to replicate the debug window on a form so I can easily
pass usefull info to users on long processes. Is there a simple way
to do this.

thanks

[Bogdan Zamfir]

Hi,

What do you mean by "Debug window"
Immediate window? To be able to write there something like when you use
debug.print?

And what is the "Long process"?
A query which takes long time to run or some VBA code who does a lot of
processing?

In a query, you can use a custom function, but this usually is not
reccomended, because will make the query much slower. But this actually
depends on what you want.

The function you use in the query can update a label or the content of a
locked Edit box, which could behave somehow like Immediate window

Also, you can do the same if the long process is a VBA procedure or
function.

Also, you could use a Progress bar, to show your users how long
(approximatively) the process has till it finish.

If you need more help on this, you can contact me.

Regards,
Bogdan Zamfir
______________________________
Independent consultant
"Thomas Anderson" <th****************@hotmail.com> wrote in message
news:3c*************************@posting.google.co m...

I would like to replicate the debug window on a form so I can easily
pass usefull info to users on long processes. Is there a simple way
to do this.

thanks

[TC]

Use a simple textbox!

' do some things.
me![txtStatus] = "I got here!" & vbcrlf & vbcrlf & me![txtStatus]
' do some more things.
me![txtStatus] = "Now I am here!!" & vbcrlf & vbcrlf & me![txtStatus]
etc.

Or, write a simple sub to which you pass the text, then the sub can add it
into the textbox.

HTH,
TC
"Thomas Anderson" <th****************@hotmail.com> wrote in message
news:3c*************************@posting.google.co m...

I would like to replicate the debug window on a form so I can easily
pass usefull info to users on long processes. Is there a simple way
to do this.

thanks

[Edward]

th****************@hotmail.com (Thomas Anderson) wrote in message news:<3c*************************@posting.google.c om>...

I would like to replicate the debug window on a form so I can easily
pass usefull info to users on long processes. Is there a simple way
to do this.

thanks

Put in a text box with vertical scroll bars (just in case).

Set up a timer, and occasionally break out to write to the text box.

You may need to look at DoEvents etc.

HTH

Edward
--
The reading group's reading group:
http://www.bookgroup.org.uk

[Pieter Linden]

th****************@hotmail.com (Thomas Anderson) wrote in message news:<3c*************************@posting.google.c om>...

I would like to replicate the debug window on a form so I can easily
pass usefull info to users on long processes. Is there a simple way
to do this.

thanks

any reason you can't send the output to an unbound textbox on your
form, and then repaint the form?