-
Jun 13th, 2018, 12:27 AM
#1
Thread Starter
Addicted Member
Left and bottom bars on a an Access form?
Can somebody tell me what are the things marked with arrows on the picture?
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?
-
Jun 13th, 2018, 01:09 AM
#2
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
Last edited by Zvoni; Tomorrow at 31:69 PM.
----------------------------------------------------------------------------------------
One System to rule them all, One Code to find them,
One IDE to bring them all, and to the Framework bind them,
in the Land of Redmond, where the Windows lie
---------------------------------------------------------------------------------
People call me crazy because i'm jumping out of perfectly fine airplanes.
---------------------------------------------------------------------------------
Code is like a joke: If you have to explain it, it's bad
-
Jun 13th, 2018, 05:56 AM
#3
Re: Left and bottom bars on a an Access form?
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
i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next
dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part
come back and mark your original post as resolved if your problem is fixed
pete
-
Jun 13th, 2018, 09:33 AM
#4
Re: Left and bottom bars on a an Access form?
Left one is (perhaps) the record selector
did you try clicking it -- what happens?
Feeling like a fly on the inside of a closed window (Thunk!)
If I post a lot, it is because I am bored at work! ;D Or stuck...
* Anything I post can be only my opinion. Advice etc is up to you to persue...
-
Jun 15th, 2018, 06:53 AM
#5
Thread Starter
Addicted Member
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.
-
Jun 15th, 2018, 07:37 AM
#6
Thread Starter
Addicted Member
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..
Last edited by kutlesh; Jun 15th, 2018 at 07:47 AM.
-
Jun 15th, 2018, 08:20 AM
#7
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.
Feeling like a fly on the inside of a closed window (Thunk!)
If I post a lot, it is because I am bored at work! ;D Or stuck...
* Anything I post can be only my opinion. Advice etc is up to you to persue...
-
Jun 15th, 2018, 10:40 AM
#8
Thread Starter
Addicted Member
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
Last edited by kutlesh; Jun 15th, 2018 at 10:47 AM.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|