Recent content by arnoldg

when i'm at home i go try some things.

what would happen if i import records that ar duplicates, don't i get an error, which says that there are duplicates ?

Hello, tblBedrijven = tblCompanys I'm trying to explain it better, i think that my select isn't right. 1. clear tblImport and load with current export from erp 2. create a select to filter out all records that already ar in the tabel tblCompanys (how do i do this) 3. Copy new records to...

Well it is verry simple, when importing a company ther servicelocation (sl) should be compared int the tblbedrijven, if it is present it shouldent be imported. Why run twice ord more, because the imported table is an export list (Excel) of oure erp. And once in a while i need to update the list...

Hello i'm trying to import a table with companys (tblImport) all records if not doubleshould be imported, but i searched a lot and tryid a lot, but cant get it right. All the time all records are imported, so after several time the recorders are doubled. tblImport.F6 and...

Hello, I'm new here and a newbee with Access and i'm from the Netherlands, so sorry for the bad english :) i'm not realy new with simple databases, but with database i have to learn a bit more on master detail tables and that kind of stuff. For work we work with some general customer excel...