Record Selectors & Status Bar Frustration

Hi -
I have a form for employees, with a subform that shows all
records related to that employee. Then I have a button to
open another form to update a single record for an
employee. All works EXCEPT

1. I have Record Selctors = NO in properties on the main
form, yet the record selector still shows on the bottom.
I don't want the users to scroll through the records, so I
just want to NOT show the record selectors on this form.
How?

2. I want the buttons to have text in the status bar - I
have the rollover tip showing, but I'd like the Status Bar
Text, too. I have Status Bar checked in Startup and in
Tools/Options/View (per the Help) and I just don't see it.

Many thanks,
Sara

Hi Sara

1. The buttons in the horizontal scroll bar for changing record are called
the "Navigation Butttons". Set your form's Navigation Buttons property to
No. (The Record Selector is the bar to left of the form that selects the
record itself, e.g. if you want to delete the record.)

2. In form design view, you can set the Status Bar Text of each command
button (Other tab of properties box). In practice, the text appears on the
status bar only when the button receives focus. Typically that is when the
user clicks on the button (too late to be useful, really), but it also shows
if the user tabs onto the button.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"sara" wrote in message
...

I have a form for employees, with a subform that shows all
records related to that employee. Then I have a button to
open another form to update a single record for an
employee. All works EXCEPT

1. I have Record Selctors = NO in properties on the main
form, yet the record selector still shows on the bottom.
I don't want the users to scroll through the records, so I
just want to NOT show the record selectors on this form.
How?

2. I want the buttons to have text in the status bar - I
have the rollover tip showing, but I'd like the Status Bar
Text, too. I have Status Bar checked in Startup and in
Tools/Options/View (per the Help) and I just don't see it.

Many thanks,
Sara

Thanks so much, Allen.
I'm going to go try the Navigation buttons now.
And I suspectd I had done the Status Bar Text correctly,
thinking it might only show on "focus", but figured that
must be wrong since it is, as you say, too late. Still,
in case the user tabs over, I would like to have something
useful. I'll just put the "NO SAVE" note on the tip.

Thanks again.
Sara
-----Original Message-----
Hi Sara

1. The buttons in the horizontal scroll bar for changing
record are called
the "Navigation Butttons". Set your form's Navigation
Buttons property to
No. (The Record Selector is the bar to left of the form
that selects the
record itself, e.g. if you want to delete the record.)

2. In form design view, you can set the Status Bar Text
of each command
button (Other tab of properties box). In practice, the
text appears on the
status bar only when the button receives focus. Typically
that is when the
user clicks on the button (too late to be useful,
really), but it also shows
if the user tabs onto the button.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"sara" wrote in
message
...

I have a form for employees, with a subform that shows
all
records related to that employee. Then I have a button
to
open another form to update a single record for an
employee. All works EXCEPT

1. I have Record Selctors = NO in properties on the
main
form, yet the record selector still shows on the bottom.
I don't want the users to scroll through the records,
so I
just want to NOT show the record selectors on this form.
How?

2. I want the buttons to have text in the status bar -
I
have the rollover tip showing, but I'd like the Status
Bar
Text, too. I have Status Bar checked in Startup and in
Tools/Options/View (per the Help) and I just don't see
it.

Many thanks,
Sara


.