Macro to copy entire column from table

[coucar3456]

I'm trying to figure out how to copy all records from one column or field. I just below Macro and it only copies the first record:

Open Table: tbl_Equipment

GoToControl: Equipment

RunMenuCommand:Select Entire Column

Run Menu Command:Copy

 

[Green Crocodile]

If trying to copy entire column on the worksheet

Sub copyColumn()
Range("E:E").Copy
End Sub

If trying to copy specific column on table

Sub copytblCOLUMN()
Range("tbl_Equipment[Equipment]").Copy
End Sub

 

[Micron]

Not sure that solution applies. This is the Access part of the forum and I'd venture to say there's no such thing as a Range in Access.
Once you copy a field in this manner, then what are you doing with it? You cannot simply paste. You must paste append. I don't use macros, so you'll have to see if there's a paste append command in Access macros. It could be a Docmd.Runcommand method.

 

[Green Crocodile]

Micron, you are correct. I didnt notice i was still in the access section. Must have forgot to switch over.