Which Database is Opened - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Which Database is Opened

Peter van Soest

4 years ago

When I am working In an Excell of Word file I see the name of the file at the top of the screen.... but not in Acces!
I only see the word 'Access'

In 'Options' I found 'Application Options' and an 'Application title field'. When I just click in that field and exit Options,
I do see the filename on top, including the full path, but when I close and reopen the file, it is gone and I again only see the word Acces

	Scott Axton @Reply 4 years ago
I think that is somewhat by design. Back in the early days there were so many people - developers mostly - NOT wanting that. The old bulletin boards and forums had many posts with people asking how to make Access not look like Access.

	Kevin Robertson @Reply 4 years ago
You can set it in code. First set your Display Form (For example: MainMenuF) Next, enter the following in the Open Event of your Display Form. `CurrentDb.Properties("AppTitle").Value = CurrentProject.Path & "\" & CurrentDb.Name Application.RefreshTitleBar`

	Peter van Soest OP @Reply 4 years ago
You mean like this? That gives me runtime error 3270 property not found Private Sub Form_Load() CurrentDb.Properties("AppTitle").Value = CurrentProject.Path & "\" & CurrentDb.Name Application.RefreshTitleBar End Sub

	Kevin Robertson @Reply 4 years ago
I just tested on another database and also got the Runtime Error. It looks like you have to set the Application Title in the options first to create the property. Then you can use the code above.

	Peter van Soest OP @Reply 4 years ago
Tried that one as well, still get error messages. Funny thing though, when I use ONLY Application.RefreshTitleBar at first (when I load the form) nothing happens, but when I switch to design mode and then back to view, the filename and path do appear in the top of the screen! But when I close the form, it goes away again.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View