whoo hoo it worked!... but now how do I get the form to read the whole 5000 records (the union of all the 4 tables) instead of just one table at a time?
Dear Genii...
I have 4 tables containing data, I have one form with a pretty UI - I need to get all the tables to show up when the people open the form.
I can either - import all data into one table - how do you do that? I can't allow the contact ID numbers to change if possible.
OR I need to...
Hi there.
I am preparing data for some telemarketing for 4 people.
I have a field called 'record owner' in which I want to allocate records to each caller.
How can I select 200 records and name the record owner 'linda', then the next 200 and name 'helen' etc. So tomorrow they can filter by...
Hi , so do I create a special query just for this code...or ?? Create a querie with all the fields I am trying to import and stick the code in there?
Sorry I'm so green, its amazing I have got this far...youre help is appreciated.
Cheers
Magic
Hi there, I have had 4 people doing data entry into 4 separate Acsess dbs.
I now have to merge the data, however alot of the records have the same contact Id which is set by auto numbering.
It wont let me import the data due to conflicts!!
Any help out there please.
I'm a bit of a self...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.