473,659 Members | 2,987 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Updating A Chart On A Form

Tom
I have an unbound object frame on a subreport containing a chart linked to a
chart in an Excel worksheet. I can open the subreport in design view, select the
unbound frame, go to Edit - OLE/DDE Links, click on Links in the dialog that
appears and click on the Update Now button and the chart updates.

Can the above be done programatically at runtime?

Can the above be done programatically before the subreport opens?

Thanks!

Tom


Nov 12 '05 #1
0 1548

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
2191
by: Jim | last post by:
I have this chart on a form. I'm trying to get this chart to render only if the user chooses to do so. This because of that the chart is quite complex and takes some time to render. I know that I probably should put it on a report and call that report from the form but for various reasons I need the chart on this form. In a table bound to this form I have a Yes/No field and then from a checkbox the user should get to choose if the form is...
22
6775
by: PeteCresswell | last post by:
I've been to http://msdn.microsoft.com/library/default.asp?url=/library/en-us/mschrt/html/vbobjtitleobject.asp, but still don't have a clue. For example, I've got a chart object namde 'grphStats' in a form named frmChart. ?Forms!frmChart!grphStats.Name returns "grphStats" as expected, but I can't get any further.
3
3421
by: StBond | last post by:
Hi everyone, I am new to Access and Visual Basic so things my be getting across a bit cloudy. I only started using VB for one week. I am having a little problem with the database that I am working on. I am working with MS Access 2002. And I am having a problem with one of my charts. I will explain how everything is laid out then go into details.
8
1999
by: Jeffrey Spoon | last post by:
Hello, according to the docs you can update a DataGrid with an ArrayList. I have created an ArrayList and I add these objects: Dim patient1 As New Person patient1.Reading = 1 patient1.ReadingValue = 50 myArray.add(person1) Dim patient2 As New Person patient2.Reading = 2 patient1.ReadingValue = 60
1
1425
by: aimot75 | last post by:
Hi, I have a form contain 2 subforms. Mainform is called frmOrder, subfrmOrder and subfrmChart respectively. I tried to use me.subfrmChart.Requery on After Update Event to update the Chart, but it doesn't work. However I used Forms!frmOrder!subfrmChart.Requery under the form subfrmOrder--field:, it works fine. Does anyone could help me solve the problem Thanks
4
9515
by: KPOJonesECC | last post by:
Hello, I am in the middle of an access database projet but are struggerling with a couple of things. I dont expect anyone to solve the problem for me, but would really appreciate a pointer in the right direction as I am starting to struggle in terms of direction on this. Problem no1: I am currently trying to build an interactive calculator in a access form. Im making ok progress but have a couple of things I cant work out how to...
1
1489
by: wrightgj | last post by:
Hello, I have a chart in an Access form that updates when the underlying table is updated, which occurs when a button is pressed. I also have the option of adding more records to the table, which is where I am having a problem. The graph updates fine, but it displays for all records in the table at the same time (i.e. if I add three more records, there will be four lines on the graph). I want it to just display the information for the...
0
1602
by: blurbology | last post by:
I have a word document that contains a Graph (MSGraph). I am trying to update the Chart's datasheet with new values, but I cannot seem to get the correct reference for the chart object. What I am trying is: --------------------------------------- Dim oShape As Microsoft.Office.Interop.Word.Shape Dim oGraphChart As Microsoft.Office.Interop.Graph.Chart word = CreateObject("Word.Application") word.visible = True doc =...
2
3477
by: raddrummer | last post by:
I'm sure this is probably really easy but it's hanging me up so I'll go ahead and ask the question. I have an unbound form that contains a subform containing query results in tabular format. I want a chart on the main form that updates itself based on the currently selected record in the subform. So far I've tried using the refresh method placed in the on change() event of the subforms properties box but nothing happens.
0
8428
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
1
8528
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7356
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6179
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5649
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4175
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4335
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2752
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1976
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.