How to copy paste Access Headers from datasheet view?

[AYA]

Hello,

I have a question regarding copy-pasting the access headers.
I want to copy paste Access headers from a design view from one acess file to another file in the same format.
Currently I can only copy-paste them one by one. Does anyone know how to copy paste it column by column?

Thank you in advacne.

BR,


AYA

[CJ_London]

a bit confused by what you are asking
can you clarify what you mean by access headers - do you mean column headers? or perhaps labels/controls in a form or report header section?
and what do you mean by 'another file in the same format' - is this a table (or form or report) in another db, a text file or excel perhaps?
and how does copy paste one by one differ from copy paste column by column?

[ItsMe]

I am also having difficulty understanding what you need to accomplish and what you have in front of you.

While in Design View of a form, you can select multiple controls in order to copy and paste multiple controls from one Access file to another Access file. You can select multiple controls by using the Ctrl key on your keyboard while you click a control. Also, you can select multiple controls by left clicking and swooping over multiple controls. You can copy selected controls by using the keyboard shortcut, Ctrl + C. Also, you can copy selected controls by using Right Click > Copy.

[AYA]

Hey!

Apologies for not being clear at first.

My starting point:
I need to create an access file(target) that has metadata information about another access file with multiple tables(source).
Thus, I want to go to the design view of my source file tables and copy paste columns describing the field names, field types and comments in the target access file.

So my source file would look like this:

ID Name
10001 Chris

Design View of my source file:

Field Name Field Type Description
ID Text Unique Identifier
Name Text Optional


My new access file metadata viewshould include all tables, I will add a new column with table names).
Field Name Field Type Description
ID Text Unique Identifier
Name Text Optional

Question:
Is it possible to go to design view of my source file, copy the header and the field information (e.g. select and copy the whole column or the whole table in the design view instead of a single cell) and then paste it in another access file or another table within the same access file.

Thank you very much in advance.

[AYA]

Hey!

Apologies for not being clear at first.

My starting point:
I need to create an access file(target) that has metadata information about another access file with multiple tables(source).
Thus, I want to go to the design view of my source file tables and copy paste columns describing the field names, field types and comments in the target access file.

So my source file would look like this:

ID Name
10001 Chris

Design View of my source file:

Field Name Field Type Description
ID Text Unique Identifier
Name Text Optional


My new access file metadata view should include all tables, I will add a new column with table names).
Field Name Field Type Description
ID Text Unique Identifier
Name Text Optional
Question:
Is it possible to go to design view of my source file, copy the header and the field information (e.g. select and copy the whole column or the whole table in the design view instead of a single cell) and then paste it in another access file or another table within the same access file.

Thank you very much in advance.

[CJ_London]

to copy and paste, no. But you can reference the tabledefs collection and have a bit of vba to populate another table

[AYA]

to copy and paste, no. But you can reference the tabledefs collection and have a bit of vba to populate another table

Thanks for the response.
1) Can you maybe share some more information on how to reference the tabledefs collection?
2) I am more familiar with SQL than VBA. Would it be possible to use SQL instead of VBA?

Thank you.

[CJ_London]

you can't use sql to access tabledefs.

to access the tabledefs collection you use

currentdb.tabledefs

for a particular table it would be

currentdb.tabledefs("myTable")

and to loop through all the tables it would be for example

dim tdef as tabledef

for each tdef in currentdb.tabledefs
     debug.print tdef.name
next tdef

and to access the individual fields, you reference the tabledef fields collection

dim fld as dao.field
for each fld in tdef.fields
    debug.print fld.name; fld.type
next fld

put it all together and you have

dim tdef as tabledef
dim fld as dao.field

for each tdef in currentdb.tabledefs
     debug.print tdef.name
     for each fld in tdef.fields
         debug.print fld.name; fld.type
     next fld
next tdef

or if you just want a specific table

for each fld in currentdb.tabledefs("myTable")
     debug.print fld.name; fld.type
next fld

[AYA]

Thanks for the response.

I must admit I ended up using excel to save time.
However, your tips seem helpful.
Can I ask where you would write these commands? (e.g. SQL scripts would go in the SQL view)

Thanks.

[ItsMe]

While in design view of a form, you can open the VBA editor using Ctrl + G on your keyboard or by clicking the View Code button within the Ribbon. Code is placed in Procedures. You can create new procedures by typing them out. You can also create event handlers from design view of your form. By selecting a control, like a Command Button, you can view the available events from within the property sheet. Under the "Event" tab, you can click the ellipses(...) next to a corresponding event and then select "Code Builder".