Updated Charttitle not working in Access 2007

  • Thread starter Thread starter hotplate
  • Start date Start date
H

hotplate

This code worked great when using Access 2003 but when we switched to
2007, it stopped working. Any suggestions? better way of doing this?
Library needs loading?

I don't even get an error, it just does not update it anymore.

Private Sub Graph0_Updated(Code As Integer)
Me.Graph0.charttitle.Text = [Forms]![frmreports].[Commodity] & " Year
to Date PPM"
End Sub
 
On Mon, 3 May 2010 04:33:23 -0700 (PDT), hotplate

What happens when you set a breakpoint here?
My guess is it does not fire, proving the code never executes. If that
is indeed so, the VBA code may have become "disconnected" from its
event. Design the object, select the graph, select the Updated event
and click on the ... button on the far right.

-Tom.
Microsoft Access MVP
 
It is not disconnected. I go straight to the code when pressing
the ...

It still does not update.


On Mon, 3 May 2010 04:33:23 -0700 (PDT), hotplate


What happens when you set a breakpoint here?
My guess is it does not fire, proving the code never executes. If that
is indeed so, the VBA code may have become "disconnected" from its
event. Design the object, select the graph, select the Updated event
and click on the ... button on the far right.

-Tom.
Microsoft Access MVP


This code worked great when using Access 2003 but when we switched to
2007, it stopped working.  Any suggestions? better way of doing this?
Library needs loading?
I don't even get an error, it just does not update it anymore.
Private Sub Graph0_Updated(Code As Integer)
Me.Graph0.charttitle.Text = [Forms]![frmreports].[Commodity] & " Year
to Date PPM"
End Sub- Hide quoted text -

- Show quoted text -
 
On Mon, 3 May 2010 08:43:03 -0700 (PDT), hotplate

What about the breakpoint I suggested?

-Tom.
Microsoft Access MVP

It is not disconnected. I go straight to the code when pressing
the ...

It still does not update.


On Mon, 3 May 2010 04:33:23 -0700 (PDT), hotplate


What happens when you set a breakpoint here?
My guess is it does not fire, proving the code never executes. If that
is indeed so, the VBA code may have become "disconnected" from its
event. Design the object, select the graph, select the Updated event
and click on the ... button on the far right.

-Tom.
Microsoft Access MVP


This code worked great when using Access 2003 but when we switched to
2007, it stopped working.  Any suggestions? better way of doing this?
Library needs loading?
I don't even get an error, it just does not update it anymore.
Private Sub Graph0_Updated(Code As Integer)
Me.Graph0.charttitle.Text = [Forms]![frmreports].[Commodity] & " Year
to Date PPM"
End Sub- Hide quoted text -

- Show quoted text -
 
Nothing happend, it never stopped.

On Mon, 3 May 2010 08:43:03 -0700 (PDT), hotplate


What about the breakpoint I suggested?

-Tom.
Microsoft Access MVP


It is not disconnected.  I go straight to the code when pressing
the ...
It still does not update.
On Mon, 3 May 2010 04:33:23 -0700 (PDT), hotplate
What happens when you set a breakpoint here?
My guess is it does not fire, proving the code never executes. If that
is indeed so, the VBA code may have become "disconnected" from its
event. Design the object, select the graph, select the Updated event
and click on the ... button on the far right.
-Tom.
Microsoft Access MVP
This code worked great when using Access 2003 but when we switched to
2007, it stopped working.  Any suggestions? better way of doing this?
Library needs loading?
I don't even get an error, it just does not update it anymore.
Private Sub Graph0_Updated(Code As Integer)
Me.Graph0.charttitle.Text = [Forms]![frmreports].[Commodity] & " Year
to Date PPM"
End Sub- Hide quoted text -
- Show quoted text -- Hide quoted text -

- Show quoted text -
 
On Wed, 5 May 2010 04:48:14 -0700 (PDT), hotplate

That tells me that either this code is never called, or you have some
form of corruption.

-Tom.
Microsoft Access MVP

Nothing happend, it never stopped.

On Mon, 3 May 2010 08:43:03 -0700 (PDT), hotplate


What about the breakpoint I suggested?

-Tom.
Microsoft Access MVP


It is not disconnected.  I go straight to the code when pressing
the ...
It still does not update.
What happens when you set a breakpoint here?
My guess is it does not fire, proving the code never executes. If that
is indeed so, the VBA code may have become "disconnected" from its
event. Design the object, select the graph, select the Updated event
and click on the ... button on the far right.
-Tom.
Microsoft Access MVP
This code worked great when using Access 2003 but when we switched to
2007, it stopped working.  Any suggestions? better way of doing this?
Library needs loading?
I don't even get an error, it just does not update it anymore.
Private Sub Graph0_Updated(Code As Integer)
Me.Graph0.charttitle.Text = [Forms]![frmreports].[Commodity] & " Year
to Date PPM"
End Sub- Hide quoted text -
- Show quoted text -- Hide quoted text -

- Show quoted text -
 
I run the same code on several different databases and all of them
stopped calling the code after switching to 2007. It still works for
the people using 2003. You are right, the code never gets called. I
can use the double click event to get it to call, but I really don't
want to. I am hoping to find a better way to do this since nothing
works on the "Updated" event in 2007. I think it is a bug in Access
personally.



On Wed, 5 May 2010 04:48:14 -0700 (PDT), hotplate


That tells me that either this code is never called, or you have some
form of corruption.

-Tom.
Microsoft Access MVP


Nothing happend, it never stopped.
On Mon, 3 May 2010 08:43:03 -0700 (PDT), hotplate
What about the breakpoint I suggested?
-Tom.
Microsoft Access MVP
It is not disconnected.  I go straight to the code when pressing
the ...
It still does not update.
On Mon, 3 May 2010 04:33:23 -0700 (PDT), hotplate
What happens when you set a breakpoint here?
My guess is it does not fire, proving the code never executes. If that
is indeed so, the VBA code may have become "disconnected" from its
event. Design the object, select the graph, select the Updated event
and click on the ... button on the far right.
-Tom.
Microsoft Access MVP
This code worked great when using Access 2003 but when we switchedto
2007, it stopped working.  Any suggestions? better way of doing this?
Library needs loading?
I don't even get an error, it just does not update it anymore.
Private Sub Graph0_Updated(Code As Integer)
Me.Graph0.charttitle.Text = [Forms]![frmreports].[Commodity] & "Year
to Date PPM"
End Sub- Hide quoted text -
- Show quoted text -- Hide quoted text -
- Show quoted text -- Hide quoted text -

- Show quoted text -
 
Back
Top