Forum Discussion
Help Needed: Trouble Filtering and Re-Entering Data
Hi,
I've attached what I’ve started so far.
I don't see an attachment to your post. Do others?
...currently, it still says the data has already been entered, even after deletion.
What do you do to check for duplicates?
Servus
Karl
****************
Access Forever News DevCon
Access-Entwickler-Konferenz AEK
- MathijsSerlieAug 10, 2025Copper Contributor
Hi Karl,
I try it again, my last reply didn't go trough.
attached you find what i managed to do myself.
I check for duplicates using UUID.attachment is not working, try pictures
- MathijsSerlieAug 09, 2025Copper Contributor
Hi Karl,
Sorry if you get this reply more than once, I’m not sure if I’m doing something wrong.
I check for duplicates with uuid. Tried to upload what I’ve made so far, but it wouldn’t let me.
Mathijs
https://gyazo.com/f6f789fa6e8b8ad26041fba473153fd0
https://gyazo.com/8b608f520274c41c1f49c27449bc3bad
https://gyazo.com/c069be3f68584b67349e32d490e2448e
- MathijsSerlieAug 09, 2025Copper Contributor
Hi Karl,
Sorry if you get this reply more than once, I’m not sure if I’m doing something wrong.
I check for duplicates with uuid. Tried to upload what I’ve made so far, but it wouldn’t let me.
Mathijs
- MathijsSerlieAug 09, 2025Copper Contributor
I check for duplicates with uuid.
I try to attached what i have made so far, but it doesn't let me
- Aug 11, 2025
Hi,
My question was about what you technically do to check for or prevent duplicates.
- Your first screenshot shows that you wrote "Primary Key" as description for the UUID field. In reality, the Primary Key is set to the Autonumber field ID. Is there a unique index also set for the UUID field or is the duplicate check done only in code or wherever?
- Your other screenshots show a form with an import button. Technically it would be necessary to see the code (or macro) behind the button if it is relevant for the duplicate check.
Servus
Karl
****************
Access Forever News DevCon
Access-Entwickler-Konferenz AEK- MathijsSerlieAug 11, 2025Copper Contributor
- Your first screenshot shows that you wrote "Primary Key" as description for the UUID field. In reality, the Primary Key is set to the Autonumber field ID. Is there a unique index also set for the UUID field or is the duplicate check done only in code or wherever?
- MathijsSerlieAug 09, 2025Copper Contributor
I use uuid to check for duplicates.
I try to upload what i made so far, but it doesn't let me