Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Mon Jul 14 14:11:50 CDT 2003
Thank you Mark. Worked perfectly.
Best,
Rocky Smolin
Beach Access Software
----- Original Message -----
From: "Mitsules, Mark" <Mark.Mitsules at ngc.com>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Monday, July 14, 2003 11:23 AM
Subject: RE: [AccessD] Set Application Title Through Code
> In help, look under "RefreshTitleBar Method". However, I've pasted the
> example below.
>
>
> Mark
>
> <code>
> Sub ChangeTitle()
> Dim obj As Object
> Const conPropNotFoundError = 3270
>
> On Error GoTo ErrorHandler
> ' Return Database object variable pointing to
> ' the current database.
> Set dbs = CurrentDb
> ' Change title bar.
> dbs.Properties!AppTitle = "Contacts Database"
> ' Update title bar on screen.
> Application.RefreshTitleBar
> Exit Sub
>
> ErrorHandler:
> If Err.Number = conPropNotFoundError Then
> Set obj = dbs.CreateProperty("AppTitle", dbText, "Contacts
> Database")
> dbs.Properties.Append obj
> Else
> MsgBox "Error: " & Err.Number & vbCrLf & Err.Description
> End If
> Resume Next
> End Sub
> </code>
>
>
>
> -----Original Message-----
> From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com]
> Sent: Monday, July 14, 2003 2:18 PM
> To: AccessD at databaseadvisors.com
> Subject: [AccessD] Set Application Title Through Code
>
>
> Dear List:
>
> Does anyone know how to set the Application Title through code? The one
you
> can set manually from Tools-->Startup?
>
> MTIA,
>
> Rocky Smolin
> Beach Access Software
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>