How To get Controls names in specific form without dynamic execution

Question

0.00/5 (No votes)

See more:

iam new to access
and may be my question is not right
when i want to get all controls names in specific form i am using the following
for each ctrl in me.controls
and i add ctrl.name to a table to get all controls names
but if have a lot of forms like 200 forms i have to open all the forms to get all controls names in the current project
is there any design file that contains controls names
i mean with out the need to get these names dynamically at run time

Posted 10-Sep-15 0:39am

oula alsheikh

Updated 10-Sep-15 1:34am

v2

Add a Solution

3 solutions

Solution 2

Have a look here: Enumerate all controls on a form[^]

Posted 10-Sep-15 10:11am

Maciej Los

Comments

oula alsheikh 12-Sep-15 2:42am

thanks but this solution includes form open i mean the form must be opened at run time to get its controls
what i need and maybe is impossible is a way to get the controls with out the need to open the form at run time

Solution 1

Try C# code:

C#

var controlType = typeof(Control);// or UserControl
            var control= Assembly.GetExecutingAssembly()
         .GetTypes()
         .Where(t => controlType.IsAssignableFrom(t) &&
          t.Namespace == "YourNameSpace").ToList();

Posted 10-Sep-15 1:25am

Bob Stoom

Comments

oula alsheikh 10-Sep-15 7:33am

thanks but i want access code i mean vba

Bob Stoom 11-Sep-15 12:08pm

It's an idea only. Try it yourself.

Maciej Los 10-Sep-15 16:03pm

C# code in MS Access? It's impossible!

oula alsheikh 11-Sep-15 18:12pm

that's right there is a huge difference
between c# and access

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Gustav Brock · Accepted Answer · 2015-09-13T00:15:00

Solution 3

Here is how:

VB

Public Sub ListFormControls()

    Dim obj As Object
    Dim frm As Form
    Dim ctl As Control

    For Each obj In Application.CurrentProject.AllForms
        DoCmd.OpenForm obj.Name, acDesign, , , , acHidden
        Set frm = Forms(obj.Name)
        For Each ctl In frm.Controls
            Debug.Print frm.Name, ctl.Name
        Next
        DoCmd.Close acForm, obj.Name, acSaveNo
    Next
    
    Set ctl = Nothing
    Set frm = Nothing
    Set obj = Nothing
    
End Sub

Posted 13-Sep-15 0:15am

Gustav Brock

Updated 13-Sep-15 21:59pm

v2

Comments

oula alsheikh 14-Sep-15 3:24am

thanks a lot you cant imagine how much happy i am
because i searched alot and all the solutions i founded needed the form to be opened in run mode
and how much difficult it will be to get controls in this way
i really admire your efforts

Gustav Brock 14-Sep-15 4:00am

Thanks. You may mark with a five-star. Note please, that I changed acSaveYes to acSaveNo which makes more sense as no changes are done.