Change Table Name

  • Thread starter Thread starter Soniya
  • Start date Start date
S

Soniya

Hi All,

I have Tbl2001, Tbl2002, Tbl2003 etc in my access database

When I use Excel to query for a record in the table, is it possible to
change the table name through code?

when i try to use excel exits without any warning message..

I am trying to do this thru a userform in which one combo selects the
year and based on the year value i want to select table Tbl+year value
in the combo.

TIA
soniya
 
Can you post the code you are using to get the data from the correct table?

Alok Joshi
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting Record Source in Report_Open Event 2
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Linking Combo Box Values to Access Table 2
VBA - retrieve data on last create named range from previous inserted named range 0
How to Populate Data from a table to another 0
Change multple table names 6
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Update Pivot Table Filters based on a Cell Value in Excel 2007 0

Back
Top