Knowledge.ToString()

Change MS Access Application Title and Icon Using VBA

Here is a code to change MS Access application title and icon using VBA. This code also sets the application icon as form and report default icon.

Dim db As Database
Set db = CurrentDb
db.Properties("AppIcon").Value = CurrentProject.Path & "\Bee.ico"
db.Properties("AppTitle").Value = msgMainTitle
db.Properties("UseAppIconForFrmRpt").Value = True
Application.RefreshTitleBar


Click here for list of all properties exposed by CurrentDB.Properties().

Share

Comments

12 responses to “Change MS Access Application Title and Icon Using VBA”

  1. Abdalla Avatar
    Abdalla

    that was great information, I couldn’t get it even in ChatGPT

  2. Grailly Avatar
    Grailly

    LoadIconA
    Hicon=LoadImageA(…..
    SendMessageA Hwnd,uMsg WM_SETICON,wParam &0,lPaearm Byval Hicon

  3. Willie Avatar
    Willie

    I have tried this code… but so far i have no success. Don’t know if this will be on a new module or on a startup form? I’ve tried both but still not working.

    willie

  4. albert Avatar
    albert

    Hello,

    This is exactly what I’m trying to accomplish, not sure where to enter the vba code so that properties are set at startup,

  5. Stefan Avatar
    Stefan

    Thanks boss. Am wondering if there’s a way of programmatically changing the startup form

    1. Vishal Monpara Avatar
      Vishal Monpara

      Hi Stefan,

      I am not aware of it but I think you may create a temporary startup form and depending on the criteria (username / role / access level ), open up needed form.

  6. Steven Avatar
    Steven

    Probably dead by now but is their a way to define the icon for the forms and reports separately from the application icon?

    1. vishal Avatar
      vishal

      Steven,

      I am not aware of any trick to accomplish the needed task.

  7. Ramon Avatar
    Ramon

    Where I have to write down that syntax
    Thanks

  8. donno Avatar
    donno

    This code was very useful. Thanks.

  9. D. Cohen Avatar
    D. Cohen

    Nice & simple 🙂

  10. Vlad Avatar
    Vlad

    Usefull. Thanx

Leave a Reply

Your email address will not be published. Required fields are marked *