Did you know you can give your Access database a personalized touch by setting a custom application icon? Head over to File > Options > Current Database, then use the Application Icon setting to choose any .ico file you like - your logo, favorite symbol, or even a pixelated penguin. This icon will appear in the Access window title bar and on the Windows taskbar when your database is open, adding a bit of branding flair (and helping you quickly tell your projects apart). Just remember to keep that .ico file in the same folder as your database, or use a full path, to avoid mysterious missing icon moments.
Kevin Robertson
@Reply 3 months ago
I have this in a Global Module:
DetailsPublic Sub SetAppIcon(ByVal IconPath As String)
Const PROP_NAME As String = "AppIcon"
Dim prp As Property
On Error Resume Next
' Try to get the property from CurrentDb
Set prp = CurrentDb.Properties(PROP_NAME)
On Error GoTo 0
If prp Is Nothing Then
' Property doesn't exist - create it
Set prp = CurrentDb.CreateProperty(PROP_NAME, dbText, IconPath)
CurrentDb.Properties.Append prp
Else
' Property exists - update it
CurrentDb.Properties(PROP_NAME) = IconPath
End If
' Refresh the title bar to apply the change
Application.RefreshTitleBar
End Sub
I then call it in the Load event of my Start Up Form:
SetAppIcon CurrentProject.Path & "\MyIcon.ico"
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Captain's Log.
