Results 1 to 5 of 5
  1. #1
    techexpressinc's Avatar
    techexpressinc is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Dec 2008
    Location
    Indiana, USA
    Posts
    151

    how to change the words on form status bar?

    I like to change the words on the status bar. From the plan "Form View" to something like Version 1.0 or Copyright 2011.
    How would I do that I am trying, but not getting there using SysCmd.

    I am updating the "On Load - Event "
    i.e.

    Code:
    Private Sub Form_Load()
       DoCmd.Maximize
       SysCmd (715)


    The 715 was to return the Access version, nothing happen.

    And I tried this:
    - SysCmd(4,<"Copyright 2011">)
    and
    this:
    - SysCmd(4,"Copyright 2011").

    Russ

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    This worked for me:

    Private Sub Form_Load()
    Dim RetVal As Variant
    RetVal = SysCmd(acSysCmdSetStatus, "Copyright 2011")
    End Sub

    http://support.microsoft.com/kb/105511
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    techexpressinc's Avatar
    techexpressinc is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Dec 2008
    Location
    Indiana, USA
    Posts
    151

    Solved looks cool

    It worked for me too.
    Thx
    Russ

  4. #4
    techexpressinc's Avatar
    techexpressinc is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Dec 2008
    Location
    Indiana, USA
    Posts
    151

    One liner to update the status bar

    Application.SysCmd acSysCmdSetStatus, "What you want to say in the Status area"

  5. #5
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Thanks for the update. I did try the Application object but couldn't get syntax right so went with the other. Don't remember why it wouldn't work, looks so simple!
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. numbers to words
    By chavez_sea in forum Access
    Replies: 14
    Last Post: 01-16-2013, 07:25 PM
  2. Form Progress/Status Bar
    By Tomfernandez1 in forum Forms
    Replies: 2
    Last Post: 06-09-2011, 01:01 PM
  3. Progress/Status Bar on Form
    By Tomfernandez1 in forum Forms
    Replies: 5
    Last Post: 05-10-2011, 04:41 PM
  4. Query to flag daily change in order status
    By Relyuchs in forum Queries
    Replies: 1
    Last Post: 01-21-2011, 02:53 PM
  5. Replies: 10
    Last Post: 11-13-2006, 02:07 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums