Moving tables to Custom Folders (1 Viewer)

sportsguy

Finance wiz, Access hack

Local time

Yesterday, 20:33

Joined

Dec 28, 2004

Messages

358

• May 16, 2019

• #1

Is there any VBA which has been written to move tables into custom folders?

I have some VBA which deletes and reattaches tables which makes people saving the front end and back ends to their local drives from the network a single click. I use it when moving tables from front end dev to back end prod to relink the tables.

just curious, thanks in advance
sportsguy

 

theDBguy

I’m here to help

Staff member

Local time

Yesterday, 17:33

Joined

Oct 29, 2018

Messages

21,449

• May 16, 2019

• #2

Hi. Not sure I follow. Tables are created in database files. Database files are stored in folders. So, what exactly do you mean by moving tables into folders?

 

The_Doc_Man

Immoderate Moderator

Staff member

Local time

Yesterday, 19:33

Joined

Feb 28, 2001

Messages

27,131

• May 16, 2019

• #3

Are you perhaps exporting and re-importing tables in some way? We need to know just a little bit more than you provided.

 

sportsguy

Finance wiz, Access hack

Local time

Yesterday, 20:33

Joined

Dec 28, 2004

Messages

358

• May 17, 2019

• #4

sorry, within Access, in the custom view, you can create categories, I called them folders. I want to move a table from unassigned to a category. Thanks!

sportsguy

 

June7

AWF VIP

Local time

Yesterday, 16:33

Joined

Mar 9, 2014

Messages

5,463

• May 17, 2019

• #5

Bing: Access Navigation Pane custom groups

https://support.office.com/en-us/ar...ion-pane-ccfb0ee7-d72f-4923-b4fb-ed6c15484244

 

sportsguy

Finance wiz, Access hack

Local time

Yesterday, 20:33

Joined

Dec 28, 2004

Messages

358

• May 17, 2019

• #6

June7, um, I am asking if there is any VBA to move the tables to the custom groups. I know how to use the groups manually, which was the original question in the first post.

So, do you know how to move tables to groups with VBA?

Thanks!

sportsguy

 

isladogs

MVP / VIP

Local time

Today, 01:33

Joined

Jan 14, 2017

Messages

18,209

• May 17, 2019

• #7

This involves writing to system tables. These links may help
https://social.msdn.microsoft.com/Forums/en-US/7bd1d1ca-7363-4e56-9421-c889ceb66f67/how-to-group-newly-imported-tables-using-vba-in-ms-access
https://stackoverflow.com/questions/12863959/access-custom-group

 

June7

AWF VIP

Local time

Yesterday, 16:33

Joined

Mar 9, 2014

Messages

5,463

• May 18, 2019

• #8

I have never bothered with setting custom groups.

Why would users save backend to local drive?