1 Attachment(s)
Left and bottom bars on a an Access form?
Can somebody tell me what are the things marked with arrows on the picture?
Attachment 159643
Yes, I mean the whole bars. And how can I access/use them?
Which VBA API?
By the way, what is the best way to add a status bar with a message text where I can display errors happening inside my code?
Re: Left and bottom bars on a an Access form?
Bottom Bar = Navigation Bar
Left Bar = No idea
How to access either = no idea
Showing Error Messages on a Status Bar = add a StatusBar-Control to your Form, and process from code what it should display at which point in time
Re: Left and bottom bars on a an Access form?
Quote:
add a StatusBar-Control to your Form
not sure with access, but would have thought the application should have a builtin status bar, check the view menu to see if it is an option
with excel you can use like
Code:
Application.StatusBar ="some text" put some stuff in the status bar
Application.StatusBar = false ' return statusbar back to Exce control
but access could be completely different
here is a link i found, sort of similar to excel
http://www.meadinkent.co.uk/astatus.htm
Re: Left and bottom bars on a an Access form?
Left one is (perhaps) the record selector
did you try clicking it -- what happens?
Re: Left and bottom bars on a an Access form?
Don't know what is the left bar.
The bottom bar is related to the form and I don't think there is a sub-component that represents the bottom bar as a whole.
I can set MyForm.RecordSet and it will switch the bottom bar data trough which it can browse. By pressing the arrows on the bottom bar you can loop trough the records in your record set.
Re: Left and bottom bars on a an Access form?
By the way. I added Microsoft StatusBar Control 6.0 in my form footer.
I can set custom text with code like this:
Code:
StatusBar2.Panels(1).Text = "Hello World"
In the properties window of the status bar control, there is a field "Custom". When you press it, a small window opens. Press the "Panels" tab. You can insert new panels and set custom text. You can also change the width of each status bar panel and set tool tip text. Also you can display image in a panel.
Panel index starts from 1, then 2, 3, 4 etc..
Re: Left and bottom bars on a an Access form?
Ah.. left is record selector in the form and the bottom is navegation
If you arent using a bound form, its best to turn these two options off in the form > properties
on access the app there is a status bar at the bottom of the app itself.
Re: Left and bottom bars on a an Access form?
Yes, "Record Selectors" and "Navigation Buttons" in form properties, confirmed.
I can turn off the status bar in options -> current database -> display status bar
but I want to display error messages in my form, so, Microsoft Status Bar Control 6.0 does the job