469,950 Members | 1,930 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,950 developers. It's quick & easy.

debug window on a form

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
Nov 12 '05 #1
4 4032
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

Nov 12 '05 #2
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

Nov 12 '05 #3
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
Nov 12 '05 #4
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?
Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Robert | last post: by
3 posts views Thread by Mike Turco | last post: by
2 posts views Thread by Buz Waitz | last post: by
7 posts views Thread by Thomas Pecha | last post: by
1 post views Thread by Adrian Constantinescu | last post: by
5 posts views Thread by Billy | last post: by
7 posts views Thread by poppybush | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.