By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,487 Members | 1,747 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,487 IT Pros & Developers. It's quick & easy.

VBA How to create ActiveX controls

P: 36
Hi

There are some useful ActiveX controls in Access like Date Time Picker etc and I wonder how I can create them myself?

Any links to tutorials or books will be greatly appreciated.


Many thanks
Emil
Jun 28 '09 #1
Share this Question
Share on Google+
9 Replies


ADezii
Expert 5K+
P: 8,679
@IT Couple
I would imagine that the easiest Method of creating ActiveX Controls is via the Visual Basic Programming Language. Any good Reference on VB should point you in the right direction.
Jun 28 '09 #2

P: 36
Hi

Thanks for the reply. I have google the subject and found out that VB6 has has ActiveX control items and others but I don't have VB6 only .net 2008 so far I found the 'user control' might be the same but currently I'm still looking to found out if this is exactly what I want and if I can use it in Access.

Regards
Emil
Jun 28 '09 #3

ADezii
Expert 5K+
P: 8,679
@IT Couple
I'm not a .NET Expert, but from a little research, it looks like this may not be what you are looking for:

------------------------------------------------------------------------------------
VB.Net user controls are those controls that have other controls in them so that they provide a complex functionality if needed. Combining controls to form a VB.Net user control helps you to modularize the code that you are developing for your project.

User controls are created as .ascx file and these are added to the project in the bin directory of the project. After you create a user control you can add them to the tool palette so that you can use them just like any other control in the tool box.

For example you can combine a label and a textbox to create a user control. So whenever you drag and drop this user control from the toolbox you get a label and a textbox together.
------------------------------------------------------------------------------------

P.S. - My suggestion is that you also Post this Topic in the .NET Forum also available here. I'm assuming that once you obtain your answer there, the Control can be deployed within Access just like any ActiveX Control would be.
Jun 28 '09 #4

missinglinq
Expert 2.5K+
P: 3,532
I think Visual Basic 6 and C++ are really the only languages available for ActiveX development. Here's a very good tutorial on the subject, which is actually a chapter from a book dedicated to just this subject. You probably need to pay particular attention to the part where the author explains why this is one of the most difficult areas of programming around and definitely not something for novices to attempt.

http://www.visualbasicbooks.com/activeXtutorial.html

Linq ;0)>
Jun 28 '09 #5

P: 36
Thanks for the information.

It might be a bit too late to use VB6 ;) so I will investigate the subject on .net forum soon.

Regards
Emil
Jun 28 '09 #6

Expert 100+
P: 750
PRR
You can take a look at this article for exposing a dll as activex (for .net).
If its for server side you are better off creating a dll and referencing it in your project.
Jun 29 '09 #7

ADezii
Expert 5K+
P: 8,679
@PRR
Thanks for helping us 'Olde Access Guys' out on this, PRR.

Just for curiosity, once this ActiveX Control is created, can it be utilized within the context of an Access Form in the traditional manner?
Jun 29 '09 #8

Expert 100+
P: 750
PRR
You are most welcome ADezii. I am not entirely sure whether my post was helpful... Active x do have limitations. I guess this might be helpful...
My knowledge is very limited in this area....
Jun 30 '09 #9

ADezii
Expert 5K+
P: 8,679
@PRR
Thanks again, RRR, your Post was very helpful. It appears as though Access does not exclusively rely on the IDataObject Interface that other Offfice Components do in displaying ActiveX Controls.

@IT Couple ==> Let's us know how you make out on this Project, since it does have aspects that relate to this Forum.
Jun 30 '09 #10

Post your reply

Sign in to post your reply or Sign up for a free account.