Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 533
  • Last Modified:

How to change Application Title for Microsoft Access 97?

I've got the following to change the appTitle in Microsoft Access 97?

but I get a Run-time error 3270 - Property not found. with the highlight on it tho.
sTitle is just a string variable.

Db.Properties!AppTitle = sTitle

Is there a better way to change the Application Title?
  • 4
  • 2
1 Solution
Rey Obrero (Capricorn1)Commented:
place your application title in the box
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Try CurrentDb.Properties!AppTitle = sTitle
Rey Obrero (Capricorn1)Commented:
if you want to do it in VBA
 you can add it by using the CreateProperty method and append it to the Properties collection of the Database object
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Rey Obrero (Capricorn1)Commented:
from access help

You can use the AppTitle property to specify the text that appears in the application database's title bar. For example, you can use the AppTitle property to specify that the string "Inventory Control" appear in the title bar of your Inventory Control database application.

The AppTitle property is a string expression containing the text to appear in the title bar.

The easiest way to set this property is by using the Application Title option in the Startup dialog box, available by clicking Startup on the Tools menu. You can also set this property by using a macro or Visual Basic.

To set the AppTitle property by using a macro or Visual Basic, you must first either set the property in the Startup dialog box once or create the property in the following ways:

In a Microsoft Access database (.mdb), you can add it by using the CreateProperty method and append it to the Properties collection of the Database object.
In a Microsoft Access project (.adp), you can add it to the AccessObjectProperties collection of the CurrentProject object by using the Add method.
You must also use the RefreshTitleBar method to make any changes visible immediately.

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.

stephenlecomptejrAuthor Commented:
Let's say I have a frmStartup which starts up when the database is ran under Tools - Startup - Display Form.

Private Sub Form_Open(Cancel As Integer)

End Sub

What do I have to type in to make it a property of the database?

And also do I need to type in under Application Title in Tools - Startup "AppTitle"? to make this work?
Rey Obrero (Capricorn1)Commented:
actually you don't need to use a form
type the title in the box

Application Title click OK

and you will see it in the Application title
stephenlecomptejrAuthor Commented:
Jim Horn's answer helping me make it work for now.

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now