Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 18-05-2009
Member
 
Join Date: Apr 2009
Posts: 27
Change access forms title in vba

I use the chart wizard in Access 2000. I want to change title at runtime through VBA. Can anyone help me changing the title through VBA....???
Any suggestion will be appreciated......!
Reply With Quote
  #2  
Old 18-05-2009
Member
 
Join Date: Oct 2005
Posts: 2,389
Re: Change access forms title in vba

Try this code if possible

Code:
Sub Macro8()
ActiveSheet.ChartObjects(8).Chart. _
ChartTitle.Characters.Text = "Text"
End Sub
Reply With Quote
  #3  
Old 18-05-2009
Member
 
Join Date: May 2008
Posts: 2,383
Re: Change access forms title in vba

They know the entrance title, by them the characteristic. The following code becomes the entrance title along the category entrance :

Quote:
ActiveChart.Axes(xlCategory, xlPrimary).AxisTitle.Caption = “WEEK”
Reply With Quote
  #4  
Old 18-05-2009
Member
 
Join Date: Feb 2008
Posts: 1,848
Re: Change access forms title in vba

Try this:

Code:
Sub Macro1()
With Sheets("3. FHS").ChartObjects("ProjGraph1")
.Chart.HasTitle = True
.Chart.ChartTitle.Text = "This is New Title"
End With
End Sub
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Change access forms title in vba"
Thread Thread Starter Forum Replies Last Post
How to change author and title of PDF files Katyayani Software Development 10 30-12-2011 07:23 AM
How to turn-off OWA (outlook web access) forms Dyumani Windows Software 3 25-07-2009 10:22 AM
How to Automatically access the fields of an Access 2007 forms Corona Software Development 3 25-06-2009 12:54 PM
Change browser title in Opera absolute55 Tips & Tweaks 2 09-05-2009 05:53 PM
Change Yahoo Messenger Title bar NGV BalaKrishna Tips & Tweaks 1 09-12-2008 07:28 PM


All times are GMT +5.5. The time now is 02:07 AM.