Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Keeping Look Ups in a Make Tabel Query

Posted on 2010-01-03
Medium Priority
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 43

Accepted Solution

pcelba earned 1500 total points
ID: 26165730
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

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

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem: You created a new custom form in Outlook for your contacts (added fields, deleted fields, changed the layout of fields, whatever) and made it the default form for contacts. The good news is that all new contacts will utilize the new form. T…
As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

580 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