dcsimg
Results 1 to 8 of 8
  1. #1

    Thread Starter
    Member kutlesh's Avatar
    Join Date
    Jun 2018
    Location
    Skopje, R. Macedonia
    Posts
    37

    Left and bottom bars on a an Access form?

    Can somebody tell me what are the things marked with arrows on the picture?

    Name:  AccessStatusBar.jpg
Views: 83
Size:  20.9 KB

    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?

  2. #2
    PowerPoster Zvoni's Avatar
    Join Date
    Sep 2012
    Location
    To the moon and then left
    Posts
    1,241

    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
    People call me crazy because i'm jumping out of perfectly fine airplanes.
    I say you're crazy not to!
    --------------------------------------------------------------------------------------------------
    For health reasons i try to avoid reading unformatted Code

  3. #3
    PowerPoster
    Join Date
    Dec 2004
    Posts
    23,559

    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

  4. #4
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Java (JSP) Hell!
    Posts
    5,265

    Re: Left and bottom bars on a an Access form?

    Left one is (perhaps) the record selector


    did you try clicking it -- what happens?

    BOFH Now, BOFH Past, Information on duplicates

    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...

  5. #5

    Thread Starter
    Member kutlesh's Avatar
    Join Date
    Jun 2018
    Location
    Skopje, R. Macedonia
    Posts
    37

    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.

  6. #6

    Thread Starter
    Member kutlesh's Avatar
    Join Date
    Jun 2018
    Location
    Skopje, R. Macedonia
    Posts
    37

    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.

  7. #7
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Java (JSP) Hell!
    Posts
    5,265

    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.

    BOFH Now, BOFH Past, Information on duplicates

    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...

  8. #8

    Thread Starter
    Member kutlesh's Avatar
    Join Date
    Jun 2018
    Location
    Skopje, R. Macedonia
    Posts
    37

    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
  •  



Featured


Click Here to Expand Forum to Full Width


×
We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.