Keeping Look Ups in a Make Tabel Query

Posted on 2010-01-03
Last Modified: 2013-11-24
I need to start a new a new table from a make table query. When I make the new table although I lose all my drop down lists for the user to select information from fields. Is there any way to keep the same previous table format and drop down lists when making this new table?
Question by:NuclearOil
    LVL 41

    Accepted Solution

    Instead of creating new table delete all records from existing table and insert new ones. You may do it as a query:

    1) Delete all rows
    DELETE FROM YourExistingTable

    2) Insert new records
    INSERT INTO YourExistingTable (ColumnName1, ColumnName2, ColumnName3, ...)
      VALUES (Value1, Value2, Value3, ...)


    INSERT INTO YourExistingTable (ColumnName1, ColumnName2, ColumnName3, ...)
      SELECT ColumnX, ColumnY, ColumnZ
        FROM AnotherExistingTable

    Author Closing Comment

    That gave me an idea to do it from a macro thanks.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    MS Access 2003 or later To MySQL Migration Project Hello All, this is my second article in the category of MS-OFFICE Automation. In internet I am not able to find any comprehensive resource on the Migration of MS Access back-end to MySQL so I fin…
    This very simple solution applies to a narrow cross-section of the "needs to close" variety. In this case, the full message in Event Viewer was in applog, Event ID 1000: Faulting application iexplore.exe, version 8.0.6001.18702, faulting module …
    The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
    The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now