How to change Application Title for Microsoft Access 97?

Posted on 2005-02-25
Medium Priority
Last Modified: 2008-02-26
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?
Question by:stephenlecomptejr
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 13406394
place your application title in the box
LVL 66

Accepted Solution

Jim Horn earned 2000 total points
ID: 13406410
Try CurrentDb.Properties!AppTitle = sTitle
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 13406438
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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 13406446
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.


Author Comment

ID: 13406542
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?
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 13406755
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

Author Comment

ID: 13406786
Jim Horn's answer helping me make it work for now.

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question