Moving tables within navigation panel

  • Thread starter Thread starter Me
  • Start date Start date
M

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?
 
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
 
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!
 
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!
 
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


Jeff Boyce said:
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"?
Click to expand...



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

The message was checked by ESET Smart Security.

http://www.eset.com
 
Back
Top