Moving tables within navigation panel

[Me]

I have a macro that create a new table each time I run it.

My Navigation Panel is customized.

Is there a macro that will help with copy/paste (or move) the table to
the particular group?

 

[Jeff Boyce]

It's a bit unusual for a well-normalized relational database to need to
"create a new table". If you'll provide a bit more specific description of
what's going into those tables, folks here may be able to offer alternate
approaches...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Me]

This table is pulled from our financial system that will only contain
'open" acct. I will then link this table to our database to get other
information of this account.

Each month or so, I will run a macro that will delete the old table
and create a new one. From there, reports are make...etc. But to
organize it better, I would like the tables/report move to my
customized panel.

Thank you!

 

[Jeff Boyce]

I'm not sure I have enough information about your "customized panel" to
offer specific suggestions.

Is there a reason you don't just update an existing table? What business
need is being met by "deleting the old table and creating a new one"?

Regards

Jeff Boyce
Microsoft Office/Access MVP

This table is pulled from our financial system that will only contain
'open" acct. I will then link this table to our database to get other
information of this account.

Each month or so, I will run a macro that will delete the old table
and create a new one. From there, reports are make...etc. But to
organize it better, I would like the tables/report move to my
customized panel.

Thank you!

 

[Steve Schapel]

PMFJI. Jeff, I think 'Me' is talking about how/where he wants to display
the table name in the Navigation Pane.

--
Steve Schapel, Microsoft Access MVP

I'm not sure I have enough information about your "customized panel" to
offer specific suggestions.

Is there a reason you don't just update an existing table? What business
need is being met by "deleting the old table and creating a new one"?

__________ Information from ESET Smart Security, version of virus signature database 4225 (20090708) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Jeff Boyce]

You might be right -- I clearly am missing something here...<g>

Jeff