Results 1 to 5 of 5

Thread: Caption (2003)

  1. #1
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    London, Gtr London
    Posts
    131
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Caption (2003)

    My mind's gone blank, can anyone remind me what the name of the field/caption at the bottom left of the screen is called.

    The one just above the START button, It usually says things like "Ready" or "Form View" or "Design View"

    Many thanks
    Hayden

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Caption (2003)

    It's called the status bar. You can set a status bar message in VBA code using SysCmd:

    SysCmd acSysCmdSetStatus, "Hello World"

    To restore the standard display, use

    SysCmd acSysCmdClearStatus

    You can also display a progress bar in the status bar:

    SysCmd acSysCmdInitMeter, "Processing data", 40
    ...
    SysCmd acSysCmdUpdateMeter, 10
    ...
    SysCmd acSysCmdUpdateMeter, 20
    ...
    SysCmd acSysCmdUpdateMeter, 30
    ...
    SysCmd acSysCmdUpdateMeter, 40
    ..
    SysCmd acSysCmdRemoveMeter

  3. #3
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    London, Gtr London
    Posts
    131
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Caption (2003)

    Hans, you should be a mind reader, this is exactly what I want.

    Thanks very much!

  4. #4
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    London, Gtr London
    Posts
    131
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Caption (2003)

    Hans, sorry one more thing regarding the status bar:

    My idea was to have the status bar change when a new query is run to inform the user what it's doing. I can see the wording I have used come up but when the query starts running the status bar changes to show "Run Query" together with the progress bar.

    I was going ask if it is possible to switch the standard comment off and just display the message I want while the query is running?

    thanks again
    Hayden

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Caption (2003)

    I don't think it is possible to suppress the status bar messages that Access generates automatically.

    See the links in <post#=362010>post 362010</post#> for alternatives to the status bar progress meter.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •