Status Bar

[esskaykay]

I've noticed in some forms, the note in the status bar in the lower left corner change. Ussually this just says "Form View" or "Design View". How do I go about changing this on some of my forms when they open?

Thanks,
SKK

 

[ajetrumpet]

change it to what? just have it disappear?

http://office.microsoft.com/en-us/access/HP051875021033.aspx

 

[esskaykay]

Change to what appears. Currently they have it displaying "Continue working with existing work order..."

This is fine, I was just wondering where this vebage is placed?

SKK

 

[ajetrumpet]

it's not placed anywhere. It uses a system command. For example. this:

syscmd(4, "Calculating...")

Show this in the status bar:

Calculating...

put the code wherever you want it to change what the status bar says...

 

[gemma-the-husky]

if you open a table, the description column actual displays as the status bar text, when you generate a form based on that table

is that the sort of thing you mean

hence decription can give a tip , like "Enter a 2 character expression"

 

[esskaykay]

Sorry guys but I’m still confused (not unusual). There is nothing in any of the description columns. I did a search for “syscmd” and found one instance:

isOpen = (SysCmd(acSysCmdGetObjectState, intObjectType, strName) <> 0)

I remarked it out but still am seeing the "Continue working with existing work order...". Because this is a WorkOrder program, I would have thought the message would have to have been keyed in somewhere. I did a search for the message and found nothing. Apparently I’m not looking in the right place.

Thanks,
SKK

 

[gemma-the-husky]

in the database window, make sure you can see all the details (view, details - as in windows explorer)

now is what you see typed in as the description for the form?

 

[esskaykay]

Description fields are blank.

 

[gemma-the-husky]

i don't think its a form property

is there anything like this in one of the description fields for any of the tables included in the forms record source?

does the message chane as you click from field to field?

 

[gemma-the-husky]

isOpen = (SysCmd(acSysCmdGetObjectState, intObjectType, strName) <> 0)

you probably didnt want to comment out this line

this is a very useful bit of code which uses the syscmd object to test whether a particular database object [table query form etc] is open. (form is probably the default)

the true/false value of this "isopen" is probably being returned by the function, and this will be called in numerous places, i am sure.

 

[esskaykay]

Yup, I placed it back in - just remove to test.

SKK

 

[RuralGuy]

This is probably a stupid question but does the status bar message change when you move to a different control on the form? Each control on a form has a Status Bar Text property.

 

[esskaykay]

No stupid question - that was it (how silly of me). I was not aware of the Status Bar Text property. I was playing with the tab order last week and that's apparently when the status bar message change.

Thank you very much RG. Like I said, this was not biggie, I was just wondering where it appears - now I know.

Thanks again,
SKK

 

[RuralGuy]

Excellent! Glad I could help.

 

[gemma-the-husky]

thats where it is

well played, rg