PC Review


Reply
Thread Tools Rate Thread

ACCESS TITLE BAR

 
 
Jess
Guest
Posts: n/a
 
      4th Feb 2010
How can I change the Access title bar with VBA?

Can anybody post an example?
 
Reply With Quote
 
 
 
 
Paolo
Guest
Posts: n/a
 
      4th Feb 2010
Hi Jess,
This work until aceess 2003, I don't know for newer version:
Add this function in the first form that you open

Function AddAppProperty(strName As String, varType As Variant, varValue As
Variant) As Integer
Dim dbs As Object, prp As Variant
Const conPropNotFoundError = 3270

Set dbs = CurrentDb
On Error GoTo AddProp_Err
dbs.Properties(strName) = varValue
AddAppProperty = True

AddProp_Bye:
Exit Function

AddProp_Err:
If err = conPropNotFoundError Then
Set prp = dbs.CreateProperty(strName, varType, varValue)
dbs.Properties.Append prp
Resume
Else
AddAppProperty = False
Resume AddProp_Bye
End If
End Function

Then on the open event of the form put this code

Const DB_Text As Long = 10

intX = AddAppProperty("AppTitle", DB_Text, "Your title") ' this set the
title
intX = AddAppProperty("AppIcon", DB_Text, "your icon with full path") '
this set the icon if you like
Application.RefreshTitleBar

HTH Paolo

"Jess" wrote:

> How can I change the Access title bar with VBA?
>
> Can anybody post an example?

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Access Chart Title and Axis title and Legend iccsi Microsoft Access Reports 1 16th Dec 2008 01:22 PM
Controlling the Access Title Bar ApexData@gmail.com Microsoft Access Forms 0 5th Jul 2006 09:42 PM
Access Title Bar =?Utf-8?B?THVjeQ==?= Microsoft Access Getting Started 1 4th Nov 2004 04:38 PM
I have windows XP Home, in windows explorer a folder with mp3s used to show a popup with title and Bitrate now it shows Type, Author, Title, Date Modified, and Size How can I get it back to Title and bitrate?? I use List, not Details jon@AZ.net Windows XP Help 3 30th Dec 2003 08:44 PM
Database Name in Access Title Bar? mikelee Microsoft Access 2 2nd Jul 2003 05:23 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:39 PM.