QRCode ActiveX Control MS Access

I am a beginner in C# language, but have had some experience with Visual Basic, Python, etc.

I am engaged in creating an ActiveX Controller with an installer that can be used with Microsoft Access (current version) as a C# Class Library for Windows Forms on Visual Studio 2019. The following is what I want the program to do:

- If the ActiveX Control is selected in MS Access and placed into a report object, then it will use the control source for the object in the properties of that software to pass a string into the controller and it will return an image made by the QRCoder module (a popular method used for C# and VBA in VS 2019 through NuGent Packager).

Requirements: As the report function in access is done for each record in the database table, the image will update on each row of the report for the specified control source.

Does anyone have an idea where to begin with treatment in C# script for the project? So far, I've managed to make a Control and an Interchange file; however, the models I'm using were for html strings and I'm having trouble telling the program to return an image in place of a string input.

I'm also confused how to instruct the program that the input will be coming from MS Access based on the settings for the data source of the report. I'm not sure how to call it in the code.

QRCode ActiveX Control MS Access Using .net

First of all

- Open your Visual Studio and you might be tempted to import the ActiveX control Barcodewiz.dll by clicking on Tools > Choose Toolbox Items > Com Components > Browser

However, visual studio does not import the properties correctly. when accessing the picture property in a project compiled for x64 OR Any CPU, an exception (A generic error occurred in GDI+) is thrown.

Instead, use the supplied Interop Assemblies as outlined in the steps below to ensure compatibility with both 32 and 64-bit projects.

Step 1. Add AxBarCodeWiz to Toolbox

Click on Tools > Choose Toolbox Items...

Now .NET Framework Components selected, click Browse...

Now Select AxBARCODEWIZLib.dll. The default location of the file is:

C:\Program Files (x86)\BarCodeWiz ActiveX\DLL\Interop\AxBARCODEWIZLib.dll

Step 2. Add reference to BARCODEWIZLib.dll

Click Project > Add Reference...

Click on the Browse tab and select BARCODEWIZLib.dll. The default location of the file is:
C:\Program Files (x86)\BarCodeWiz ActiveX\DLL\Interop\BARCODEWIZLib.dll

Step 3. Edit Properties

In Solution Explorer click on BARCODEWIZLib and set Embed Interop Types to False and Copy Local to True.

Next, select stdole and set Embed Interop Types to False.

AxBarCodeWiz is now available in the toolbox. Drag it onto a form as you would any other control.

Code:-

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Drawing.Printing;
namespace WindowsApplication1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
// Set the barcode properties.
axBarCodeWiz1.Symbology = BARCODEWIZLib.enumSYMBOLOGY.Code_128_Auto;
axBarCodeWiz1.Barcode = "HELLO 123";
PrintPreviewDialog pp = new PrintPreviewDialog();
PrintDocument pd = new PrintDocument();
pd.PrintPage += new PrintPageEventHandler(pd_PrintPage);
pp.Document = pd;
pp.ShowDialog(this);
}
private void pd_PrintPage(object sender, PrintPageEventArgs ev)
{
// Add the barcode at position (100,100).
ev.Graphics.DrawImage(axBarCodeWiz1.Picture, 100, 100);
// No more pages, let's print.
ev.HasMorePages = false;
}
}
}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sanjay Kumar5y ago
QRCode ActiveX Control MS Access Using .net
First of all

- Open your Visual Studio and you might be tempted to import the ActiveX control Barcodewiz.dll by clicking on Tools > Choose Toolbox Items > Com Components > Browser
However, visual studio does not import the properties correctly. when accessing the picture property in a project compiled for x64 OR Any CPU, an exception (A generic error occurred in GDI+) is thrown.

Instead, use the supplied Interop Assemblies as outlined in the steps below to ensure compatibility with both 32 and 64-bit projects.

Step 1. Add AxBarCodeWiz to Toolbox

Click on Tools > Choose Toolbox Items...
Now .NET Framework Components selected, click Browse...

Now Select AxBARCODEWIZLib.dll. The default location of the file is:

C:\Program Files (x86)\BarCodeWiz ActiveX\DLL\Interop\AxBARCODEWIZLib.dll

Step 2. Add reference to BARCODEWIZLib.dll

Click Project > Add Reference...

Click on the Browse tab and select BARCODEWIZLib.dll. The default location of the file is:
C:\Program Files (x86)\BarCodeWiz ActiveX\DLL\Interop\BARCODEWIZLib.dll

Step 3. Edit Properties

In Solution Explorer click on BARCODEWIZLib and set Embed Interop Types to False and Copy Local to True.

Next, select stdole and set Embed Interop Types to False.

AxBarCodeWiz is now available in the toolbox. Drag it onto a form as you would any other control.

Code:-

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Drawing.Printing;
namespace WindowsApplication1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
// Set the barcode properties.
axBarCodeWiz1.Symbology = BARCODEWIZLib.enumSYMBOLOGY.Code_128_Auto;
axBarCodeWiz1.Barcode = "HELLO 123";
PrintPreviewDialog pp = new PrintPreviewDialog();
PrintDocument pd = new PrintDocument();
pd.PrintPage += new PrintPageEventHandler(pd_PrintPage);
pp.Document = pd;
pp.ShowDialog(this);
}
private void pd_PrintPage(object sender, PrintPageEventArgs ev)
{
// Add the barcode at position (100,100).
ev.Graphics.DrawImage(axBarCodeWiz1.Picture, 100, 100);
// No more pages, let's print.
ev.HasMorePages = false;
}
}
}