Microsoft Access Charting Tutorial (ActiveX VBA)

ProEssentials charting within MS Access allows improved scientific, engineering, and financial charting within your Access databases; such as improved 3D, improved multiple axes, and improved end-user customization and export.

Our AI Knowledge and AI-Resources will help write 100% non-hallucinogenic OCX based VBA code.

Note that ProEssentials v10 installs an extensive demo project that replicates our complete 116 examples within Access: fully replicating our WPF, Winforms, MFC demos. We guarantee you've never seen this level of high performance charting within an Access Database. See the demo installed at ProEssentials10/Access/PE10FullDemo

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.

Click / select the Table1 and referring to the image below, add a few fields and data as shown.
Fields 1 and 2 are number type fields, and Field 3 is a Short Text type field.

Using the [Create] menu, add a new [Blank Form]. Below shows the newly created blank 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 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 v9 and v10 installed, which will only be the case if both the v9 and v10 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.

Select the [Design] menu, and then the [Property Sheet] menu item to show the property window.

Double check that the Name property is set to Pego1 to match the VBA code below.

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.