|
The following information demonstrates how to create your first MSAccess ActiveX Charting implementation. It discusses installation, adding ProEssentials to a project, writing your first few lines of code, and shows the final results.
| Installation... |
|
When installing ProEssentials, the setup program installs the ProEssentials DLL and ActiveX interfaces into the system directory. The setup program also registers the ActiveXs with the operating system, which prepares MS Access, MS Excel, Visual Basic for inclusion of ProEssentials components. You can manually register an ActiveX with "REGSVR32.EXE" found in your system32 or syswow64 on 64 bit systems. You can also use this utility to manually un-register an ActiveX by using the "-u" command.
Note that 32 and 64 bit OCXs use the identical file name but are different files.
|
PEGRP64H.DLL
|
ProEssentials x64 64 bit DLL |
|
PEGRP32H.DLL
|
ProEssentials x86 32 bit DLL |
| PEGOH.OCX |
Graph Object |
| PESGOH.OCX |
Scientific Graph Object |
| PE3DOH.OCX |
3D Scientific Graph Object |
| PEPSOH.OCX |
Polar Object |
| PEPCOH.OCX |
Pie Chart Object |
|
From the New menu, create a new Blank Database.
The project opens and shows a default blank table.
| Adding a New Blank Form... |
Using the Create menu, Add a new Blank Form.
Below shows newly created blank form.
| Add example data we will read with VB code... |
Click / select the Table1 and referring to below image, add a few fields and data as shown.
Fields 1 and 2 are number type fields, and Field 3 is a short-string type field.
| Adding ActiveX Chart to MS Access form... |
Click / select the Form1 tab, then...
1 - click the design button bottom right or Design menu,
2 - click the menu Controls, and
3 - select 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 v8 installed, which will only be the case if both the v7 and v8 setup programs have been installed.
Select the Pego v10 Control and select OK.
The Pego ActiveX is placed on the form. You may increase its size as needed.
Note the design view image may not fully refresh while resizing, toggling the design view button off and on will cause the chart to re-draw to your new size.
| Adding Form OnLoad event... |
Select the Design menu, and then Property Sheet menu item to show the property window.
Double check that the Name property is set to Pego1 to match the below VBA code.
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.
|
