Information Display

[dapiaoen]

This ought to be simple, but you have to love Access VB help.
I'm processing multiple MS Project files and loading up a database. It takes a while, and I want to simply display which file is being read and worked. That is,
"File being read is: " & thisfilename.mpp

Documentation is not much help. Do I use a MsgBox with vbCritical? I've seen that, but not tried it.

Thanks.

Chris

 

[Travis]

How about using application.syscmd(acSysCmdSetStatus

You can then place a message in the Status bar (bottom of the screen in access).

 

[dapiaoen]

Info Display

Seems like something to do. I'll try it. I built a small form with a label and text box, then set the text box value to the current field name being processed. Works fine, except that the form is transparent. I can't find any documentation on-line or books on something this simple. Simply a 'Please Wait' kind of pop up to show the user something is happening. The status area is okay, but not to obvious, i think.

Thanks, Chris

 

[Travis]

Add to the code that you have that updates the label a DoEvents. What this does is allows the Operating system to finish processing Repaints/Refreshes of the screen.

Example:

Me.TxtStatus="You are Here"
DoEvents

 

[dapiaoen]

Info Display

Thanks,

I'll add the DoEvents.

Chris

 

[dapiaoen]

Info Form Display

Found the 'repaint' method, which makes sure the form displays as intended. Hoo-ray!

Thanks, all.

 

[Cosmos75]

How about using application.syscmd(acSysCmdSetStatus

You can then place a message in the Status bar (bottom of the screen in access).

Travis,

How do I set the text for the Access statusbar??

 

[Cosmos75]

Nevermind... I think I got it.

StsBar = SysCmd(acSysCmdSetStatus, "Insert text here...")