Change MS Access application title and icon using VBA

By | December 15, 2009

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

Vishal Monpara is a full stack Solution Developer/Architect with 12 years of experience primarily using Microsoft stack. He is currently working in Retail industry and moving 1’s and 0’s from geographically dispersed hard disks to geographically dispersed user leveraging geographically dispersed team members.

10 thoughts on “Change MS Access application title and icon using VBA

  1. Steven

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

  2. vishal Post author

    Steven,

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

  3. Stefan

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

  4. Vishal Monpara Post author

    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.

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

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

Leave a Reply

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