Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / January 2006

Tip: Looking for answers? Try searching our database.

Outputting the status of the script...

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Michael - 20 Jan 2006 20:59 GMT
Hi Guys.

I was wondering if someone could help me. I just wrote a rather length VB
script that takes a table does a bunch of queries, modifies the data, and
exports the new data to excel. I justed added a form so all my boss has to do
is push a few buttons to run the code... However, my boss would like to have
a little status window so he knows when each step is complete.

I have debug statements for me to see in the code... but I have no idea how
to do this  for the user to see... I mean maybe you could add a msgBox for
each step, but then they would have to hit ok...

Does anyone know how to do this like an install file would?

I would really appreciate any assistance you could provide.

Thanks,

-Michael
Douglas J. Steele - 20 Jan 2006 21:12 GMT
Take a look in the Help file at the entry for SysCmd. You can use the SysCmd
function to write to the status bar.

Alternatively, you can put a label or text box on the form, and write to it
instead of using Debug.Print.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> Hi Guys.
>
[quoted text clipped - 18 lines]
>
> -Michael
Larry Daugherty - 20 Jan 2006 22:26 GMT
Use Echo to display progress on the status line at the bottom of the
Access window.

HTH
Signature

-Larry-
--

> Hi Guys.
>
[quoted text clipped - 15 lines]
>
> -Michael
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.