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
This walkthrough uses 32 bit ActiveXs so this examples is for MS Access 2013 32 bit.
ProEssentials, the setup program installs
the ProEssentials DLL and ActiveX interfaces into the system directory.
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.
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 v8 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.
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.