Sep 27 2007, 08:53 AM
I have set up a form to run on a query and all is working well. The query is a "make table query" that runs and then opens a form based on that newly created table. I have been able to get rid of the messages asking if it is ok to make the table, and to run the query etc. Perfect. But I still get the message:
The existing table tblNEW will be deleted before you run the query. Do you want to continue anyway? Yes or No
I want this to default to yes so the user doesn't even see this. How do I do that?
Thanks for your help.
Sep 27 2007, 08:59 AM
Delete the table first, don't use the Make table to overwrite it.
Sep 27 2007, 09:09 AM
Is there a reason why you have to run a MAKE TABLE each time? It would be much more efficient if you just deleted the records in the table and then appended new records. Plus it would help with database bloat.
Sep 27 2007, 09:26 AM
I have been trying to figure out a simple way to accomplish what I need to do. I am not an expert access programmer which is why I have posted here for help. What I am needing to do is this:
I set up a form (with a subform linked) in that autopopluates fields from 3 linked tables (they are outside ODBC source tables). The problem is I need to save all of the linked fields and new data entered fields in to 1 table for historical purposes as a new record. I am sure it is simple but I have been unable to figure it out. That is where I came up with the make table query to always have a copy of the combined fields.
Any help is appreciated.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here