Casey Mccormick

Casey Mccormick

  • NA
  • 3
  • 1.7k

QRCode ActiveX Control MS Access

Jan 19 2021 9:58 PM
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. 

Attachment: ActiveQR.zip

Answers (1)