Insert Existing Fields to forms (1 Viewer)

[jithb4u]

Hy all,
I want to insert existing fields from current table to the form.
I can do it manually in design view...
The field names can vary each time (i did it with import excel spreadsheet method)
But is there any chance to done it with vba code or macro??
Thanks in advance

 

[arnelgp]

you "drag" each fields inside the form.

 

[jithb4u]

you "drag" each fields inside the form.

If a vba code or macro can do this it will be more helpful. Is it possible?

 

[arnelgp]

you don't need macro or vba.
just click on the any table or query.
then on the Ribbon, you click Create->Form.

 

[Pat Hartman]

In an application, you wouldn't be adding objects on the fly. If your data source is variable, you need to do something to stabilize it.

When you are the designer, you can also have the wizard build the form in one of three views. Single record, multiple record, data sheet. If you select a table as the source, all fields from the table will be placed on the form. You can clean it up later if you need to. If you choose a query, then all fields from the query will be placed on the form. Therefore, unless you want all fields, you should probably start by creating a querydef and then letting the wizard work with that.

 

[The_Doc_Man]

If a vba code or macro can do this it will be more helpful. Is it possible?

There is a "wizard" that will build forms for you automatically. Creating it with a VBA module is CERTAINLY possible and CERTAINLY more trouble than it is worth, particularly since there is already a way to do it that does not require additional code.

 

[sxschech]

Maybe this as a starting point?
Search term:
vba to add fields to a form in access

Application.CreateForm method (Access)

Office VBA reference topic

docs.microsoft.com

Application.CreateControl method (Access)

Office VBA reference topic

docs.microsoft.com