{"id":1347,"date":"2019-10-13T21:57:47","date_gmt":"2019-10-13T21:57:47","guid":{"rendered":"https:\/\/portasftpserver.com\/?p=1347"},"modified":"2021-02-04T16:12:14","modified_gmt":"2021-02-05T00:12:14","slug":"ms-access-net-activex","status":"publish","type":"post","link":"https:\/\/portasftpserver.com\/ms-access-net-activex\/","title":{"rendered":"MS Access & .Net ActiveX"},"content":{"rendered":"\n
\"\"<\/a><\/figure><\/div>\n\n\n\n

In this blog, I am going to show how to make your own ActiveX control<\/em><\/strong> using .Net Class library<\/strong> in c# and use it in MS Access \ud83d\ude42<\/p>\n\n\n\n

What is ActiveX? <\/h2>\n\n\n\n

ActiveX is a Microsoft-created technology that enables different software applications to share information and functionality. ActiveX only works with Microsoft applications like Word, Excel, Internet Explorer and PowerPoint, and will only work on a computer running the Windows operating system. Credit to https:\/\/entertainment.howstuffworks.com<\/a><\/p>\n\n\n\n

In short, ActiveX is a framework created by Microsoft that adapts its earlier Component Object Model (COM) and Object Linking and Embedding (OLE) technologies. ActiveX gives programmers the freedom to create additional libraries or controls that can be shared in different windows applications.<\/p>\n\n\n\n

Without going into too many details about what ActiveX is let’s make our own ActiveX in c# and use it in MS Access to make you understand it better.<\/p>\n\n\n\n

Create the .Net Class Library<\/h2>\n\n\n\n

In your visual studio, go to create a new project and select class library<\/strong> in C# or VB I am using VS 2019 but you can use earlier versions of it.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

\nName the project to “ActiveXDotNet” you can choose whatever you want.\n\n<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Make sure that you have installed .Net Framework 4+. I am using the .Net Framework 4.7.2.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Create the Message Box Procedure<\/h2>\n\n\n\n

Right click the Reference and add\/Ticked the “System.Windows.Forms”. This will enable us to make a basic message box.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Create a User Controls<\/h2>\n\n\n\n

Right-click the project and go to add->User Control (Windows forms) and create\/add a User Controls. I will just leave the default name. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

In the user control import a button and change the text properties to “Click Me” <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Double click the button or go to events (with the lightning symbol) and double click the “click” button.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Put the message box to button event within user control<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Right-click the project and go to properties, In Application, click the “Assembly Information” and in the pop-up window check\/ticked the “Make assembly COM-Visible” and click “Ok”. This enables the ActiveX Interface to be visible in Access. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Under build, Check\/Ticked “Register for COM interop”<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Registering COM<\/h2>\n\n\n\n

In User Control use System.Runtime.InteropServices, Microsoft.Win32m and System.Reflection. Put the ID and enable the class interface to be accessible.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

The ComRegister Function<\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

The ComUnregister Function<\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

Now save the project and close it completely and open the visual studio as Administrator. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

You should be able to see the recent project. If you can’t see it just simply browse the project from the directory where you save it.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Make a new CPU configuration. In my case I am using 64 bit so I would select “x64”. You can change the “Debug” to “Release” but make sure to check the project properties setting that everything are still the same. \ud83d\ude42<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Right-Click<\/g> the project and select “Build”. NOTE <\/strong>that you should open V<\/g>isual<\/g> studio as Administrator, So it can register the library (DLL) to your local registry.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Create MS Access Form<\/em><\/h2>\n\n\n\n

\n Type “Access” in windows search and select “Access” App \n\n<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Create a blank Database<\/g> and name it to “myMSAccess” you can choose whatever you want. Select “Create” and select “form design” and it will get you to new “Form1”.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

In “Design” import\/select the button <\/strong>in the Form1 design<\/strong> and change the Caption <\/strong>properties to “Call myMsgBox”. This button will call the myMsgBox <\/strong>Function\/Procedure from our customize ActiveX library functionalities.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Click the down arrow in the controls <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Click ActiveX Control <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

You can see that “ActiveXDotNet.UserControl1” is already registered. Select it and click ok<\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Now we can see that the controls from .Net Class Library are now accessible in Access. If you click the “Click Me” you should be able to see MessageBox.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Accessing the myMsgbox in class1<\/em><\/h2>\n\n\n\n

Now let’s call the procedure “myMsgBox” from class1 that we created in c# .Net Class library. Click the button “Call myMsgBox” set the event to “[Event Procedure]” and click the button\/icon with “…” on it.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Once you get to the VBA code behind go to tool->References<\/strong>. You can see that ActiveXDotNet class is now accessible. Check\/Ticked it and click ok<\/strong>.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Initiate the class and call the “myMsgBox” procedure <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Right-click the form and select “Form View” <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Click the button and the message box from “myMsgBox” procedure from class1 will appear <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

That’s all \ud83d\ude42 Kindly share this awesome blog \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"

In this blog, I am going to show how to make your own ActiveX control using .Net Class library in c# and use it in MS Access \ud83d\ude42 What is ActiveX? ActiveX is a Microsoft-created technology that enables different software applications to share information and functionality. ActiveX only works with Microsoft applications like Word, Excel, […]<\/p>\n","protected":false},"author":1,"featured_media":1351,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[127,129,126],"class_list":["post-1347","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-programming-software","tag-activex-from-net-with-ms-access","tag-create-your-own-activex-for-ms-office","tag-how-to-make-activex-in-net-for-ms-access"],"_links":{"self":[{"href":"https:\/\/portasftpserver.com\/sera-json\/wp\/v2\/posts\/1347","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/portasftpserver.com\/sera-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/portasftpserver.com\/sera-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/portasftpserver.com\/sera-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/portasftpserver.com\/sera-json\/wp\/v2\/comments?post=1347"}],"version-history":[{"count":0,"href":"https:\/\/portasftpserver.com\/sera-json\/wp\/v2\/posts\/1347\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/portasftpserver.com\/sera-json\/wp\/v2\/media\/1351"}],"wp:attachment":[{"href":"https:\/\/portasftpserver.com\/sera-json\/wp\/v2\/media?parent=1347"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/portasftpserver.com\/sera-json\/wp\/v2\/categories?post=1347"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/portasftpserver.com\/sera-json\/wp\/v2\/tags?post=1347"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}