MS Access Charting ActiveX教程，显示用于读取SQL表和填充图表的VBA代码。

For help finding ActiveX specific features in our help system, the .Net Reference section is the best source for researching properties. Our help topics show ActiveX OCX specific syntax in the OCX/VCL header near top of topic.

When installing ProEssentials, the setup program installs the ProEssentials 32 bit DLL into the System32 directory on 32 bit systems. On 64 bit systems, the 32 bit DLL is installed in SysWow64 and the 64 bit DLL is installed in System32.

The setup also installs the following Charting OCX files into the same system folders as DLLs and registers them. Note, you do not register our DLLs. Note, the 32 bit and 64 bit OCXs have the same file names and classIDs and the OS will correctly invoke the appropriate version based on the run time need. The relevant files are:

Pro Components:

• PEGOG.OCX : Graph Component
• PESGOG.OCX : Scientific Graph Component
• PE3DOG.OCX : 3D Scientific Graph Component
• PEPSOG.OCX : Polar Smith Component
• PEPCOG.OCX : Pie Chart Component

• PEGRP32G.DLL : 32 bit Pro DLL
• PEGRP64G.DLL : 64 bit Pro DLL

Standard Components:

• PEGOSG.OCX : Graph Component
• PESGOSG.OCX : Scientific Graph Component
• PE3DOSG.OCX : 3D Scientific Graph Component
• PEPSOSG.OCX : Polar Smith Component
• PEPCOSG.OCX : Pie Chart Component

• PEGRPSG.DLL : 32bit Standard DLL
• PEGRP6SG.DLL : 64bit Standard DLL

The following information demonstrates how to create your first ProEssentials Access ActiveX Charting implementation using the Visual Basic. It discusses using the OCX charting components to add interactive engineering and scientific charting content to your Access Databases. Please see the other charting examples provided within the product/evaluation; including a larger MS Access example database already containing charts and example code on various forms.

1) From the [New] menu, create a new [Blank Database]

The project opens and shows a default blank table.

2) Using the [Create] menu, Add a new [Blank Form].

Below shows newly created blank form.

3) Click / select the Table1 and referring to below image, enter the following fields and data as shown.

• Field 1: number type
• Field 2: number type
• Field 3: default short string type

4) Adding the Gigasoft ActiveX Chart to MS Access form.

Click / select the Form1 tab, then...

• 1: click the [Design View button] on the far bottom right corner of the main MS Access application window
  
• 2: click the main [Design] menu (purple color below),
• 3: click the menu [Controls] and /or the bottom right button [More] for more Controls...
  
• 4: select the [ActiveX Controls] menu item.

You see the Insert ActiveX Control dialog showing all ActiveX controls registered with the operating system.

This image shows ProEssentials v7 and v9 installed, which will only be the case if both the v7 and v9 setup programs have been installed.

Select the Pego v9 Control and select OK.

The Pego ActiveX is placed on the form. You may position and size the control as needed.

The default state has one subset with four data points. In the course of constructing your own charts, you'll set the properties Subsets and Points which define the quantity of data your chart will hold. You'll then pass data via the YData(subset, point) two dimensional property array. The following section shows example code of passing data. Note, if we were constructing a Scientific Graph (Pesgo), we'd also set XData(subset, point).

Important, select the All tab to show all properties, and change the Name property of the new control to Pego1. The code will we be adding in the next section will require the Name property to be Pego1.

5) Within the [Property Sheet] section, make sure Form is shown as the Selection Type, click the Event tab, and click the [...] for the OnLoad event to open the Visual Basic editor and add the code below to the Form_Load event. Note that within the design view editor, clicking the solid grey area below the detail section will also select the Form and show Form related properties and events.