Microsoft Access 2016 Insert Columns while using Query Design

[N2Life]

In previous versions, if I wanted to add additional columns to the query design grid, I would highlight as many columns as I wanted to be added, then would click Insert Columns at the top of the screen. This does not work in version 2016. I don't know why Microsoft has not corrected this yet. Has anybody found a work-around?

​

 

[dhookom]

I see "Insert Columns" on the design ribbon.

Duane
Vevey, Switzerland
Hook'D on Access
MS Access MVP 2001-2016

 

[strongm]

One apparent workaround is to add the Insert Columns icon onto the Quick Access toolbar, and use that rather than Query Tools>Design ribbon option.

 

[N2Life]

dhookom, I also see "Insert Columns" on the design ribbon. It just doesn't work.

strongm, I had already put the Insert Columns icon on the Quick Access toolbar. It does not work either. It is also interesting that when I click on "Insert Columns" on the design ribbon, it gets greyed out, as if it "thinks" it has properly done its job.

 

[N2Life]

I finally found the answer. Here are the steps:

1. Select the column where you want to insert a new column.
2. Click on the "Insert Columns" on the design ribbon.
3. This is the kicker: Now hit the "Insert" key on your KEYBOARD! This works.

In no other version of Access have I been required to do this. But at least now I know what to do.

 

[dhookom]

N2Life,

I don't have to hit any other key after clicking the Insert Columns icon on the ribbon. Something is wonky with your installation. Do you have the same issue will all of your Access 2016 files?

Duane
Vevey, Switzerland
Hook'D on Access
MS Access MVP 2001-2016

 

[N2Life]

dhookum, it doesn't matter which file I am working with. Apparently this is not that uncommon. I found the advice to hit the Insert key during an internet search. I am content and consider the matter closed. Thank you for your input on this.