Status Bar Text

[Kirk P.]

My database begins by importing several text files. I've got code to
automate this, and the Status bar in Access automatically says "Importing"
and displays a nice progress bar.

I don't want to over-engineer this, but it would be nice to display
"Importing File #1 (2, 3, etc)" along with the built-in progress bar. Is
this possible?

 

[Dirk Goldgar]

In

My database begins by importing several text files. I've got code to
automate this, and the Status bar in Access automatically says
"Importing" and displays a nice progress bar.

I don't want to over-engineer this, but it would be nice to display
"Importing File #1 (2, 3, etc)" along with the built-in progress bar.
Is this possible?

You can use the SysCmd method for this (see the topic in the online help
in the VB Editor environment). You'd be using the acSysCmdInitMeter,
acSysCmdUpdateMeter, and acSysCmdRemoveMeter action arguments for this.

However, to update the meter to reflect the amount completed, you'll
need to be able to break your process up into increments. TTBOMK, you
won't be able to get the progress of built-in Access operations such as
query execution or file import/export. On the other hand, if you have
10 files to import, you can easily init the meter to a max of 10 and
increment it by 1 for each file.