Recent content by annaO

Yes, i will try the id user option then. Thanks

Hi, i already run insert into before copy/paste into a vba code, and also through append queries. i think i'll re-write with insert into instruction, despite the fact that, i would have like to have a copy/paste operation for each table. thanks

Hi, manually it works for me but not with a code. I'll try insert into with fields i will want. maybe it will be better. I did not get the code you wrote? where do i add it in my previous code above?

Hi Doc, thank you for your answer. Actually i got this DB (newly recruited) and the project team filled this global DB by copy and paste all records from a db to another since 3 years. For the main tables OS and OC, the copy and paste is blocked when there is a violation of the PK, therefore it...

Hi. Each team member collects information and fills his database. there is no "front" database. these are independant DB. At the end, we want a global db with all records from all team members. Now what i do is to 1) copy a team member db that i recalled "global" for example 2) open table A...

you are right. Actually i want to select 14 tables only, others are only droplists. But i think i will just have to add the ones i dont want in the "if not" condition, with the system tables

Hi, yes i tried. that is why i said i got this 2046 error. Actually i would like to select only ten tables only, but i dont find how to write it.

Hi, I am ignorant in coding and in VBA and i am trying to copy/paste several records from several tables from a db to tables to another. At first, the code included an "insert into" but it couldn't work due to autoincrement id. However, when i copy/paste manually, it works. When i try to launch...

Hi I am a new member, very beginner in Access. I am from France and i try to search for solutions before asking questions. I work in GIS and Agile Projects. However i am not familiar with coding, just a little bit of each, which brang me to mix process and coding which is never optimal. I'd like...