Borge Hansen
pcs at azizaz.com
Sat Feb 12 03:06:36 CST 2005
For those of you toiling on the weekend:
This is something that has annoyed me for a while.
I've set the database property Apptitle.
Both in the startup dialog window and in code on startup
This is the code for setting the Apptitle:
***************
Sub ChangeTitle()
Dim Obj As Object
Dim dbs As DAO.Database
Dim strAppTitle As String
Const conPropNotFoundError = 3270
strAppTitle = DLookup("AppTitle", "USystblsysvar")
On Error GoTo ErrorHandler
Set dbs = CurrentDb
dbs.Properties!AppTitle = strAppTitle
Application.RefreshTitleBar
Exit Sub
ErrorHandler:
If Err.Number = conPropNotFoundError Then
Set Obj = dbs.CreateProperty("AppTitle", dbText, strAppTitle)
dbs.Properties.Append Obj
Else
MsgBox "Error: " & Err.Number & vbCrLf & Err.Description
End If
Resume Next
End Sub
***********************
The Application Name appears in the database window.
In Access97 the Application Name would also appear on the title bar of all the message dialog boxes, instead of "Microsoft Access"
This doesn't happen in AccessXP
WHY NOT???
In the Help section for Msgbox it says:
Syntax
MsgBox(prompt[, buttons] [, title] [, helpfile, context])
bla bla ... and then
title Optional. String expression displayed in the title bar of the dialog box. If you omit title, the application name is placed in the title bar.
Help on Apptitle says in the remarks section:
Remarks
If this property isn't set, the string "Microsoft Access" appears in the title bar.
This property's setting takes effect immediately after setting the property in code (as long as the code includes the RefreshTitleBar method) or closing the Startup dialog box.
What am I missing here?
Borge