info
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Progress Box
8 views
Skip to first unread message
Andrew Jones
Nov 14, 2002, 1:30:20 PM11/14/02
to
Hi, I have a module that creates some recordsets and
creates an excel sheet based on the values (using early
binding). The whole process takes about 60 - 90 seconds
to run, but the user does not know it is running since it
is all done in memory. Is there anyway to have a box that
says something like "Please wait while transfering" that
stays up until the "do you want to overwrite the existed
xls file" box appears.
creates an excel sheet based on the values (using early
binding). The whole process takes about 60 - 90 seconds
to run, but the user does not know it is running since it
is all done in memory. Is there anyway to have a box that
says something like "Please wait while transfering" that
stays up until the "do you want to overwrite the existed
xls file" box appears.
Thanks,
Andrew
Dev Ashish
Nov 14, 2002, 4:19:54 PM11/14/02
to
If this is all done in VBA, then yes... You should be able to create your
own popup box and write code like this:
own popup box and write code like this:
call sDoSomeLengthyProcess
Sub sDoSomeLengthyProcess()
docmd.OpenForm "frmPleaseWait" ' Don't open it Modal
' process until you are about to issue a SaveAs
docmd.Cloase acForm, "frmPleaseWait"
objXL.SaveAs ...
End SUb
-- Dev
"Andrew Jones" <bubb...@hotmail.com> wrote in message
news:26a901c28c0b$e3192500$39ef2ecf@TKMSFTNGXA08...
0 new messages