Custom Made Controls for Access

[martyleo]

Dear all,

I wish to create a custom made form control for Access, but don't know how.

It needs to be data-aware, ie it needs to connect to any record source.
Does anybody know how to do it? Can I do it with C#? Or does it have to be C++?


Thank you in advance.
Martyleo

 

[Ranman256]

You can make it in C, or .Net.
You'd then add it thru the controls tab.

 

[martyleo]

You can make it in C, or .Net.
You'd then add it thru the controls tab.

Can I build it with C# ?

 

[arnelgp]

you're thoughts are so advance.
does the basic controls in access cannot satisfy your
requirement.

 

[The_Doc_Man]

The question is whether you are looking for something that is unique because of its appearance or because of its behavior? There are ways to create a customized control as a special class object and you can change its behavior that way. If the issue is not behavior but appearance, can't help you as I've never tried that.

 

[martyleo]

The question is whether you are looking for something that is unique because of its appearance or because of its behavior? There are ways to create a customized control as a special class object and you can change its behavior that way. If the issue is not behavior but appearance, can't help you as I've never tried that.

Hello The_Doc_Man, thank you for your response. The issue is related to behaviour.

I wish to create a list box with special behaviours --- one that displays data of 2 levels, the first level can expand (shows 2nd level data) and collapse (hides 2nd level data).

For example:

Collapsed:
2020 May
2020 April

1st Row Expanded:
2020 May - 1st - Appointment #1
2020 May - 4th - Appointment #2
2020 April

 

[isladogs]

You should be able to use a treeview control for this. There is an ActiveX treeview control built in to Access or there are various third party controls available e.g. https://jkp-ads.com/Articles/treeview.asp
See also https://www.codekabinett.com/rdumps.php?Lang=2&targetDoc=mscomctl-treeview-x64-access and https://mytreeviewblog.blogspot.com/

 

[martyleo]

You should be able to use a treeview control for this. There is an ActiveX treeview control built in to Access or there are various third party controls available

I am aware of the treeview control, but I want to build something that looks like a list box. Exactly like a list box.
Also, I wish to do it myself using C# or something else.

 

[isladogs]

OK. Good luck with your project

 

[arnelgp]

you can use a Datasheet with SubDatasheet as it's child.

 

[Pat Hartman]

I don't want to discourage you but based on the questions you're asking, you probably need a lot more knowledge of both Access and the platform you want to use to develop the ActiveX control.

As arne suggested, you can use a subform in DS view and click the + sign to expand the subdatasheet. That will look like what you are asking for and not require developing a new control.