?
Solved

Access Title Bar from VBA

Posted on 2011-02-24
8
Medium Priority
?
647 Views
Last Modified: 2012-05-11
I am attempting to update the Application title bar using vba to update the app title based on data in a table. It seems to lag behind and at times be completely wrong. The code is below.

The dlookup function checks a linked table to see if the field value of [isrunning] is true.
If it is, Access should display one title, if it's false another. The function is called whenever a form is opened and from an AUTOEXEC macro at startup.

Note: the startup macro seems to be  the only time it even partially works.
Public Function update_title_bar()
Dim db As Database, app_title As String
Set db = CurrentDb

If DLookup("isrunning", "tbl_base_status") = True Then
    app_title = "Client - Online"
Else
    app_title = "Client****OFFLINE****"
End If

db.Properties("AppTitle").Value = app_title

Application.RefreshTitleBar
End Function

Open in new window

0
Comment
Question by:JP_TechGroup
[X]
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
  • 3
8 Comments
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 1000 total points
ID: 34972093
That should work. Here's an article that shows more detail, but in essence you calling RefreshTitleBar should work:

http://msdn.microsoft.com/en-us/library/dd903046%28v=office.12%29.aspx

Where are you calling this?
0
 

Author Comment

by:JP_TechGroup
ID: 34972198
It runs from an AUTOEXEC macro at program open (which is the only time it works at all)
and from the on_form_load subs for about 8 forms. These do not work.
I concur, it should!
0
 
LVL 10

Assisted Solution

by:conagraman
conagraman earned 1000 total points
ID: 34981886
i dont know if this helps but i noticed one thing in your syntax. i dont think you can use dlookup in the way you are trying.
DLookup("isrunning", "tbl_base_status") = True

it wont return a true false statement instead it will return the first record in isrunning from the tbl_base_status. if the field should return the word true then put quotes around the = "true"

0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 

Author Comment

by:JP_TechGroup
ID: 34982384
Thanks for the response and you are correct. Unfortunately, this makes no difference.
The update is always "one behind".
By that, I mean that if the look up value changes, you have to close and re-open to see the new title.
This must be some kind of known issue. The code couldn't possibly simpler. A check of my lookup and logic using debug shows that this portion is working correctly.
0
 
LVL 10

Expert Comment

by:conagraman
ID: 34982854
you can try changing the code.

this worked for me. you will still need to put in the dlookup function but other than that this should work.


Dim aTitle
Dim db As Database
Set db = CurrentDb()
Dim NewTitle As String

 
NewTitle = nz(Me.Text5,"")
 
Set aTitle = db.CreateProperty("Apptitle", dbText, NewTitle)
On Error Resume Next
db.Properties.Append aTitle

db.Properties("AppTitle").Value = NewTitle
Call Application.RefreshTitleBar
changeTitle.accdb
0
 

Author Comment

by:JP_TechGroup
ID: 34997741
Still having the same problem. I have to close and re-open the database to get the change to work. This is maddening.
0
 
LVL 10

Expert Comment

by:conagraman
ID: 34997876
i dont see why. i tried your code and it worked the first time.
i would try compiling your code and trying it again.
0
 

Author Closing Comment

by:JP_TechGroup
ID: 34997911
FOUND IT! Apparently the link to the form icon was changed to a non-existent location. Once I fixed this the title bar updates as it should... weird!
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
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.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

777 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