Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by TeddyTerrier

  1. TeddyTerrier

    Variable table name and Variable Criteria for Append Query

    Thank you Golom. I tried your code and I got an error that indicated that I needed another '. I added one at the end of the code : ..... gTableName & "'))",-1 and it worked great. Thank you so much. TeddyTerrier
  2. TeddyTerrier

    Variable table name and Variable Criteria for Append Query

    I need to append data from one table (Transfer) to 1500 different tables without keying in the table names or the criteria for the query to use. I have been able to get the data to go to the correct table, but the I am having to type in the criteria for the filter. Here is what I have done...
  3. TeddyTerrier

    Table Name for Append Query

    Thank you very much Gary. I just tried your suggestion and it worked perfectly. Primm
  4. TeddyTerrier

    Table Name for Append Query

    I need to append some data to about 1500 different tables in Access. I would like to append the data to the different tables without having to specify the destination table for each table. I have a field in the original table (table that I am getting the appending data from) that has the...
See more

Part and Inventory Search

Back
Top