Hi, up to now I have been using a single master table for my inventory,
with
all of the duplicate date. I have figured out how to split the table so
that
it works quite well, eliminating the duplicate data. But I can't figure
out
how to add to the tables without doing it one at a time through a form. I
need to be able to update the tables with thousands of records at a time.
How do I do this? Thank you, Hoop
Re: Export table1 from db1 to db2 from db3 ...duplicate copy of a table... ... using update queries to "load" a copy? ..."Ross" wrote in message ... > How can I export a table in one external databse to a second external ... (microsoft.public.access.modulesdaovba)
Re: duplicates query help & strategy for update queries with SetWarnings = False ... I have many many queries that check for orpaned data (for example, if there's a billing record with no matching custID in the customer table, I'm putting up a form with the unmatched data, and a quick way to update all unmatched to one archive type customer, etc. ... I was surprised to see duplicate entries in some of the static tables for dropdown selections, so I have to solve this one now. ... Once the user has handled all the problems, you enable the final command button at the bottom of the form, which executes an append query to add the data to the real table. ... (comp.databases.ms-access)
RE: Please help with duplicate recods (form, subform) code ...Private Sub btnDuplicate_Click ... ' Tag property to be used later by the append query.... ' Run the Duplicate Order Details append query which selects all ... (microsoft.public.access.formscoding)
Re: Copy Record within Same Table ... if you can write a Select query to pull the records you want to duplicate,... then turn the query into an Append query and append the recordback to ... > has two fields containing values (barcode1 and/or ... (microsoft.public.access.modulesdaovba)
Re: duplicates query help & strategy for update queries with SetWarnings = False ... After playing around with duplicates, and a funtion to generate an occurence number, it looked like you would need a handful of queries per table!! ... Once the user has handled all the problems, you enable the final command button at the bottom of the form, which executes an append query to add the data to the real table. ... On a "Find Duplicates Query", does anyone have a good solution for renaming the duplicate records? ... (comp.databases.ms-access)
