Hi All,
I am new to Access so please be gentle,
I have a form which I want to be able to paste data in from another Access database.
I do not have any permissions on the other database so I have to copy the table data out.
What I want to do is to paste the data into a Form named Job Review, once I paste the data it will then lookup data in another table (Table2) (3 columns total) and then fill the 3 Columns on the Form database with the found data, basically a for loop.
Columns 20+21+22 are the 3 columns that will have the found lookup qtys.
I use a for loop in excel and it achieves this, however my boss wants the data in an Access database so any worker can then use it, but not in our work database.
I tried making two tables and a query and creating a relationship, but as the primary key data is located in column 15 not column 1 (it is not selected as primary key as new records get pasted) it keeps giving me the null error, yet if I remove the primary key from the second table then I can no longer paste into my form table, I tried loading my data into the form with the actual part number column in column one and it works, but not if it is in column 15.
Basically each time I paste the data into the form it is completely new data that needs to then lookup data in other columns of a table which does get updated by the form if I change any data in the 3 columns.
Thanks
I am new to Access so please be gentle,
I have a form which I want to be able to paste data in from another Access database.
I do not have any permissions on the other database so I have to copy the table data out.
What I want to do is to paste the data into a Form named Job Review, once I paste the data it will then lookup data in another table (Table2) (3 columns total) and then fill the 3 Columns on the Form database with the found data, basically a for loop.
Columns 20+21+22 are the 3 columns that will have the found lookup qtys.
I use a for loop in excel and it achieves this, however my boss wants the data in an Access database so any worker can then use it, but not in our work database.
I tried making two tables and a query and creating a relationship, but as the primary key data is located in column 15 not column 1 (it is not selected as primary key as new records get pasted) it keeps giving me the null error, yet if I remove the primary key from the second table then I can no longer paste into my form table, I tried loading my data into the form with the actual part number column in column one and it works, but not if it is in column 15.
Basically each time I paste the data into the form it is completely new data that needs to then lookup data in other columns of a table which does get updated by the form if I change any data in the 3 columns.
Thanks